Connection management

Connection management#

Stored procedures for creating and managing connections (linked servers) to data sources.

Stored procedure name

Description

sp_addlinkedserver

Creates a connection to a data source. A connection allows for access to a single data source (endpoint).

sp_addlinkedsrvlogin

Creates or updates a mapping between a connection on the local instance of Querona and a security account on a remote data source.

sp_dropserver

Removes a connection from the list of known connections on the instance of Querona.

sp_linkedservers

Returns a list of connections (aka. linked servers) accessible by the current user.

sp_testlinkedserver

Tests the connection to a data source.

sp_updatelinkedserver

Updates a connection to a data source.