To create a push subscription from a SQL Server 6.5 Publisher to a SQL Server 7.0 SubscriberMicrosoft® SQL Server™ version 7.0 can act as a Subscriber to a SQL Server 6.5 Publisher. You must add the SQL Server 7.0 Server as a Subscriber at the SQL Server 6.5 publishing server.
Note This action will also add an entry in the console tree of SQL Server Enterprise Manager. This is for replication purposes only, and you cannot administer this server using the SQL Server 6.5 version of SQL Server Enterprise Manager. If you click this server in the console tree, the following warning message will be returned (and can be ignored for replication purposes):
A connection cannot be established to <SERVER> - (SQL Server) You must upgrade your SQL enterprise Manager and SQL-DMO (SQLOLE) to version 7.0 (SQLDMO) to connect to this server
You cannot use the replication topology or pull subscription features of SQL Server Enterprise Manager 6.5 to manage the SQL Server 7.0 Subscriber.
To create a push subscription from a SQL Server 6.5 Publisher to a SQL Server 7.0 Subscriber
