Two useful system stored procedures showing linked servers in SQL 2005/2008
exec sp_helpserver
exec sp_linkedservers
I had trouble removing a linked server because I forgot to remove all of the logins.
(seems like removing a linked server should cascade remove the associated logins)
exec sp_droplinkedsrvlogin 'FUSIONRIS','sa' exec sp_droplinkedsrvlogin 'FUSIONRIS',NULL exec sp_dropserver 'FUSIONRIS'
No comments:
Post a Comment