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?
Last Comment
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)
Note: You will need SYSadmin previlage to create link server. (If you need help please respond)
>>One is SQL 2003 and the other is SQL 2008.<<
There is not SQL Server 2003, I suspect you mean 2000 or 2005.
There is not SQL Server 2003, I suspect you mean 2000 or 2005.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
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.
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.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
its pretty easy to add a SQL Server as a "Linked Server" (Google it).