Posted by Erland Sommarskog on 06/05/05 00:11

(ralphm1@mail.horacemann.com) writes:
> 2.) The problem is with EM only with a NON-sa login. The sa login
> performance is fine. Any NON-sa login performs poorly or stops
> responding. Is the sa login NOT affected by IsAutoClose or somehow
> treated differently than a NON sa?

Yes. For sa Enterprise Manager does not have to check whether you have
permissions to access a certain database - sa always have permission.
But for a non-sa user, EM submits a query foreach database when you
expand the database node. If databases are in autoclose, then this will
take a long time.


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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: UPDATE/INSERT to make One-to-Many table become One-to-One
• Prev in forum: Re: query in dataview.rowfilter
• Thread view: Re: SQL Server Performance and permissions

[Reply to this message]