SQL Server查看系统存储过程及视图的定义

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