Login Property

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 Login property exposes the name of a Microsoft SQL Server login record.

Syntax

object
.Login [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list

• value
  A valid SQL Server login record name string

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLogin(SQLDMO_LPBSTR pRetVal);
HRESULT SetLogin(SQLDMO_LPCSTR NewValue);

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.

Remarks

For the RegisteredServer object, the Login property identifies the login used by default when a connection is made to an instance of SQL Server by a Microsoft client utility.

For the User object, the property associates the referenced database user with a specific SQL Server login record.

For the SQLServer object, the Login property provides a user name for connecting if SQL Server Authentication is used to connect the object to an instance of SQL Server.

Note

The recommended method for connecting to an instance of SQL Server is Windows Authentication.

Applies To:

RegisteredServer Object	User Object
SQLServer Object