Re: DB maintenance plan action entry in SQL Server logs

From: Quentin Ran (ab_at_who.com)
Date: 03/09/04 

Date: Tue, 9 Mar 2004 10:40:33 -0600

Thanks Tibor.

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:OG6HNC0AEHA.3944@TK2MSFTNGP11.phx.gbl...
> OK, so we are talking about SQL Server writing these entries.
> SQL Server doesn't log every command you execute. Not even every DBCC
> command. DBCC DBREINDEX is not logged to the errorlog by default, while
> CHECKDB is. You can change this, of course (sp_altermessage).
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Quentin Ran" <ab@who.com> wrote in message
> news:e6LE4xuAEHA.2484@TK2MSFTNGP12.phx.gbl...
> > In EM,
> >
> > server\Management\SQL Server Logs
> >
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
> in
> > message news:uuq2jluAEHA.1420@TK2MSFTNGP11.phx.gbl...
> > > What log is this? What is the source of these log entries?
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "Quentin Ran" <ab@who.com> wrote in message
> > > news:uTISqMtAEHA.3436@tk2msftngp13.phx.gbl...
> > > > Hi group,
> > > >
> > > > looking at SQL Server Logs, I see an entry for all of the actions of
a
> > > > database maintenance plan other than the optimization. When set up,
> > there
> > > > is an entry for DBCC CKECKDB which is for the integrity check; there
> is
> > > > "Database backed up: Database: master, creation ...." for the db
full
> > > > backup; there is "Log backed up: Database: ..." for trans log
backup.
> > The
> > > > only remaining maintenance plan action, optimization, runs "EXECUTE
> > > > master.dbo.xp_sqlmaint ..." with the argument -RebldIdx which I
> believe
> > > > should be a DBCC DBREINDEX. Whatever it runs, there is no
> corresponding
> > > > entry in the SQL Server Logs. How come?
> > > >
> > > > Quentin
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • [NT] DBCC SHOWTABLEAFFINITY Buffer Overflow in Microsoft SQL Server Explained
    ... Microsoft SQL Server 2000 Enterprise Edition, ... Undocumented command DBCC SHOWTABLEAFFINITYcontains exploitable ... xor eax, eax ...
    (Securiteam)
  • Execute Process Task not failing, but not executing the batch comm
    ... I can execute the following command from the windows "Run" prompt and it ... Might I have something set weird in SQL Server? ... server being by default configured to run as localsystem account, ...
    (microsoft.public.sqlserver.dts)
  • Re: ADO.NET Timout
    ... That in turn execute SP ... BeginExecute method of the Command object. ... How can I call a stored procedure to do its thing asynchronously. ... see "Explicit Transactions" in SQL Server Books ...
    (microsoft.public.dotnet.framework.adonet)
  • SqlClient Data Adapter Fill Method
    ... I am having a problem with the SqlClient Data Adapter. ... the problem by placing a trace on my sql server and watching which stored ... method of the data adapter does not appear to execute my command object. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlClient Data Adapter Fill Method
    ... If you are specifying lengths on ... that Sql Server is seeing look ok? ... >>> method of the data adapter does not appear to execute my command ... >>> errors are raised the fill command just returns 0 rows and I do not see ...
    (microsoft.public.dotnet.framework.adonet)