Avatar of Roger Harrington
Roger HarringtonFlag for United States of America

asked on 

connecting two servers. via a stored procedure.

I have to two DB Servers. One is SQL 2003 and the other is SQL 2008. They both run on the same network but on seperate boexs. I need to access from a stored procedure tables from each server. I am not sure how to do that. Any thoughts?
Microsoft SQL Server

Avatar of undefined
Last Comment
Alpesh Patel
Avatar of Saqib Khan
Saqib Khan
Flag of United States of America image

sure you can... on the server where you want to access other server ADD IT AS LINKED SERVER.

its pretty easy to add a SQL Server as a "Linked Server" (Google it).
Avatar of grtGUY_007

You need to create Link Server between both sql box. Make sure to create link sever in source sql server.
Note: You will need SYSadmin previlage to create link server. (If you need help please respond)
Avatar of Anthony Perkins
>>One is SQL 2003 and the other is SQL 2008.<<
There is not SQL Server 2003, I suspect you mean 2000 or 2005.
Avatar of Alpesh Patel
Alpesh Patel
Flag of India image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo