Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,029 of 19,505    |
|    Toni Alfirevic to All    |
|    code withing transacion wont run...    |
|    16 Dec 10 15:55:20    |
      From: toni.alfirevic@gmail.com              Hi,              has anyone ever encountered a problem with MSSQL that would manifest like       this.              If you run specific code outside of transaction. it runs just fine. But if       you put that code within a transaction - transaction fails and does a       rollback.              Issue has occured on different SQL versions (2000, 2008 x86 and 64bit too)       on different OSes (2003, 2008R2).              What I have concluded so far is... That ammount of data that is being       handled with specific code is not big, on contrary it's rather small, tens       of kilobytes and that isolation levels have absolutely no affect to the       outcome. It just fails every time.              Also, code is being run on one server, no network activity is being       triggered by that specific part of code.              Anyone, any clues? Suggestions? Ideas? Anything?              Thank you,       T.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca