• use YourDatabaseName;

    GO

    sp_helptext 'YourSchemaName.YourProcedureName';