Adds a Microsoft® SQL Server™ version 7.0 or SQL Server 2000 Publisher at a SQL Server version 6.5 Subscriber. This stored procedure is executed at the SQL Server 6.5 Subscriber on any database.
sp_addpublisher70 [ @publisher = ] 'publisher' ,
[ @dist_account = ] 'dist_account'
[@publisher = ] 'publisher'
Is the name of the Publisher. publisher is varchar(30), with no default.
[@dist_account = ] 'dist_account'
Is the Microsoft Windows® account used by the Distribution Agent at the Distributor. In most cases, it is the Windows 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)
sp_addpublisher70 is used in snapshot replication and transactional replication.
To add a SQL Server 7.0 Publisher or SQL Server 2000 Publisher at a SQL Server 6.5 Subscriber, apply a script to the SQL Server 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.
On servers running SQL Server 6.5, execute permission defaults to the system administrator.