Temporary Connections

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.

The following example uses the sa_conn_info system procedure to return a result set showing which connection created a temporary connection.

SELECT Number, Name, ParentConnection FROM sa_conn_info();

Connection 8 spawned the temporary connection that executed a CREATE DATABASE statement.

Number        Name               ParentConnection
-------------------------------------------------------------
1000000048    INT: CreateDB      8
9             SQL_DBC_14675af8   (NULL)
8             SQL_DBA_152d5ac0   (NULL)