Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generate Stored Procedure/Functions Script with SP Expand / Collapse
Author
Message
Posted Wednesday, September 26, 2007 7:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 17, 2009 12:49 PM
Points: 8, Visits: 25
Comments posted to this topic are about the item Generate Stored Procedure/Functions Script with SP


Kindest Regards,

Deepthi Viswanathan Nair

Post #403279
Posted Sunday, June 8, 2008 3:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 29, 2009 2:54 AM
Points: 26, Visits: 84
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..
Post #513425
Posted Thursday, October 23, 2008 2:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 21, 2014 1:51 PM
Points: 13, Visits: 187
Unfortunately there is a 4000 character limit on the size of the script generated!


Post #590806
Posted Monday, September 12, 2011 3:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 13, 2012 9:46 PM
Points: 14, Visits: 240
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
Post #1173259
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse