Chapter 12, Retrieving Information with System Procedures

In the current document, the sp_who system procedure was identified as not being supported by DirectConnect. This information is incorrect; the system procedure sp_who is supported for ECDA Option for Microsoft SQL Server and ECDA Option for Oracle only.

The following is a description of the sp_who system procedure.

Description

Reports information on current users and processes on SQL Server.

Syntax

sp_who [ login_name | “spid” ]

Usage

Reports the server process ID, its status, the login name, the name of the host computer, the name of the database, and the command being run.

If no name is provided, sp_who reports on processes being run by all users.

Parameters