sp_mgGetIndexUsers

Advantage SQL Engine

Returns a result set containing all users that have the specified index file opened.

Syntax

EXECUTE PROCEDURE sp_mgGetIndexUsers( IndexName,Character,255 )

Parameters

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 UserName can be either the Computer Name or the NetWare connection name of the connected user. The ConnNumber is the NetWare connection number of the connected user; this only applies to ADS for NetWare.

Note With Advantage Local Server, sp_mgGetIndexUsers will only return users who have the index opened by the instance of Advantage Local Server currently loaded into memory.

 

Example

EXECUTE PROCEDURE sp_mgGetIndexUsers( '\\server\share\data\index.adi' );

See Also

sp_mgGetAllIndexes

sp_mgGetUserIndexes