connect to...disconnect

Description

Component Integration Services only – Connects to the specified server and disconnects the connected server.

Syntax

connect to server_name
	disconnect

Parameters

server_name

is the server to which a passthrough connection is required.

Examples

Example 1

Establishes a passthrough connection to the server named SYBASE:

connect to SYBASE

Example 2

Disconnects the connected server:

disconnect 

Usage

Standards

SQL92 – Compliance level: Transact-SQL extension.

Permissions

Permission to use the connect to command must be explicitly granted by the System Administrator. The syntax is:

grant connect to user_name

The System Administrator can grant or revoke connect permission to public globally while in the master database. If the System Administrator wants to grant or revoke connect to permission for a particular user, the user must be a valid user of the master database, and the System Administrator must first revoke permission from public as follows:

use master
go
revoke connect from public
go
sp_adduser fred
go
grant connect to fred
go

See also

Commands create existing table, grant

System procedures sp_addserver, sp_autoconnect, sp_helpserver, sp_passthru, sp_remotesql, sp_serveroption