SP_ stored procedure script

sp_helptext 'sp_helpdb'

USE master
EXEC sp_helptext 'sp_MSdbuserpriv'



--It will give the sp_helpdb SP inside script.


sp_tables_rowset