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 |
InfraDBA
Starting Member
38 Posts |
Posted - 2011-01-09 : 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 - 2011-01-10 : 04:10:13
|
Is it some kind of joke or something? |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-01-10 : 04:49:37
|
Check out the WITH LOG option of the RAISERROR statement:RAISERROR('Something *reaally* funky happened',16,1) WITH LOGI 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...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-10 : 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 openedTraceflags enabled/disabledSome DBCC commands (not all)Login success if set so in the server propertiesLogin failure if set so in the server properties--Gail ShawSQL Server MVP |
|
|
InfraDBA
Starting Member
38 Posts |
Posted - 2011-01-10 : 06:50:58
|
Thanks for your inputs.Appreciate it. |
|
|
|
|
|