Cisco Cisco Process Orchestrator 3.0
4-57
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Viewing Activity Instance Information
Viewing SQL Server Lock Information Activity Results
When the SQL Server Lock Information activity is launched, results are displayed from the from the
Operations Workspace activity instance view.
Operations Workspace activity instance view.
To view SQL Server Lock Information output results
Step 1
On the Operations workspace, click the Activity Views folder.
Step 2
Use one of the following methods:
•
Highlight the SQL Server Lock Information activity instance, right-click and choose Properties.
-or-
•
Double-click the appropriate activity instance.
The SQL Server Lock Information dialog box displays.
Step 3
Click the Result tab to view the results of the query for the locks performed in the SQL server database.
Figure 4-41
SQL Server Lock Information Properties—Results Tab
The following information is displayed:
Column
Description
Resource Description
Textual description of a lock resource. Contains a portion
of the resource name
of the resource name
Process ID
Internal Microsoft SQL Server process ID of the session
requesting the lock
requesting the lock