Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2013-02-25 : 04:45:05
|
| Hello all,using an ASP.NET application, when Visual Studio crashes, my database (SS 2008 R2) become inaccesible, due to a transaction that this application cannot rollback or commit. Inside Management Studio, how can I drop this orphan transaction?Thanks in advance. Luigi |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-02-25 : 04:55:57
|
Try this:run sp_who2 in a query window and then, using the given information in the result set, try to identify the needed SPID (for example 56)then you can do that:kill 56
Too old to Rock'n'Roll too young to die. |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-02-25 : 05:09:35
|
| I'll try in this way. Thank you Webfred. Luigi |
|
|
|
|
|
|
Drop "appended" transaction