Posted by Erland Sommarskog on 02/05/07 22:20

HC (hboothe@gte.net) writes:
> It turns out, as I'm sure you know, that AUTO_CLOSE defaults to on
> ONLY for SQL Express (not for other versions of SQL 2005 (from my
> reading of BOL)). Turning it off was a huge help to me and my
> program.

As far as I know, AUTO_CLOSE is also on by default for MSDE. Probably
some time in the dim and distant path, you learnt about this, turned
it off, and by now you have forgotten all about it.

Happens to me too. Just watch this thread. It took me a couple of
posts to recognize the problem.


--
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: Stored procedure and SQL Job Agent Task
• Prev in forum: great tool to compare data from two different queries
• Thread view: Re: Problem: Performance difference between MSDE and SQL Express 2005

[Reply to this message]