If you ran the BackOffice Resource Kit CD-ROM Setup, you can access Deadlock.sql from the Bork\Sql\Examples directory on your computer. Otherwise, install it from the BackOffice Resource Kit CD-ROM.
To install Deadlock.sql
Get the Deadlock.sql script from the Sql\Examples directory on the BackOffice Resource Kit CD-ROM.
The tables and procedures used for the demonstration are installed with the script Deadlock.sql. Edit the file and change the statement to use a user database on the server:
use devcondemo1
At the command prompt, use the isql utility to run the Deadlock.sql script. For example:
C:> ISQL /Usa /Ppassword /Sserver_name /ilocation\deadlock.sql
where:
/Ppassword
Is the password for the SA login.
/Sserver_name
Is the name of the server on which SQL Server resides.
/ilocation
Is the full path to the Deadlock.sql script.