Generate Stored Procedure/Functions Script with SP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Deepthi Viswanathan... » Generate Stored Procedure/Functions Script...

Generate Stored Procedure/Functions Script with SP

Rate Topic

Display Mode

Topic Options

Author

Message

Deepthi Viswanathan Nair

Posted Wednesday, September 26, 2007 7:14 PM

Forum 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

sanuj

Posted Sunday, June 08, 2008 3:59 AM

SSC 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

NiceDalek

Posted Thursday, October 23, 2008 2:50 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 26, 2013 2:34 PM
Points: 13, Visits: 150

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

Post #590806

arj

Posted Monday, September 12, 2011 3:53 AM

Grasshopper

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 »

Permissions