SQL Server Administration - User/Login Admin

Drop Linked Server Login

Drops a linked server login.

Syntax - SQL Server 2005/2008

sp_droplinkedsrvlogin [ @rmtsrvname= ] 'rmtsrvname' , 
   [ @locallogin= ] 'locallogin'
GO 

--returns 0=ok 1=failed

Examples - SQL Server 2005/2008

Drop the login mapping for an existing user

EXEC sp_droplinkedsrvlogin 'AcctsSEA', 'ericm'
GO

Drop the default login mapping

EXEC sp_droplinkedsrvlogin 'AcctsSEA', NULL
GO
 Collapse All    Expand All
Custom Search

SQL Server Information and Resources