Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smurug
Starting Member
2 Posts |
 Posted - 2006-01-10 : 05:39:48
|
I have a stored procedure in which i have heteregonous queries running, using linked servers, my problem is i want to perform the same operation on each server one by one, everything is fine, but suppose im not able to connect to a particular server there is an error and execution stops, but the operation on other servers until then are performed, i dont want this to happen, if there is an error in any of the servers, i want the operations on other servers to be rolled back, is it possible, or is there any other solution, Please help me, Thanks in advance... (Note:Im performing the insert operation on each servers)Winners never quit,Quitters never win.Warm Regards,S.Murgan |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-01-10 : 06:58:22
|
| You could do it all in a transaction but I think a design review would be a better option as it sounds like this will cause problems.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
Distributed Queries