-- 목록 가져오기
SELECT sysobjects.id SPID, sysobjects.name SPName FROM sysobjects
WHERE sysobjects.xtype='P' AND sysobjects.name NOT LIKE 'dt%' ORDER BY SPName
-- 목록,내용 가져오기
SELECT so.name, sc.text
FROM dbo.sysobjects so
INNER JOIN dbo.syscomments sc ON so.id = sc.id WHERE so.type = 'p'
-- 내용보기
sp_helptext 'sp_add_data_file_recover_suspect_db'
Posted by 홍반장
