January 9, 2003 at 9:24 am
A vendor-supplied database was installed yesterday on our SQL2K server, and all appeared to go well. I checked the logs this morning, though, and there are dozens of rows with "Starting up database 'DB Name'". I found that I could create a row by browsing a table. Hmmm. This is the same message that appears ONCE for each DB when you restart SQL Server, usually.
Does anyone know what might cause this? There doesn't seem to be anything unusual about the DB that I can see.
Thanks!
January 9, 2003 at 11:01 am
Auto close is probably enabled.
Andy
January 9, 2003 at 11:47 am
Thanks, Andy. That was it.
January 9, 2003 at 3:34 pm
I had this problem too. I disabled in my Database. Are there any disadvantages of turning this off? Thanks.
January 9, 2003 at 5:01 pm
You don't free up resources not being used. On a personal or low intensity dev machine with lesser resources, it might make sense to enable. In production never makes sense, last thing you want is the occasional user having to wait for SQL to load stuff up again.
Andy
Viewing 5 posts - 1 through 5 (of 5 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