Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the application name for the current session if set by the application.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
APP_NAME ( )
Return Types
nvarchar(128)
Examples
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
See Also
Reference
System Functions (Transact-SQL)
Functions (Transact-SQL)