| SQL Server 6.x |
SQL Server 2000 |
| sp_replica remotely set (on a Subscriber) a sysobjects category bit that marked the table as a replica. |
Removed; no longer supported or available. Remove all references to sp_replica. |
| sp_replsync acknowledged completion of a manual synchronization when used from a Subscriber. |
Removed; no longer supported or available. Remove all references to sp_replsync. |
| sp_helppublicationsync provided information about a scheduled synchronization task for a publication. |
No longer supported. An error message is returned if this stored procedure is used. Remove all references to sp_helppublicationsync. |
| sp_subscribe and sp_unsubscribe remotely added or canceled a subscription to a particular article within a publication, to a whole publication, or to all publications. |
No longer supported. An error message is returned if this stored procedure is used. Remove all references to either sp_subscribe or sp_unsubscribe, or use the @@ERROR function to test for errors. |
| name value parameter of sp_changepublication was used to provide the new publication name. |
Removed; no longer supported or available. Remove all references to the name value parameter of sp_changepublication. |
| sp_addpublisher added a Publisher at the Subscriber and added a Distribution Publisher at the Distributor. |
Replaced by sp_adddistpublisher. Remove all references to sp_addpublisher and replace with references to sp_adddistpublisher. |
| sp_droppublisher dropped a publication server. |
Removed; no longer supported or available. Remove all references to sp_droppublisher. To drop a Publisher at a Distributor, use sp_dropdistpublisher. |
| sp_distcounters was used to query for delivered or undelivered commands as used by Performance Monitor, which no longer uses this procedure. |
No longer supported. The new view MSdistribution_status presents much of the same information. |
| sp_helpreplicationdb was used to return information about a specified database or a list of all publication databases on the server. |
Removed; no longer supported. Remove all references to sp_helpreplicationdb and replace with references to sp_helpreplicationdboption. |
| sp_replstatus updated the internal table structure for replication. |
Removed; no longer supported. Remove references to sp_replstatus. |