asked on

MSSQLServer event id 17137

I have a SBS 2003 Std server running MS SQL 2005. I and getting hundreds of event messages inthe application log:
They are harmless, but they are consantly filling up the event log, making it difficult to see "real" errors. How can I turn off the logging of infomrational errors within MSSQLSERVER?

Event Type:      Information
Event Source:      MSSQLSERVER
Event Category:      (2)
Event ID:      17137
Date:            06/04/10
Time:            14:30:08
User:            xxxx\Administrator
Computer:      2007SBSERVER
Description:
Starting up database 'PI_DBComm'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: f1 42 00 00 0a 00 00 00 ñB......

Raja Jegan R

ALTER DATABASE <Database Name> SET AUTO_CLOSE OFF

Anthony Perkins

Good one. Why any database has AUTO CLOSE enabled beats me? That and AUTO SHRINK have to be the most useless settings ever devised.

Raja Jegan R

Seems like you have AUTO_CLOSE property set to ON for your 'PI_DBComm' database..
Turn it off using the script below and check it out

use master
go
ALTER DATABASE PI_DBComm SET AUTO_CLOSE OFF
go

PS: if you obtain errors, then make sure your database is in Single user mode in order to work.

rossfisher

ASKER

thanks rrjegan17

But being unfimiliar with SQL, where would I be running this script, and how?

Thanks

Anthony Perkins

How familiar are you with SQL Server Management Studio (SSMS) ?

ASKER CERTIFIED SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rossfisher

ASKER

Hmm what?