Scan Server to find Stored Procdures running as domain adm..

briant97 (briant97@discussions.microsoft.com) writes:
> Is there anyway to scan a sql server to find out which stored procedures
> are running as an administrator.

Maybe you could clarify what you mean "running as administrator"? The only
way a stored procedure could be running as administrator is that you have
signed the procedure with a certificate that is associated with a login
that has been granted CONTROL SERVER. Hm, maybe procedures in the master
database with EXECUTE AS OWNER as well. In any case, I suspect that you
have something else in mind, whence my request for clarification.


--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@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