Describe two SQL Server procedures that can be used to identify locking.
What will be an ideal response?
The sp_who2 procedure lists all sessions connected to the SQL Server instance and identifies the process(es) causing any blocking locks in real time. The sp_lock procedure can be used to display all locks that are currently taken out on the SQL Server instance.
You might also like to view...
A ListBox’s ________ property indicates the source of the data that populates the ListBox’s Items collection.
a) DataSource b) DataOrigin c) DataCreator d) DataIssuer
What key sequence does ^C indicate to the user?
a. Ctrl+C or Command+C b. c c. C d. Caps Lock + C
Besides crime, what are some other beneficial aspects of surveillance in a modern society?
What will be an ideal response?
Digital communications require a communications system and standards.
Answer the following statement true (T) or false (F)