I just noticed another member of my team, Harold Wong, posted the demo script we used for testing pessimistic and optimistic concurrency controls in SQL Server 2005.  See http://blogs.technet.com/haroldwong/archive/2005/09/11/410594.aspx.  Warning, the scripts are really long since it’s a multipart demo.