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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy