DaveR (da**@bluehills.co.uk) writes:
Thanks Anith, I have tried that, but get the message "Failed to copy
objects from MS SQL to Server to MS SQL Server" and "MS ODBC SQL Server
Drive [SQL Server] The login 'login name for local server' does not
exist." The table structure is imported but without the primary key and
none of the data.
I don't know this screen at all, but it sounds to me that there are
options you fail to fill in correctly. The text "login name for local
server" sounds like something which is filled in as a guidance for you
to fill in.
I would execpt that there is also an option to use Windows authentication
for the other server, but again, I don't know this screen.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp