Databases Reference
In-Depth Information
4. Click on the Ok button in the Properties window.
5. Again, right-click the instance of SQL Server Service that you just configured and
select Restart from the context menu, as shown in following screenshot. This will
restart the SQL Server Service.
Always use SQL Server Configuration Manager to restart
SQL Server Service. Do not restart SQL Server service
directly from the Windows Services MMC.
6.
Now, perform the same steps to produce the deadlock condition as in the
preceding recipe. Execute the queries from step 9 through step 14, provided
in the previous recipe.
7.
Performing the previous step generates a deadlock and you will receive the same
error (1205) as in the previous recipe.
8.
Now, based on the name of SQL Server instance and your SQL Server installation
directory, navigate to the directory that contains the
ERRORLOG
file located in the
Log
directory. The following is the default installation path for a default instance of SQL
Server 2012 by which the
ERRORLOG
file can be located:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLServer\
MSSQL\Log
Search WWH ::
Custom Search