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......
LVL 1
rossfisherAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
ALTER DATABASE <Database Name> SET AUTO_CLOSE OFF
0
Anthony PerkinsCommented:
Good one.  Why any database has AUTO CLOSE enabled beats me?  That and AUTO SHRINK have to be the most useless settings ever devised.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

rossfisherAuthor Commented:
thanks rrjegan17

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

Thanks
0
Anthony PerkinsCommented:
How familiar are you with SQL Server Management Studio (SSMS) ?
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
As acperkins mentioned, Open SSMS and then connect to your SQL server / instance and then open a new query window, paste the script provided there and execute it by pressing F5..

Do you have SQL Server Management Studio(SSMS) in your machine first..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rossfisherAuthor Commented:
Hmm what?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.