Home Forums SQL Server 2005 Administering DBCC command execution History RE: DBCC command execution History

  • February 1, 2010 at 5:48 am

    #1111539

    vstitte (2/1/2010)

    Doesn't xp_readerrorlog take some parameters.

    Correct. I just use the above script as a job to notify me of any certain alerts

    You could try

    EXEC xp_readerrorlog 6,1,'dbcc'

    Change the 6 to be the number of logs you keep...