Hi,

I am trying to use the DTS export wizard in SQL 2000 to transfer stored
procedures between from one database to another. I keep getting this error:

"Failed to transfer objects from Microsoft SQL Server to Microsoft SQL Server"

I also received the following additional info when doubleclicking the error message:

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

Any ideas?

What you will probably find is that mediatec is a user local to the source
computer that has a login there. On the remote server of course this login
does not exist and when the owner of this proc is trying to be assigned SQL
Server has no idea who it is.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"peter" <zoneal (AT) yahoo (DOT) com> wrote