Search SQL Error Log

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Alejandro Pelc » Search SQL Error Log

Search SQL Error Log

Rate Topic

Display Mode

Topic Options

Author

Message

Ale Pelc

Posted Thursday, March 05, 2009 3:47 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 1,109, Visits: 523

Comments posted to this topic are about the item Search SQL Error Log

Alejandro Pelc

Post #669780

Nancy Georgitsis

Posted Monday, March 16, 2009 9:05 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 06, 2012 1:26 PM
Points: 1, Visits: 254

I am a newbie to sql.
I can get this to work on sql 2005 but not on sql 2000? How can I make it work for sql 2000?

Post #676594

Ale Pelc

Posted Monday, March 16, 2009 7:51 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 1,109, Visits: 523

Hi Nancy,
sorry the delay but I'm on a trip and just saw your post. First of all, it won't work on SQL 2000 because I create a table variable, which is not supported. Second, the sp_readerrorlog procedure exists on SQL 2000, but the parameters are not the same. I'll try to get my hands in one SQL 2000 instance tomorrow and then post back the sp.

Thanks,
Alejandro

Alejandro Pelc

Post #677116

James Morrison

Posted Tuesday, April 14, 2009 9:06 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 12, Visits: 328

Hi there,

I receive this error when I test your script with the following parameters

sp_SearchSQLErrorLog @AllLogs = 0, @LogFile = 1, @SearchString1 = 'login', @SearchString2 = 'sa'

RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'
Msg 50000, Level 11, State 3, Procedure sp_SearchSQLErrorLog, Line 63

Post #696646

Ale Pelc

Posted Tuesday, April 14, 2009 9:23 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:59 AM
Points: 1,109, Visits: 523

Hi James,
That means that one of the log files is not there. I'll review the script to validate that the log file exists.

Cheers,
Alejandro

Alejandro Pelc

Post #696671

Robert Davis

Posted Tuesday, April 14, 2009 9:31 AM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558, Visits: 1,396

There is an easier way to do this. Just use xp_enumerrorlogs.

See my blog post on the subject: Error Logs: Part Two

Also see Error Logs: Part I which also shows you how to do it in SQL 2000.

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #696679

James Morrison

Posted Tuesday, April 14, 2009 9:57 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:25 AM
Points: 12, Visits: 328

Thanks for the info

Post #696710

« Prev Topic | Next Topic »

Permissions