Could someone please help me in following:
One of my database in SQL 2000 going Offline automatically. When i
bring it back Online its Ok for 20/30 minutes and then again appear as
Offline. I had similar problem when one of the database keep going to
'Single user' automatically.
Any idea what happening.
Thank you
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Khalid
It sounds like you have the auto-close option eneabled. You need to
disable it.
Right click on your database in EM, choose properties and then check
the options tab to see if the option is enabled.
Regards
John
