共用方式為


LocalName Property

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The LocalName property identifies a Microsoft SQL Server login record used by a second server to determine permission level.

語法

object
.LocalName [=value]

Parts

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

  • value
    A string that identifies an existing SQL Server login

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLocalName(SQLDMO_LPBSTR pRetVal);
HRESULT SetLocalName(SQLDMO_LPCSTR NewValue);

[!附註]

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.

備註

An instance of SQL Server can implement SQL Server connection authorization for another instance of SQL Server. An authorized server can connect to execute a remote procedure call or for other purposes.

To establish authorization, a remote server is defined on the authorizing instance of SQL Server. A mapping (remote login) for a login established and maintained on the remote server can be built on the authorizing instance of SQL Server.

For example, a server, called AcctPay, used by an organization's accounts payable department, can execute remote stored procedures on the purchasing department's Purch server. On Purch, an AcctPayRemote login is created and given appropriate rights for all accounts payable department users. For each authorized login on AcctPay, a remote login is created and mapped to AcctPayRemote.

[!附註]

Remote server and login records enable SQL Server Authentication for connections initiated by an instance of SQL Server.

Applies To: