sys.dm_exec_connections

Description

SQL analytics endpoint in Microsoft Fabric SQL database in Microsoft Fabric Returns information about the connections established to this instance of the database engine and the details of each connection. Returns server wide connection information for SQL Server and Azure SQL Managed Instance. Returns connection information for the current database in Azure SQL Database.

Syntax

sys.dm_exec_connections

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration. Requires VIEW SERVER SECURITY STATE permission on the server. Catalog Views (Transact-SQL) Endpoints Catalog Views (Transact-SQL) Permissions for SQL Server 2022 and later