• 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