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

    Question Unanswered: uncomitted transactions on server outside of domain

    Hi

    I have a couple of sql servers registered in EM which are outside of the domain. Whenever I run queries on them with the query analyzer, they seem not to commit the transaction. When I'm about to close down the window, I'm always told that there are uncomitted transactions.

    Is this some kind of a bug, and is there something I can do about it?

    Thanks
    Martin N Jensen

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What is the query used?
    Are you using linked server queries?
    If so ensure MSDTC is started on that SQL server.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Aug 2003
    Posts
    27
    Well, it's any kind of query really, even simple selects. And there is no linked server involved.

    MNJ

Posting Permissions

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