Even though the other statements aren't in a transaction they're still part of a transaction. If you don't explicitly start a transaction SQL Server will automatically wrap each data...

OK, so I set the trace flags on and recreateed the deadlock. The actual deadlock error is:

"Transaction (Process ID 63) was deadlocked on lock resources with another process and has...

OK, I'll give that a try...so enable the trace flags, reproduce the deadlock error, then read the error log right?

The only thing that makes me think it isn't any of...

I'm thinking the READPAST locking hint might help!

Karl, thanks...

I am setting the level as serializable at the beginning of the SP:

"SET TRANSACTION ISOLATION LEVEL SERIALIZABLE"

I don't know much about locking hints...will this prevent the other SP users...

My only comment is that the article would be very helpful...if I fully understood what he did. I understand the basics of what he did, but many of the details...

Kathi,

Great article.

One thing I wanted to add, which threw me for a loop a while back, is that if you use a return value when filling a datareader object...

SSC-Addicted,

Thanks for the good idea. There are LOTS of issues with this database. I could gripe all day about inconsistencies and poor design, but I just keep on smiling every...

Great article! I'm glad I read it, but now i'm having trouble writing one of my queries...

I need to join 2 tables on smalldatetime columns. One of the tables stores...

Ahhh...ok. I think I get it now. The view and the digits table are just there to throw an error in the event that the wrong criteria are caught (i.e.,...

These articles are very good...but the author lost me on article 4.

Could you go into more detail on how the indexed view and using the negative matches enforces integrity...

Great topic...I'm especially interested in how to build a development plan.

I work for a large public university and am disappointed, especially since it's an academic institution, at how little support...

Great article! I've been looking for a concise, authoritative account of this exact topic. I am looking forward to your next installment. Keep up the good work!