all groups > sql server replication > november 2004 >
You're in the

sql server replication

group:

Transfering Stored Procedures


Transfering Stored Procedures sympatico
11/6/2004 1:04:04 PM
sql server replication:
Hi,

Anyone know how I can transfer my stored procedures from one sql server to
another over the internet? I tried using the DTS, but kept getting an
"Objects cannot be transferred" error.

Thanks

Re: Transfering Stored Procedures Hilary Cotter
11/6/2004 2:00:28 PM
create a new publication just for these procs. Deploy the snapshot using
ftp.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Re: Transfering Stored Procedures sympatico
11/6/2004 3:01:34 PM
I don't believe I have the permissions for this since the "create
publications" menu item is grayed". My database resides with an external web
host.


[quoted text, click to view]

Re: Transfering Stored Procedures sympatico
11/6/2004 4:39:18 PM
I am receiving this specific error:

"[Microsoft] ODBC SQL Server Driver][SQL Server]Specified owner name
"mediatec" either does not exist or you do not have permission to use it."

It worked fine when i chose to only transfer the tables and views. However,
when I chose to copy all objects and data I kept getting the above error?

Any ideas?

Thanks

[quoted text, click to view]

RE: Transfering Stored Procedures Lina Manjarres
11/6/2004 9:05:03 PM
I would make a script of all the SP. And then I will execute it using the
Query Analyzer on the remote server.

[quoted text, click to view]
Re: Transfering Stored Procedures Hilary Cotter
11/7/2004 10:06:02 AM
when you script out the sp's make sure you script out the login and the
permissions. Apply this as well.

--
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

AddThis Social Bookmark Button