Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Linked Server, 7 to 2000

Posted on 2002-05-09
3
Medium Priority
?
272 Views
Last Modified: 2006-11-17
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
Comment
Question by:BobSnyder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 8

Accepted Solution

by:
chigrik earned 300 total points
ID: 7000476
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
 

Expert Comment

by:griffinj01
ID: 7001150
I did the same thing for a migration recently - have had no problems.
0
 
LVL 2

Author Comment

by:BobSnyder
ID: 7001374
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

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question