开发者

Connect to another Sql Server 2008 instance in a stored procedure

开发者 https://www.devze.com 2023-04-06 09:39 出处:网络
Lets assume we have 2 instances of SQL Server. In the first instance I have a stored procedure that needs to connect to the second in开发者_高级运维stance and run a query. Is it possible? How can I do

Lets assume we have 2 instances of SQL Server. In the first instance I have a stored procedure that needs to connect to the second in开发者_高级运维stance and run a query. Is it possible? How can I do that?


Create a linked server and address it from within your stored procedure.

0

精彩评论

暂无评论...
验证码 换一张
取 消