Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-02-09 : 10:44:27
|
| Guys,Does anyone know whether the information/errors shown under the "SQL Server Logs", under Management in the SQL Server Enterprise Manager are stored in any system table?And if not, where are they stored, and can they be queried in any way?Thanks in advance |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2007-02-09 : 11:07:42
|
| I just found out that the logs are stored here: C:\Program Files\Microsoft SQL Server\MSSQL\LOG. As such, I don't think they exist in any system tables and thus cannot be queried.One other approach to look for specific keywords is to use FINDSTR.EXE windows utility as such, for example: findstr /i /n /c:"error" errorlog. The issue with this, in my case at least, is that to use this I'd have to remotely login into the machine which I'd like to analyze error log in. I am not sure how to perform this from my local machine.Any advice is appreciatedThanks |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-09 : 15:53:37
|
| Personally, I just use PERL to sift the errorlogs for "interesting keywords". PERL is apparently quite content to go to a UNC path. |
|
|
|
|
|
|
Querying SQL Server Logs