Post reply

Two instaces of SQL on Cluster not writting on each other after SP4

  • March 7, 2008 at 4:51 pm

    #71189

    After installing SP4 on our W Server 2003 SP2 we are having this issue:

    When starting a transaction and try to write on another table on linked server #2 it never finishes, there is no block reported, no error messages on Event viewer.

    Any ideas where to look at?

    J

  • March 8, 2008 at 4:57 pm

    #787073

    Did you try to run DBCC OPENTRAN? It can tell you whether or not your transaction is still running?

  • March 8, 2008 at 5:09 pm

    #787076

    We did not know about opentran, what info do you need from this to help us out?

  • March 18, 2008 at 8:58 pm

    #791258

    DBCC OPENTRAN can tell you what tasks are in process.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply