sys.sp_droplinkedsrvlogin

general

#stored-procedure

Description

Removes an existing mapping between a login on the local server running SQL Server, and a login on the linked server.

sp_droplinkedsrvlogin
[ @rmtsrvname = ]
N
'rmtsrvname'
, [ @locallogin = ]
N
'locallogin'
[ ; ]

Removes an existing mapping between a login on the local server running SQL Server, and a

The name of a linked server that the SQL Server login mapping applies to.

@rmtsrvname

, with no default.

The SQL Server login on the local server that’s a mapping to the linked server

@rmtsrvname

@locallogin

, with no default. A mapping for

@locallogin

@rmtsrvname

already exist. If

, the default mapping created by

, which maps all

logins on the local server to logins on the linked server, is deleted.

(success) or

Security stored procedures (Transact-SQL)

sp_addlinkedserver (Transact-SQL)

sp_droplinkedsrvlogin (Transact-SQL)

System stored procedures (Transact-SQL)