SQL Tips by Namwar Rizvi

August 12, 2007

Finding client application name by TSQL

Filed under: Information,Query,tips,TSQL — namwar @ 2:10 PM

A friend of mine asked me is there any way to find the name of the application or client which is connected to the SQL Server by using just TSQL? I gave him the answer and thought that it will be useful to other readers of my blog. It is very simple to find the client application’s name. Following is the sample code:

Select APP_NAME() as currentApplication

Advertisements

3 Comments »

  1. Nice, just what I was looking for – and much easier than I thought it would be. Thanks for the tip.

    Comment by Joel — May 22, 2009 @ 6:34 PM | Reply

  2. how to find all client name of sql server.plz give me answer

    Comment by simmi — June 8, 2011 @ 6:51 AM | Reply

  3. I tried viewing your website on my blackberry and the layout doesnt seem to be right. Might want to check it out on WAP as well as it seems most cell phone layouts are not working with your website.

    Comment by click here — June 6, 2012 @ 12:15 PM | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: