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 |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2003-12-15 : 11:16:44
|
| HiWe've noticed recently a lot of "information" level messages being logged in the NT Event log by SQL Server. Now, really these just serve as clutter. I know we can filter the view on the Event log to look at errors etc, but what I'd prefer is to stop these messages being sent there from SQL server in the first place.Is there an option that controls this?-------Moo. :) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-15 : 13:03:38
|
| You will need to add a startup parameter to the SQL Server. -n is what you want. An easy way to view this information is to right click on your server in EM and go to properties. Then hit the startup parameters button. -n says to not log the events in the Event log. It is recommended that you keep -e. -e says to log it in the SQL Server error log, but with -n it won't go to the application log in Event Log as well.Tara |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-12-17 : 03:42:15
|
| ooo thanks that will do nicely.-------Moo. :) |
|
|
|
|
|
|
Information Messages in Event Viewer