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

    Old Hand

    Points: 328

    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


    Points: 414

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


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

    It's not giving any result set.


    Karnatakapu. Mallikarjuna

    Kindest Regards,


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

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