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!
