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.