PFAW: Senator Bennet Caved to the Far Right by Returning his Blue Slip on Allison Eid FOR IMMEDIATE RELEASE: September 6, 2017 Contact: Courtney Neale at People For the American Way
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
If you do use the-T1205 startup parameter, the following is a sample of the output that will be in the SQL Server error log: Sometimes, you might not be able to stop and re-start SQL Server. In that case, you can use Query Analyzer to run the following command to enable the deadlock trace flags. Wait-for graph entry indicates that a deadlock was encountered. The following is a sample of the output that you might see in the SQL Server error log when you use the-T1205 startup parameter. In the Wait-for-graph entry, you have Node 1 and Node 2. In each node, you have a grant section and a request section.