servers and transcations

Hello

I'm trying to run an update on data in one SQL Server, based on data from another SQL Server (they're linked). It seemed to take forever, even with just one row in the table, so I tried making a dummy query that just printed some stuff on the screen. This also took forever, so I tried doing the same thing, but not as a transaction. Then it worked perfectly!

What is the problem with linked servers and transactions? Does anybody have an explanation as to why they can't be combined? Or even better, does anybody have a solution for combining them?

Thanks

Martin N Jensenwhen you do transactions you log the info

are your log files easily accessible ?|||Originally posted by Karolyn
when you do transactions you log the info
are your log files easily accessible ?

The transaction log files are stored with the datafiles as per the default installation settings. Do I need to assign special rights to some account in order to run the transaction?

Then again, wouldn't it only be the transaction log files on the machine on which I'm running the transaction from that are accessed?

MNJ|||check the Modification date of the log files on the different machines

and try to set the logging to off before the updating
to see if the command runs fastersql