I'd like to produce a listing of linked servers and their mapped logins. Anyone know how? sys.sysservers will show servers, but no login information is presented.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This query will give you a listing of all the linked servers and their logins:
Add more columns if you need more information. Here are the base DMVs:
And a quick trace told me the answer:
And a query to find more info:
So I load this up in a multiple query connection and I can see which linked servers need to be updated when a database is moved from one database to another.