Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    27

    Question Unanswered: linked 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 Jensen

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: linked servers and transcations

    when you do transactions you log the info

    are your log files easily accessible ?

  3. #3
    Join Date
    Aug 2003
    Posts
    27

    Re: linked servers and transcations

    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

  4. #4
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: linked servers and transcations

    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 faster

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •