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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply