SQL Remote User's Guide
SQL Remote Design for Adaptive Server Enterprise
Partitioning tables that do not contain the subscription column
The Customer table can be partitioned using the rep_key value as a subscription column. A publication that includes the SalesRep and Customer tables would be as follows:
exec sp_add_remote_table 'SalesRep' exec sp_add_remote_table 'Customer' go exec sp_create_publication 'SalesRepData' go exec sp_add_article 'SalesRepData', 'SalesRep' exec sp_add_article SalesRepData, Customer, NULL, 'rep_key' go