Returns the application name for the current session if set by the application.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
The following example checks whether the client application that initiated this process is a SQL Server Management Studio session.
USE AdventureWorks2012; GO DECLARE @CurrentApp varchar(128)= APP_NAME(); --SELECT @CurrentApp; IF @CurrentApp <> 'Microsoft SQL Server Management Studio - Query' PRINT 'This process was not started by a SQL Server Management Studio query session.' ; GO GO