This documentation is archived and is not being maintained.
Returns the application name for the current session if set by the application.
The following example checks whether the client application that initiated this process is a
SQL Server Management Studio session.
USE AdventureWorks; GO DECLARE @CurrentApp varchar(40) SET @CurrentApp = APP_NAME() IF @CurrentApp <> 'SQL Server Management Studio - Query' PRINT 'This process was not started by a SQL Server Management Studio query session.'; GO