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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Increase error level trapping in the Inatance Logs

Author  Topic 

opowell
Starting Member

12 Posts

Posted - 2011-08-03 : 15:55:55
Good Afternoon first things first

Windows Server 2003 R2
SQL Server 2005 Se SP4 9.0.5057.00

Question: I want to increase the amount of information that SQL Server is reporting on. I spaking of the instance, not a Transaction Log. I have a application stating that a insert if not being committed, and the logs reveal nothing. So I want to up the level of information being collected. I know this will increase the file size. but as always it boils down to Dollars.
Any help on how to change the log level would be winderful.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-03 : 15:58:58
There isn't a flag or anything to capture this. You'll need to run a trace.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -