Microsoft Technology
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment