Generate Stored Procedure/Functions Script with SP

• Deepthi Viswanathan Nair

  Old Hand

  Points: 392

  More actions

  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

• sanuj

  SSC-Addicted

  Points: 438

  More actions

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

• NiceDalek

  SSC Enthusiast

  Points: 181

  More actions

  October 23, 2008 at 2:50 pm

  #888889

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

• arj

  SSC-Addicted

  Points: 494

  More actions

  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