Post reply

Generate Stored Procedure/Functions Script with SP

  • September 26, 2007 at 7:14 pm

    #177611

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

    Kindest Regards,

    Deepthi Viswanathan Nair

  • June 8, 2008 at 3:59 am

    #825877

    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..

  • October 23, 2008 at 2:50 pm

    #888889

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

  • September 12, 2011 at 3:53 am

    #1379855

    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 3 (of 3 total)

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