GetUserName Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The GetUserName method returns the database user used by the referenced login, when a connection using that login accesses the specified database.
Syntax
object.GetUserName(Database)
Parts
object
Expression that evaluates to an object in the Applies To list.Database
String that identifies an existing Microsoft SQL Server database by name.
Prototype (C/C++)
HRESULT GetUserName(SQLDMO_LPCSTR DatabaseName,
SQLDMO_LPBSTR pRetVal);
Note
SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.
Returns
A string that identifies a database user.
Remarks
The GetUserName method returns an empty string when the login specified does not have access to the database.