Top menu

Various issues with DeviceLock SQL database

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

lockinfo.sql (1.25 kb)

sqlsms.JPG (201.27 kb)

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.