February 13, 2012 at 7:09 am
When I attempt to delete a Linked Server via SSMS I get a message that Remote Logins will be removed.
SQL Server will drop the Login on the remote Server?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 13, 2012 at 7:16 am
Nope, only the remote server login mapping. It’s useless once you drop the Linked Server. You need to create it again when you re-create (if at all) the Linked Server.
February 13, 2012 at 7:55 am
Please confirm that if I delete the Linked Server it will not Drop the Remote Login.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 13, 2012 at 7:58 am
Can’t you setup a quick test on local servers? Create a dummy login & try it.
February 14, 2012 at 7:21 am
The exact message states:
Deleting a remote server deletes all remote logins defined for that server. Are you sure you want to delete this linked server and all remote logins for this server?
The message is in reference to the local to remote login mappings as defined on the security tab.
Those mappings are deleted. If the linked server is deleted the mappings are useless.
The logins themselves are not deleted (dropped).
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
February 14, 2012 at 9:04 am
Thanks, I was not concerned about the mappings, just the login.
I've dropped Linked Servers before and it did not drop any Logins.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply