The steps should have been
USE master
sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
CREATE PROCEDURE sp_revoke AS ...
sp_configure 'allow updates', 0
RECONFIGURE WITH OVERRIDE
You should also be logged into the server as a member of the sysadmin fixed server role.
If that doesn't work, you can write a procedure that uses dynamic sql (the EXECUTE) to execute some revoke statements.
-Mike
>Here is the error i get
>
>Server: Msg 270, Level 16, State 1, Procedure SP_REVOKE, Line 45
>Table 'sysprotects' cannot be modified.
>
>thanks