对stored procedure:
SELECT OBJECT_DEFINITION(OBJECT_ID('sp_replmonitorsubscriptionpendingcmds'));
或
EXEC sp_helptext 'sp_replmonitorsubscriptionpendingcmds';
对View:
SELECT OBJECT_DEFINITION(OBJECT_ID('MSdistribution_status'));
或
EXEC sp_helptext 'MSdistribution_status';