Advantage Database Server

sp_mgGetTableUsers

Advantage SQL Engine

sp_mgGetTableUsers

Advantage SQL Engine

Previous topic Next topic  

sp_mgGetTableUsers

Advantage SQL Engine

Previous topic Next topic  

Returns a result set containing all users who have the specified table open.

Syntax

EXECUTE PROCEDURE sp_mgGetTableUsers( TableName,Character,255 )

Parameters

TableName (I)

Full qualified path to the table.

UserName (O)

Name of the connected user.

ConnNumber (O)

NetWare connection number.

DictionaryUser (O)

Name of user that has authenticated to an Advantage Data Dictionary.

Address (O)

IP or IPX address of the connected user.

OSUserLoginName (O)

Operating system login name of the connected user.

TSAddress (O)

Terminal Server client IP address if the connection is made from a Terminal Server session.

Remarks

The table name is the fully qualified path to the table on the server.

Note With the Advantage Local Server, sp_mgGetTableUsers will only return users who have opened the table in the instance of Advantage Local Server currently loaded into memory. It is not possible to determine other users who have opened the table from other instances of the Advantage Local Server.

 

Example

EXECUTE PROCEDURE sp_mgGetTableUsers( '\\server\share\data\table.adt' );

See Also

sp_mgGetAllTables

sp_mgGetUserTables