Results 1 to 4 of 4

Thread: Strange issue with MStudio

  1. #1
    Join Date
    Aug 2004
    Posts
    188

    Strange issue with MStudio

    Hi... I have a strange problem happening. I log in as domain\user(admin) then log into MS using the SA account. I proceed to run a select statement and when i go to close out of the query window it tells me that there are uncommitted transactions still open do you want to commit them?? It was a select statement?

    Then I log in as local\user(admin) then log into MS using the SA account. I proceed to run a select statement and when i go to close out of the query window it closes with no uncommitted transactions warning?

    Any idea why this happens and how to not make it happen? I don’t want that popping up on a select statement...

    Thanks!

  2. #2
    Join Date
    Aug 2004
    Posts
    188
    I figured it out. somehow the "Set Implicit_transactions was checked off in the options (Ansi) tab. I unchecked this and now I dont get the pop up...

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Thanks for the Update ...

    Your posting back your findings makes your question / answer searchable by others, who will no doubt encounter the same issue.

    Many thanks for taking the time to "complete the circle!"

    Bill

  4. #4
    Join Date
    Aug 2004
    Posts
    188
    Quote Originally Posted by Island1 View Post
    Your posting back your findings makes your question / answer searchable by others, who will no doubt encounter the same issue.

    Many thanks for taking the time to "complete the circle!"

    Bill

    No problem Bill. Thanks for the post!

Posting Permissions

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