Description
Experiencing various issues with DeviceLock SQL database? We will need some outputs to research. This article contains instructions on gathering the necessary information.
How-to
Run the attached script (lockinfo.sql).
Instead of "DeviceLockDB" you should enter the name of your current DeviceLock database.
Send the output to us.
Then,Install SQL Server Management Studio, create a new Query and execute:
DBCC TRACEON (1222,-1)
Wait until you find a new Error about Deadlock in the Server log and execute:
DBCC TRACEOFF (1222,-1)
In the SQL Server Management Studio go to Management-> SQL Server Logs-> double click on Current -> choose Export=> export the log and send it to us.
*See attached screenshot "sqlsms.jpg" for the how-to.