Temporary connections perform operations like running backups or initializing databases.
Use the system procedures sa_conn_info or sa_conn_list for information about temporary connections. The ParentConnection property returns the connection ID of the connection that spawned the temporary connection.
Temporary connections have connection IDs that are larger than 1 billion (1000000000), and their names describe the function of the connection.
SELECT Number, Name, ParentConnection FROM sa_conn_info();
Number Name ParentConnection ------------------------------------------------------------- 1000000048 INT: CreateDB 8 9 SQL_DBC_14675af8 (NULL) 8 SQL_DBA_152d5ac0 (NULL)