Sarab. (2/15/2011)
Great Article Rudy.anyways people can also use XP_ReadErrorLog 0,1,'string_you_want_To_search'
like xp_readerrorlog 0,1,'error'
provided you are using SQL Server 2005+ versions
for earlier version this would be a good option.
Thanks Sarab.
Nicely done. Your idea should make it easier to collect the data needed. Once we get rid of our SQL 2000 servers I will update my code.
Rudy
Rudy