December 31, 2003 at 3:05 pm
I am trying to test to convert sql 7.0 pubs database to sql 2000. First I got the error that there is more than one more connection in the database. So I set the database to single user mode. But now database is opened
so how do I close it? I restarted sql services still it is opened. I looked into books online and could not find how to close the database.
Will greatly appreciate your help.
Thank you and happy new year.
January 1, 2004 at 5:35 pm
check sp_dboption autoclose.
It is designed for lapton with limited resource. It costs in performance as usual.
January 2, 2004 at 3:52 am
/* To automatically close a db when no users are accessing it */
ALTER DATABASE pubs SET AUTO_CLOSE ON
go
However when u use the db , it will be opened again !
so what is the exact test that u are doing?
consider putting db in dbo use only mode.
sp_dboption pubs ,'dbo use only' , true
go
January 2, 2004 at 9:57 am
Wouldn't recommend it:http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply