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