Permissions do not appear in the sysprotects table or in the output of the sp_helprotect stored procedure when you grant the permissions to an object in SQL Server 2000

Under certain circumstances, when you grant permissions to an object in Microsoft SQL Server 2000, the permissions that you granted do not appear in the sysprotects virtual table for that database or in the output that you obtain by running the sp_helprotect stored procedure.

Read More - Register for Free Membership