SQL:Copy Sored Proc to a new db? - TechRepublic
General discussion
April 28, 2001 at 04:15 AM
jhassani

SQL:Copy Sored Proc to a new db?

by jhassani . Updated 24 years, 10 months ago

Re: MS SQL Svr 7
Is there a quick & easy way to copy SQL stored procs from one database to another database and then compile it in the new database using T\SQL code? Other than getting the text from sp_helptext and executing it in the new database,I am at a loss.

This discussion is locked

All Comments