SQL Server/T-SQL Tutorial/System Functions/APP NAME

Returning the Application and Host for the Current User Session

4>
5> SELECT APP_NAME() as "Application"
6> GO
Application
------------------------------------------------------------------------------------------------------------------------
--------
SQLCMD

(1 rows affected)