Search this blog

Wednesday, January 21, 2009

Read SQL error log

In SQL Server Database, There is plenty of external storedprocedure is available.

To Read Error Log, we can use xp_readerrorlog, which is a external SP.

see the following code, it let us know, how to use this SP

This extended stored procedure will return a errorlog file.

EXEC master..xp_readerrorlog

No comments:

Post a Comment