DropLogins 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 DropLogins property controls cascaded deletion of dependent linked server login records when a persisted OLE DB data source definition is deleted.
Syntax
object
.DropLogins [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDropLogins(LPBOOL pRetVal);
HRESULT SetDropLogins(BOOL NewValue);
Remarks
If TRUE, login mappings defined for the linked server are deleted when the linked server record itself is deleted.
If FALSE, deleting the linked server does not affect login mappings for the server.