sp_dsninfo
Returns ODBC or OLE DB data source information from the Distributor associated with the current server. This stored procedure is executed at the Distributor on any database.
Syntax
sp_dsninfo [ @dsn =] 'dsn'
[ , [ @infotype =] 'info_type']
[ , [ @login =] 'login']
[ , [ @password =] 'password']
[ , [ @dso_type =] dso_type]
Arguments
[@dsn = ] 'dsn'
Is the name of the ODBC DSN or OLE DB linked server. dsn is varchar(128), with no default.
[@infotype = ] 'info_type'
Is the type of information to return. If info_type is not specified or if NULL is specified, all information types are returned. info_type is varchar(128), with a default of NULL, and can be one of these values.
| Value | Description |
|---|---|
| DBMS_NAME | Specifies the data source vendor name. |
| DBMS_VERSION | Specifies the data source version. |
| DATABASE_NAME | Specifies the database name. |
| SQL_SUBSCRIBER | Specifies the data source can be a Subscriber. |
[@login = ] 'login'
Is the login for the data source. If the data source includes a login, specify NULL or omit the parameter. login is varchar(128), with a default of NULL.
[@password = ] 'password'
Is the password for the login. If the data source includes a login, specify NULL or omit the parameter. password is varchar(128), with a default of NULL.
[@dso_type = ] dso_type
Is the data source type. dso_type is int, and can be one of these values.
| Value | Description |
|---|---|
| 1 (default) | ODBC data source |
| 3 | OLE DB data source |
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| Information Type | nvarchar(64) | Information types such as DBMS_NAME, DBMS_VERSION, DATABASE_NAME, SQL_SUBSCRIBER. |
| Value | nvarchar(512) | Value of the associated information type. |
Remarks
sp_dsninfo is used in all types of replication.
sp_dsninfo retrieves ODBC or OLE DB data source information that shows whether the database can be used for replication or querying.
Permissions
Only members of the sysadmin fixed server role can execute sp_dsninfo.