• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Linked Server, 7 to 2000

Server A is SQL 7 sp3, Server B is Sql 2000.  Can I log on to server A and add a linkedserver to select data from Server B?
0
BobSnyder
Asked:
BobSnyder
1 Solution
 
chigrikCommented:
Yes, you can. Use sp_addlinkedserver stored procedure.

With best regards,
Alexander Chigrik
http://www.MSSQLCity.com/ - all about MS SQL
(SQL Server Articles, FAQ, Scripts, Tips and Test Exams).
0
 
griffinj01Commented:
I did the same thing for a migration recently - have had no problems.
0
 
BobSnyderAuthor Commented:
I have used the following on Sql 7 (server A) ...
EXEC sp_addlinkedserver 'B', 'Sql Server'
EXEC sp_addlinkedsrvlogin 'B', false, 'sa', 'sa', 'password'
but cannot select from B's tables, nor does a display of table/view appear in A's tree.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now