开发者

Connect to another Sql Server 2008 instance in a stored procedure

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜