Copying Numerous Stored Proc by Script - TechRepublic
General discussion
December 7, 2004 at 08:18 AM
smittyrt

Copying Numerous Stored Proc by Script

by smittyrt . Updated 21 years, 5 months ago

I’m a novice SQL admin and I’m wanting to backup some databases to a flat file. To do this I need to copy quite a few stored procedures from the msdb database to each db I want to backup. How can I do this quickly? Right now I’m just copying and pasting in each database which is ineffecient. Scripting this would save me tons of time. Any help is very appreciated!

This discussion is locked

All Comments