Deepthi Viswanathan Nair
September 26, 2007 at 7:14 pm
Comments posted to this topic are about the item Generate Stored Procedure/Functions Script with SP
June 8, 2008 at 3:59 am
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
Unfortunately there is a 4000 character limit on the size of the script generated!
September 12, 2011 at 3:53 am
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.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply