Home Forums Article Discussions Article Discussions by Author Discuss content posted by Deepthi Viswanathan Nair Generate Stored Procedure/Functions Script with SP RE: Generate Stored Procedure/Functions Script with SP
arj
SSC-Addicted
Points: 444
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