I have a problem that I hope you can help me to solve. I'm using SQL Server 2008 R2.
I need to create a test environment in which I'll be able to artificially 'create' lost transactions. Due to network disconnects in the app I'm using, sometimes (very, very rarely) there are 'broken' transactions (some part of the data update goes to DB, but the rest is not which results in incomplete data in database). On my test machine I don't have a clue how to do it.
I know that's the problem with app design but I need to prove that this kind of behaviour is appearing so that the vendor of the app can fix this bug.
I really hope that you can help me out. I'm not a dba - I learn what I can to become one so if this question is 'elementary' please be understanding :)