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 |
|
dtong004
Constraint Violating Yak Guru
281 Posts |
 Posted - 2001-06-25 : 14:04:19
|
| I have met one very strange roll back session. Case:I am building a table with about 2.5 million records from two table join. I wrote this in a stored procedure, P1.I wrote another procedure P2 which will call P1 and do something else. I run P2, and P2 reported to me the P2 was succesfully run--printed message. Two minutes later, I see the server begin to rollback my whole session of P2, which includes P1. Does anyone know what is happen? why it rollback after the process successfully run?Thanks for helpDaniel |
|
|
|
|
|
Unusual roll back