General discussion
November 25, 2002 at 09:57 AM
ophedian

Copy Stored Procedures – SQL Server 2000

by ophedian . Updated 23 years, 10 months ago

I would like to copy only selected stored procedures from one server to another server. The logic would be simple.

USE ServerA
Copy 1,2,3,4
FROM databaseA

USE ServerB
Paste 1,2,3,4
into databaseB.

I was hosting my website with one company that added their own storedProcedures into my database that have System scope and Administrator permisions. So I cannot copy those over to my new hosting company because I do not have permision to create Administrative objects. But when I use Export Wizard and choose copy all objects, it tries to copy even the Administrative objects from my old account onto my new account which causes the scrip to fail since I do not have admin privilages. Any solutions would be helpful.

This discussion is locked

All Comments