Hi all,
I have a stored procedure which is standard across 70+ databases on a server. Whenever I need to alter this procedure, I have been running the 'Alter Procedure [dbo].etc' in each database.
Is there any way I can automate this to run a mass update via a cursor or some other method?
FYI - The SP is large (3000+ lines)
Thanks
I have a stored procedure which is standard across 70+ databases on a server. Whenever I need to alter this procedure, I have been running the 'Alter Procedure [dbo].etc' in each database.
Is there any way I can automate this to run a mass update via a cursor or some other method?
FYI - The SP is large (3000+ lines)
Thanks