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 |
|
BFHelpdesk
Starting Member
1 Post |
 Posted - 2009-12-18 : 09:51:03
|
| Hi,here is my problem:I got a store procedure that use Linked Server from a local SQL2000 server to a SQL2005 server.The store pocedure is getting data from the SQL2005 Linked server to update local SQL2000 tables.This store proc run in an average of 40seconds.If I put it transactional (with a BEGIN / COMMIT-ROLLBACK TRAN), it takes an average of 1h30min to run....The same store procedure run from a SQL2005 server to a SQL2005 server with a running average of 40seconds (transactional or not)The DISTRIBUTED TRAN cause the same problems...Any idea? |
|
|
|
|
|
Linked Server Transactional problem