Figured it out. The SQL Service account was a domain account and did not have
administrator privilege on the server it ran on. Strangely enough the procedure needs
some kind of special local permissions.
Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Friday, July 12, 2002 9:57 AM
To: php.db
Subject: [PHP-DB] MS Sql Server xp_sqlagent_proxy_account
exec master.dbo.xp_sqlagent_proxy_account N'GET'
Anyone ever had the above give you Access is denied. When you run it as 'sa' ???
Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php