Posted by Erland Sommarskog on 11/23/05 13:37

Mr Curious (courious@somewhere.eu) writes:
> One remark - if Auto close option is responsible - the server
> administrator should have similair problem?
> As far as I know he doesn't (I forgot to mention). That's why I suspect
> some security issue.

I think the problem is due to that EM accesses the databases to see if you
have permission to it. Since sa has permission to all databases anyway,
EM might bypass the check for him.

The command to turn it off is ALTER DATABASE db SET AUTO_CLOSE OFF.

--
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

[Back to original message]