Describe temporary table:
tempdb..sp_help #monitor
Describe permenant table
sp_help db_jobs
Some of the stored procs are quite long and all of the code is not contained in the syscomments text column. The sp_helptext proc returns all the lines for a stored proc no matter how long it might be.
EXEC sp_helptext 'dbo.proc1';
No comments:
Post a Comment