Wednesday, May 27, 2009

View SQL Server Error log's detail by SQL Commands

Execute the command below to get error logs Archive number.




exec sp_enumerrorlogs






Then execute ;


exec sp_readerrorlog archivenumber





No comments:

Post a Comment

 
span.fullpost {display:inline;}