Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
FIX: A Non-Sysadmin May Execute sp_procoption Stored Procedure
Article ID: 277809 - View products that this article applies to.
This article was previously published under Q277809
BUG #: 57213 (SQLBUG_70)
Microsoft SQL Server Books Online states the following concerning the execution of the sp_procoption stored procedure:
Execute permissions default to members of the sysadmin and setupadmin fixed server roles. Startup procedures must be owned by the database owner in the master database.This is not the intended behavior. Only logins that are a member of the System Administrators fixed server role should have execute permission on sp_procoption.
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(http://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
To reproduce the problem use these steps: