Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by BorisBaliner SQL 2000 to SQL 2005: Where have all the old features gone? RE: SQL 2000 to SQL 2005: Where have all the old features gone?
noeld
SSC Guru
Points: 96590
More actions
March 16, 2006 at 7:22 am
#627004
How the hell do you show the contents of a system stored procedure? I know sp_helptext but there MUST be a better way than that!
SELECT OBJECT_DEFINITION (OBJECT_ID ('sys.sp_help') )
I suffered this one too
Cheers,
* Noel