Posted by Erland Sommarskog on 02/06/07 22:37

HC (hboothe@gte.net) writes:
> I tried testing this by scripting an existing database and then using
> OSQL to execute the script and make a new database on MSDE on my dev
> machine (that I use all the time) but it still didn't mark the DB as
> auto_close. But, you are right, MSDE is supposed to, by default, mark
> the databases as auto_close on (I checked BOL). I'm not sure, but it
> seems odd to me that the default behavior the BOL says I should see
> isn't happening which makes me think I'm doing something wrong.

You might have turned off auto-close for the model database as well.
model is a template for all new databases.

As for the rest of your troubles, I'm afraid that I know too little about
your system to say much useful.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Query RowVersion in SQL Server 2005
• Prev in forum: Re: NULLS and ''
• Thread view: Re: Problem: Performance difference between MSDE and SQL Express 2005

[Reply to this message]