Post reply

How to compress a stored procedure?

  • May 8, 2007 at 12:12 pm

    #117092

    If we open syscomments, we can see a column, compressed. It indicates whether or not a stored procedure is compressed. My question is how to compress a stored procedure?

  • May 8, 2007 at 12:31 pm

    #705040

    Short answer: you don't. That, is totally internal and is being handled by undocumented functions.


    * Noel

  • May 8, 2007 at 12:34 pm

    #705041

    I am glad someone knew.  I have been racking my brain, google and BOL for some sort of answer.  The only thing I found was a description of the fields in syscomments that wasn't much help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply