title: How to deliberately cause a deadlock?
body: <p>So I'm trying to track down what looks like a deadlock problem <a href="https://stackoverflow.com/questions/7811177/how-to-troubleshoot-sql-the-timeout-period-elapsed-prior-to-completion-of-the-o">here</a>.  I've enabled deadlock logging using DBCC TRACEON(1222,-1) and DBCC TRACEON(1204 ,-1).  I'd like to test to make sure the logging catches the deadlock, so how can I cause one to occur in MS SQL 2005?  Thanks,</p>