APP_NAME (Transact-SQL)
SQL Server 2005
Returns the application name for the current session if set by the application.
Transact-SQL Syntax Conventions
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
Reference
System Functions (Transact-SQL)Functions (Transact-SQL)