| Author |
 Topic  |
|
|
InfraDBA
Starting Member
38 Posts |
 Posted - 01/09/2011 : 23:32:35
|
| Can SQL server error log be adjusted to show specific messages? Basically what are the default type of messages that SQL server error log would include? |
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 01/10/2011 : 04:10:13
|
| Is it some kind of joke or something? |
 |
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
Posted - 01/10/2011 : 04:49:37
|
Check out the WITH LOG option of the RAISERROR statement:
RAISERROR('Something *reaally* funky happened',16,1) WITH LOG
I was unable to find any info on which specific events that goes to the error log, all I could find was this -> http://msdn.microsoft.com/en-us/library/ms191202.aspx. I do however know that db engine restarts are logged, database backups, result of dbcc commands, deadlocks, start/stop of traces (profiler), various errors of course...
- Lumbago
My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com |
|
|
|
GilaMonster
Flowing Fount of Yak Knowledge
South Africa
4507 Posts |
Posted - 01/10/2011 : 05:35:34
|
Deadlocks aren't logged by default. Only if a traceflag is enabled.
All sev 20+ errors are logged.
Database and log backups, though those can be turned off with a traceflag.
Databases being opened
Traceflags enabled/disabled
Some DBCC commands (not all)
Login success if set so in the server properties
Login failure if set so in the server properties
--
Gail Shaw
SQL Server MVP |
|
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 01/10/2011 : 06:50:58
|
| Thanks for your inputs.Appreciate it. |
|
|
| |
Topic |
|
Sql server error log.
