Find Hostname and Current Logged In User Name

home
database
view story

2 Kicks

Find Hostname and Current Logged In User Name(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years ago

I work in an environment wherein I connect to multiple servers across the world. Time and again, my SSMS is connected to a myriad of servers that kindles a lot of confusion. I frequently use the following trick to separate different connections, which I mentioned in my blog sometime back SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor. However, this trick does not help when a huge number of different connections are open. In such a case, I use the following handy script. Do not go by the length of the script; it might be very short but always works great!

add a comment |category: Database |Views: 54
Tweet