Software

Ask something
Discussion Locked

Copy Stored Procedures - SQL Server 2000

0 helpful
1 reply

by ophedian

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by glen_mcleod

Use DTS (export data), select 'copy objects and data', de-select 'copy all objects', click the 'select objects' button, de-select all except 'stored procedures', then select only the procs you want to copy.

Glen

This discussion is closed to new replies.