sp_addpublisher70 (T-SQL)

Adds a Microsoft® SQL Server™ version 7.0 Publisher at a SQL Server version 6.5 Subscriber. Use this stored procedure instead of sp_addpublisher.

Syntax

sp_addpublisher70 [@publisher =] 'publisher',
[@dist_account =] 'dist_account'

Arguments

[@publisher =] 'publisher': Is the name of the Publisher. publisher is varchar(30), with no default.
[@dist_account =] 'dist_account': Is the Microsoft Windows NT® account used by the Distribution Agent at the Distributor. In most cases, it is the Windows NT account of the SQL Server Agent at the Distributor. dist_account is varchar(255), with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_addpublisher70 is used in snapshot and transactional replication.

Because there is no remote procedure call (RPC) link between the Subscriber and the Publisher in SQL Server 7.0, calling sp_addpublisher at the Subscriber for a SQL Server 7.0 Publisher fails. To add a SQL Server 7.0 Publisher at a SQL Server 6.5 Subscriber, you must apply a script to the version 6.5 server that creates the sp_addpublisher70 stored procedure. The script is in the file Replp70.sql located in the \Mssql7\Install directory.

Permissions

On servers running SQL Server 6.5, execute permission defaults to the system administrator.