查看存储过程定义
USE AdventureWorks2012;
GO
EXEC sp_helptext N'AdventureWorks2012.dbo.uspLogError';
USE AdventureWorks2012;
GO
SELECT OBJECT_DEFINITION (OBJECT_ID(N'AdventureWorks2012.dbo.uspLogError'));
USE AdventureWorks2012;
GO
SELECT definition
FROM sys.sql_modules
WHERE object_id = (OBJECT_ID(N'AdventureWorks2012.dbo.uspLogError'));