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.
精彩评论