Is there anyway to scan a sql server to find out which stored procedures are running as an administrator.
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@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
