• First of all I think you will get better response if you post a 2005 question in the appropriate forum.

    Now to your question. There are a couple od roles which by default can view properties of a stored procedure. Sysadmin will work, but is total overkill. db_owner or ddl_admin would be a much better choice.

    GRANT VIEW DEFINITION will also work.

    But keep in mind that it's not possible to grant any this permission on one specific procedure. The grantee will be able to see definition and properties of all database objects.

    [font="Verdana"]Markus Bohse[/font]