How to: Modify a SQL Server Agent Proxy (Transact-SQL)

This topic describes the steps required to modify a Microsoft SQL Server Agent proxy.

To modify a SQL Server Agent proxy

1. Execute sp_update_proxy using the name of the proxy to update and the new options for the proxy.

See Also

Concepts

Creating SQL Server Agent Proxies

Other Resources

sp_update_proxy (Transact-SQL)
sp_help_proxy (Transact-SQL)
sp_revoke_login_from_proxy (Transact-SQL)
sp_revoke_proxy_from_subsystem (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance