We have 2 SQl Servers. Server A is SQL 7, and Server B is SQL 2000. We nee
d
to push data from server A to server B. My plan is to do this via executing
a stored procedure on the 2000 server. However, I am getting the following
error: "SQL Server does not exist, or access denied". I don't get this erro
r
when I am going from a 2000 server to a 7 server. Is it possible to push
data from a 7 server to a 2000 server using linked servers? Any help would
be greatly appreciated. Thanks!Take the Linked server out of the equation and test with ISQL.exe from SQL
7 to SQL 2000.
This will give you the proper error message to tshoot the problem.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment