469,575 Members | 1,275 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,575 developers. It's quick & easy.

Multiple MSSQL Linked Servers

I hope there is someone out there who can help me. I have a MSSQL 2005 server with multiple linked server used for data extraction from other DB's. My problem is I want to be able to start the data collection on exactly the same time from the various servers, using the same dynamic SQL stored procedure. In other word I want various threads of the same stored procedure to run Asynchronously. My problem is that when this happens Synchronously and one of the linked servers is down - I do not want to delay the gathering of data from other linked servers.

Any suggestions
Dec 13 '07 #1
0 961

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Gary | last post: by
1 post views Thread by RichardF | last post: by
4 posts views Thread by kenneth.osenbroch | last post: by
2 posts views Thread by grandmasterneil | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.