SQL Server 6.5 provides the following stored procedures and extended stored procedures to support replication to ODBC subscribers.
| Procedure | Description |
|---|---|
| sp_enumdsn | Reports all defined ODBC DSNs in the same user context as the server. If the server is running in its default system account, only system DSNs will be reported. A server can be run in a Windows NT account; if the sp_enumdsn stored procedure is called, all DSNs for the system account are returned. When running as a service under a private user's Windows NT account, only those DSNs that are defined under the user's account are returned. |
| sp_dsninfo | Retrieves ODBC DSN information from the replication distributor that is associated with the current server if replication is installed. |
Note SQL Enterprise Manager (the recommended tool) automatically uses these stored procedures to set up replication to ODBC subscribers. You will use these stored procedures directly only if you are not using SQL Enterprise Manager.
For more information about these replication stored procedures, see What's New for Transact-SQL.