SQL Server Error Logs: What events is it logging? Can we edit and include DDL events?

Question

SQL Server Error Logs: What events is it logging? Can we edit and include DDL events?

jon-168559

SSC Enthusiast

Points: 130
More actions
June 20, 2007 at 4:12 am

#179223

Hello experts. I have been searching for anything about this but found very little. What are the events logged in SQL Server Error Logs aside from Successful/Failed Login, Backup/Restore/Recover database and, start/init sql server? Can we configure this to log other events, like CREATE or DBCC events for example? If so, how? Thanks a lot.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

your DBCC should get logged by default by not all information will be available. I hope you can turn on c2 logging which is a costlier operation to audit all events.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

jon-168559 SSC Enthusiast Points: 130 More actions · Answer 2

Thanks Sugesh. I found an article that in a way answers my question above. Hope this helps to those with the same query. http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx?pf=true