Advantage SQL Engine

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


EXECUTE PROCEDURE sp_mgGetTableUsers( TableName,Character,255 )


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.


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.



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

See Also