Create a table named Table1 with a column named Field1. Put insome useless data and open 2 sessions in Query Analyzer Now in the first session issue a Begin Transaction Update Table1 set field1 = 'Value1' And in the second session Begin Transacation Update Table2 set field1 = 'Value2' Update Table1 set field1 = 'Value2' Now back to the first and Update Table2 set field1 = 'Value1' At that time you should have a deadlock. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
