Generate Stored Procedure/Functions Script with SP

  • Deepthi Viswanathan Nair

    Old Hand

    Points: 392

    Comments posted to this topic are about the item Generate Stored Procedure/Functions Script with SP


    Kindest Regards,

    Deepthi Viswanathan Nair

  • sanuj

    SSC Veteran

    Points: 298

    Your procedure is okay. But when we generate script of more than 10 or 15 lengthy procedures, it is getting cut somewhere .. in the middle and bottom..

  • NiceDalek

    SSC Enthusiast

    Points: 181

    Unfortunately there is a 4000 character limit on the size of the script generated!

  • arj

    Old Hand

    Points: 384

    script is ok. But it's not able to generate script for schema specific SP's.

    Example:

    Exec sp_Generate_Script 'Schema1.StoredProcedure,'Schema2.StoredProcedure,dbo.usp_xx';

    It's not giving any result set.

    Regards,

    Karnatakapu. Mallikarjuna


    Kindest Regards,

    arj

Viewing 4 posts - 1 through 4 (of 4 total)

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