login

See what user you are connecting to linked SQL server

I wanted to share with you guys a really handy little SQL query that is extremely useful if you are troubleshooting SQL Server linked server connectivity.  You may have setup a local server login to remote server login mapping which…