| sample database : about | The sample database |
| schema changes : SQL Remote | Making schema changes |
| schema changes : SQL Remote Open Server | Other issues |
| security : replication | GRANT REMOTE DBA statement REVOKE REMOTE DBA statement |
| security : ssxtract | The Database Extraction utility |
| SEND AT : frequency setting | Selecting a send frequency |
| SEND AT clause | GRANT CONSOLIDATE statement GRANT REMOTE statement |
| SEND AT clause : publish | GRANT PUBLISH statement |
| SEND EVERY : frequency setting | Selecting a send frequency |
| SEND EVERY clause | GRANT CONSOLIDATE statement GRANT REMOTE statement |
| send frequency : selecting | Selecting a send frequency |
| send frequency : the Message Agent | Message Agent batch and continuous modes |
| sending messages | Send data from the consolidated database Enter data at the consolidated database Send data from the consolidated database |
| Send_VIM_Mail control parameter : VIM message system | VIM message control parameters |
| server-to-server replication | Server-to-server replication among offices |
| services : Message Agent as | Running the Message Agent as a service |
| setting up a remote database | Set up the remote database in Sybase Central Set up the remote database Set up the remote database in Sybase Central |
| setting up publications | Creating publications Creating publications |
| setting up subscriptions | Creating subscriptions Creating subscriptions |
| setting up the consolidated database | Setting up a consolidated database Set up the consolidated database Setting up the consolidated database Setting up the consolidated database |
| Silicon Graphics IRIX : availability on | Supported platforms and environments |
| SMTP : control parameters | SMTP message control parameters |
| SMTP : e-mail | The SMTP message system |
| SMTP : operating systems supported | The SMTP message system |
| SMTP : SQL Remote | The SMTP message system |
| SMTP message type | Using message types |
| SMTP/POP : addresses | Sharing SMTP/POP addresses |
| smtp_host control parameter : SMTP message system | SMTP message control parameters |
| software : dbremote | The Message Agent |
| software : ssqueue | The SQL Remote Open Server |
| software : ssremote | The Message Agent |
| software : SSXTRACT | The extraction command-line utility |
| sp_ procedure : syntax | sp_populate_sql_anywhere procedure |
| sp_add_article procedure : syntax | sp_add_article procedure |
| sp_add_article_col procedure : syntax | sp_add_article_col procedure |
| sp_add_remote_table procedure : syntax | sp_add_remote_table procedure |
| sp_create_publication procedure : syntax | sp_create_publication procedure |
| sp_drop_publication procedure : syntax | sp_drop_publication procedure |
| sp_drop_remote_type procedure : syntax | sp_drop_remote_type procedure |
| sp_drop_sql_remote procedure : syntax | sp_drop_sql_remote procedure |
| sp_grant_consolidate procedure : syntax | sp_grant_consolidate procedure |
| sp_grant_remote procedure : syntax | sp_grant_remote procedure |
| sp_modify_article procedure : syntax | sp_modify_article procedure |
| sp_modify_remote_table procedure : syntax | sp_modify_remote_table procedure |
| sp_passthrough procedure : about | Using passthrough mode |
| sp_passthrough procedure : syntax | sp_passthrough procedure |
| sp_passthrough_piece procedure : about | Using passthrough mode |
| sp_passthrough_piece procedure : syntax | sp_passthrough_piece procedure |
| sp_passthrough_stop procedure : about | Using passthrough mode |
| sp_passthrough_stop procedure : syntax | sp_passthrough_stop procedure |
| sp_passthrough_subscription procedure : about | Using passthrough mode |
| sp_passthrough_subscription procedure : syntax | sp_passthrough_subscription procedure |
| sp_passthrough_user procedure : about | Using passthrough mode |
| sp_passthrough_user procedure : syntax | sp_passthrough_user procedure |
| sp_populate_sql_anywhere procedure : about | Customizing the system tables |
| sp_publisher procedure : syntax | sp_publisher procedure |
| sp_queue_clean procedure : syntax | sp_queue_clean procedure |
| sp_queue_delete_old procedure : syntax | sp_queue_delete_old procedure |
| sp_queue_drop procedure : syntax | sp_queue_drop procedure |
| sp_queue_dump_database procedure : syntax | sp_queue_dump_databaseprocedure |
| sp_queue_dump_transaction procedure : syntax | sp_queue_dump_transaction procedure |
| sp_queue_get_state procedure : syntax | sp_queue_get_state procedure |
| sp_queue_read procedure : syntax | sp_queue_read procedure |
| sp_queue_reset procedure : syntax | sp_queue_reset procedure |
| sp_queue_set_confirm procedure : syntax | sp_queue_set_confirm procedure |
| sp_queue_set_progress procedure : syntax | sp_queue_set_progress procedure |
| sp_queue_transaction procedure : syntax | sp_queue_transaction procedure |
| sp_remote procedure : syntax | sp_remote procedure |
| sp_remote_option procedure : syntax | sp_remote_option procedure |
| sp_remote_type procedure : syntax | sp_remote_type procedure |
| sp_remove_article procedure : syntax | sp_remove_article procedure |
| sp_remove_article_col procedure : syntax | sp_remove_article_col procedure |
| sp_remove_remote_table procedure : syntax | sp_remove_remote_table procedure |
| sp_revoke_consolidate procedure : syntax | sp_revoke_consolidate procedure |
| sp_revoke_remote procedure : syntax | sp_revoke_remote procedure |
| sp_setreplicate procedure : sp_add_remote_table | sp_add_remote_table procedure |
| sp_subscription procedure : about | Creating subscriptions |
| sp_subscription procedure : syntax | sp_subscription procedure |
| sp_subscription procedure : using | Synchronizing data over a message system |
| sp_user_extraction_hook : example | Maintaining the subscription-list column |
| sp_user_extraction_hook procedure : about | Customizing the system tables |
| SQL Remote : about | CHAPTER 2. SQL Remote Replication Concepts |
| SQL Remote : administering | SQL Remote features Uses and limitations of passthrough mode |
| SQL Remote : ALTER REMOTE MESSAGE TYPE statement | ALTER REMOTE MESSAGE TYPE statement |
| SQL Remote : altering publications | ALTER PUBLICATION statement |
| SQL Remote : articles | SYSARTICLE table sr_article table |
| SQL Remote : case studies | Some sample installations Server-to-laptop replication for mobile workforces Server-to-server replication among offices |
| SQL Remote : concepts | SQL Remote concepts |
| SQL Remote : consolidate permissions | GRANT CONSOLIDATE statement REMOTE RESET statement REVOKE CONSOLIDATE statement |
| SQL Remote : consolidated databases | Consolidated and remote databases |
| SQL Remote : CREATE REMOTE MESSAGE TYPE statement | CREATE REMOTE MESSAGE TYPE statement |
| SQL Remote : creating publications | Add publications and subscriptions Create publications and subscriptions Create the publication and subscription CREATE PUBLICATION statement |
| SQL Remote : creating subscriptions | CREATE SUBSCRIPTION statement |
| SQL Remote : DROP REMOTE MESSAGE TYPE statement | DROP REMOTE MESSAGE TYPE statement |
| SQL Remote : dropping publications | DROP PUBLICATION statement |
| SQL Remote : dropping subscriptions | DROP SUBSCRIPTION statement |
| SQL Remote : extracting a database | The extraction command-line utility |
| SQL Remote : GRANT PUBLISH statement | GRANT PUBLISH statement |
| SQL Remote : granting publish permissions | Add the publisher and remote user to the database Grant PUBLISH and REMOTE at the consolidated database |
| SQL Remote : granting remote permissions | Add the publisher and remote user to the database Grant PUBLISH and REMOTE at the consolidated database |
| SQL Remote : message delivery | The message tracking system Status information in the remoteuser table Tracking messages by transaction log offsets Handling of lost or corrupt messages |
| SQL Remote : message tracking | The message tracking system Status information in the remoteuser table Handling of lost or corrupt messages |
| SQL Remote : mobile workforces | SQL Remote features Server-to-laptop replication for mobile workforces |
| SQL Remote : multi-tier installations | Uses and limitations of passthrough mode |
| SQL Remote : options | SQL Remote options |
| SQL Remote : passthrough mode | PASSTHROUGH statement |
| SQL Remote : publications | Publications and subscriptions |
| SQL Remote : publish permissions | REVOKE PUBLISH statement |
| SQL Remote : remote databases | Consolidated and remote databases |
| SQL Remote : remote permissions | GRANT REMOTE statement REVOKE REMOTE statement |
| SQL Remote : server-to-laptop replication | Server-to-laptop replication for mobile workforces |
| SQL Remote : server-to-server replication | Server-to-server replication among offices |
| SQL Remote : setting up | A tutorial using Sybase Central A tutorial using Interactive SQL and DBXTRACT Setting up SQL Remote using Sybase Central A tutorial using isql and ssxtract |
| SQL Remote : setting up a consolidated database | Setting up a consolidated database Set up the consolidated database Setting up the consolidated database Setting up the consolidated database |
| SQL Remote : setting up a remote database | Set up the remote database in Sybase Central Set up the remote database Set up the remote database in Sybase Central |
| SQL Remote : setup examples | Some sample installations |
| SQL Remote : ssremote | Send data from the consolidated database |
| SQL Remote : SSXTRACT utility | The extraction command-line utility |
| SQL Remote : starting subscriptions | START SUBSCRIPTION statement |
| SQL Remote : stopping subscriptions | STOP SUBSCRIPTION statement |
| SQL Remote : subscribers | SQL Remote features |
| SQL Remote : subscriptions | Publications and subscriptions |
| SQL Remote : synchronization | The extraction command-line utility |
| SQL Remote : synchronizing subscriptions | SYNCHRONIZE SUBSCRIPTION statement |
| SQL Remote : system tables | SYSARTICLE table sr_article table |
| SQL Remote : transaction log management | Transaction log and backup management Managing old transaction logs Backup procedures at remote databases Adaptive Server Enterprise transaction log and backup management |
| SQL Remote : uninstalling | sp_drop_sql_remote procedure sp_queue_drop procedure |
| SQL Remote : unloading databases | Unloading and reloading a consolidated database |
| SQL Remote : upgrading | Upgrading SQL Remote for Adaptive Server Enterprise |
| SQL Remote : upgrading databases | Upgrading consolidated databases |
| SQL Remote Open Server : architecture | Architecture for Replication Server/SQL Remote installations |
| SQL Remote Open Server : commline | The SQL Remote Open Server |
| SQL Remote Open Server : on IRIX | Supported platforms and environments |
| SQL Remote Open Server : procedures | Other issues |
| SQL Remote Open Server : schema changes | Making schema changes |
| SQL Remote Open Server : setting up | Setting up SQL Remote Open Server |
| SQL Remote Open Server : when needed | When you need to use the SQL Remote Open Server |
| SQL Remote procedures : sp_ | sp_populate_sql_anywhere procedure |
| SQL Remote procedures : sp_add_article | sp_add_article procedure |
| SQL Remote procedures : sp_add_article_col | sp_add_article_col procedure |
| SQL Remote procedures : sp_add_remote_table | sp_add_remote_table procedure |
| SQL Remote procedures : sp_create_publication | sp_create_publication procedure |
| SQL Remote procedures : sp_drop_publication | sp_drop_publication procedure |
| SQL Remote procedures : sp_drop_remote_type | sp_drop_remote_type procedure |
| SQL Remote procedures : sp_drop_sql_remote | sp_drop_sql_remote procedure |
| SQL Remote procedures : sp_grant_consolidate | sp_grant_consolidate procedure |
| SQL Remote procedures : sp_grant_remote | sp_grant_remote procedure |
| SQL Remote procedures : sp_modify_article | sp_modify_article procedure |
| SQL Remote procedures : sp_modify_remote_table | sp_modify_remote_table procedure |
| SQL Remote procedures : sp_passthrough | sp_passthrough procedure |
| SQL Remote procedures : sp_passthrough_piece | sp_passthrough_piece procedure |
| SQL Remote procedures : sp_passthrough_stop | sp_passthrough_stop procedure |
| SQL Remote procedures : sp_passthrough_subscription | sp_passthrough_subscription procedure |
| SQL Remote procedures : sp_passthrough_user | sp_passthrough_user procedure |
| SQL Remote procedures : sp_publisher | sp_publisher procedure |
| SQL Remote procedures : sp_queue_clean | sp_queue_clean procedure |
| SQL Remote procedures : sp_queue_delete_old | sp_queue_delete_old procedure |
| SQL Remote procedures : sp_queue_drop | sp_queue_drop procedure |
| SQL Remote procedures : sp_queue_dump_database | sp_queue_dump_databaseprocedure |
| SQL Remote procedures : sp_queue_dump_transaction | sp_queue_dump_transaction procedure |
| SQL Remote procedures : sp_queue_get_state | sp_queue_get_state procedure |
| SQL Remote procedures : sp_queue_read | sp_queue_read procedure |
| SQL Remote procedures : sp_queue_reset | sp_queue_reset procedure |
| SQL Remote procedures : sp_queue_set_confirm | sp_queue_set_confirm procedure |
| SQL Remote procedures : sp_queue_set_progress | sp_queue_set_progress procedure |
| SQL Remote procedures : sp_queue_transaction | sp_queue_transaction procedure |
| SQL Remote procedures : sp_remote | sp_remote procedure |
| SQL Remote procedures : sp_remote_option | sp_remote_option procedure |
| SQL Remote procedures : sp_remote_type | sp_remote_type procedure |
| SQL Remote procedures : sp_remove_article | sp_remove_article procedure |
| SQL Remote procedures : sp_remove_article_col | sp_remove_article_col procedure |
| SQL Remote procedures : sp_remove_remote_table | sp_remove_remote_table procedure |
| SQL Remote procedures : sp_revoke_consolidate | sp_revoke_consolidate procedure |
| SQL Remote procedures : sp_revoke_remote | sp_revoke_remote procedure |
| SQL Remote procedures : sp_subscription | sp_subscription procedure |
| SQL Remote system tables : article | SYSARTICLE table sr_article table |
| SQL Remote system tables : articlecol | SYSARTICLECOL table sr_articlecol table |
| SQL Remote system tables : marker | sr_marker table |
| SQL Remote system tables : object | sr_object table |
| SQL Remote system tables : option | sr_option table |
| SQL Remote system tables : passthrough | sr_passthrough table |
| SQL Remote system tables : publication | SYSPUBLICATION table sr_publication table |
| SQL Remote system tables : publisher | sr_publisher table |
| SQL Remote system tables : remotetable | sr_remotetable table |
| SQL Remote system tables : remotetype | SYSREMOTETYPE table sr_remotetype table |
| SQL Remote system tables : remoteuser | SYSREMOTEUSER table sr_remoteuser table |
| SQL Remote system tables : subscription | SYSSUBSCRIPTION table sr_subscription table |
| SQL Remote system views : articlecols | SYSARTICLECOLS view sr_articlecols view |
| SQL Remote system views : articles | SYSARTICLES view sr_articles view |
| SQL Remote system views : publications | SYSPUBLICATIONS view sr_publications view |
| SQL Remote system views : remotetables | sr_remotetables view |
| SQL Remote system views : remotetypes | sr_remotetypes view |
| SQL Remote system views : remoteusers | SYSREMOTEUSERS view sr_remoteusers view |
| SQL Remote system views : subscriptions | SYSSUBSCRIPTIONS view sr_subscriptions view |
| SQL Remote tables : #remote | #remote table |
| SQL statements : replication of | How statements are replicated Replication of inserts and deletes Replication of updates Replication of data definition statements |
| SQLANY.INI : SQL Remote | Setting message type control parameters |
| SQLRemote environment variable | Setting message type control parameters |
| SQLREMOTE environment variable : alternative to | FILE message control parameters |
| squpdate.sql : upgrading the stable queue | Upgrading SQL Remote for Adaptive Server Enterprise |
| sr_article table : about | sr_article table |
| sr_articlecol table : about | sr_articlecol table |
| sr_marker table : about | sr_marker table |
| sr_object table : about | sr_object table |
| sr_option table : about | sr_option table |
| sr_passthrough table : about | sr_passthrough table |
| sr_publication table : about | sr_publication table |
| sr_publisher table : about | sr_publisher table |
| sr_queue_state table : about | sr_queue_state table |
| sr_remotetable table : about | sr_remotetable table |
| sr_remotetype table : about | sr_remotetype table |
| sr_remoteuser table : about | sr_remoteuser table |
| sr_subscription table : about | sr_subscription table |
| sr_transaction table : about | sr_transaction table |
| ssqueue : about | CHAPTER 13. Using SQL Remote with Replication Server The SQL Remote Open Server |
| ssqueue : architecture | Architecture for Replication Server/SQL Remote installations |
| ssqueue : commline | The SQL Remote Open Server |
| ssqueue : on IRIX | Supported platforms and environments |
| ssqueue : setting up | Setting up SQL Remote Open Server |
| ssqueue : when needed | When you need to use the SQL Remote Open Server |
| ssremote | Send data from the consolidated database |
| SSREMOTE : about | Running the Message Agent Running the Message Agent |
| ssremote : about | The Message Agent |
| ssremote : commline | The Message Agent |
| ssupdate.sql : upgrading SQL Remote | Upgrading SQL Remote for Adaptive Server Enterprise |
| ssxtract : about | Synchronizing databases |
| SSXTRACT : about | The extraction command-line utility |
| SSXTRACT : command line | The extraction command-line utility |
| ssxtract : using | Using the extraction utility |
| SSXTRACT : using | Using the extraction utility for Adaptive Server Enterprise Adaptive Server Enterprise features unsupported in Adaptive Server Anywhere Customizing the system tables |
| stable queue : cleaning | The Message Agent |
| stable queue : Replication Server | How the pieces fit together |
| stable queue : SQL Remote Open Server | How the pieces fit together |
| stable queue : ssqueue | How the pieces fit together |
| stable queue : system tables | Stable Queue tables |
| START SUBSCRIPTION statement : syntax | START SUBSCRIPTION statement |
| starting : the Message Agent | Starting the Message Agent |
| starting subscriptions | START SUBSCRIPTION statement |
| statements : replication of | How statements are replicated Replication of inserts and deletes Replication of updates |
| STOP SUBSCRIPTION statement : syntax | STOP SUBSCRIPTION statement |
| stopping subscriptions | STOP SUBSCRIPTION statement |
| store-and-forward | Message-based replication |
| stored procedures : passthrough mode | Operations not replicated in passthrough mode |
| stored procedures : replication of | Replication of procedures |
| stored procedures : SQL Remote Open Server | Other issues |
| subqueries : in SQL Remote | Partitioning tables that do not contain the subscription expression |
| subqueries : publications | Partitioning tables that do not contain the subscription expression |
| SUBSCRIBE BY clause | CREATE PUBLICATION statement |
| SUBSCRIBE_BY_REMOTE : replication option | SQL Remote options |
| Subscribe_by_remote option : many-to-many relationships | Using the Subscribe_by_remote option with many-to-many relationships Using the Subscribe_by_remote option with many-to-many relationships |
| subscription expressions : about | Publishing a subset of rows using a subscription expression Creating an article using a subscription column |
| subscription expressions : cost of evaluating | Who gets what? |
| subscription expressions : in the transaction log | Who gets what? |
| subscription expressions : many-valued | Who gets what? |
| subscription expressions : subqueries | Partitioning tables that do not contain the subscription expression |
| subscription SQL Remote table : about | SYSSUBSCRIPTION table sr_subscription table |
| subscription-list columns : about | Adding a subscription-list column to the Contact table |
| subscription-list columns : in SQL Remote | Partitioning tables that do not contain the subscription column The Contact example |
| subscription-list columns : maintaining | Maintaining the subscription-list column Maintaining the subscription-list column Maintaining the subscription-list column |
| subscription-list columns : triggers | Maintaining the subscription-list column |
| subscription-list columns : triggers for | Maintaining the subscription-list column |
| subscriptions : about | Publications and subscriptions |
| subscriptions : dropping | DROP SUBSCRIPTION statement |
| subscriptions : performance | Who gets what? |
| subscriptions : setting up | Creating subscriptions Creating subscriptions |
| subscriptions : starting | START SUBSCRIPTION statement |
| subscriptions : stopping | STOP SUBSCRIPTION statement |
| subscriptions : synchronizing | Using the extraction utility Synchronizing data over a message system SYNCHRONIZE SUBSCRIPTION statement |
| subscriptions : the Message Agent | Who gets what? |
| subscriptions : updates | UPDATE statement |
| subscriptions SQL Remote view : about | SYSSUBSCRIPTIONS view sr_subscriptions view |
| Sun Solaris : availability on | Supported platforms and environments |
| Sybase Central : creating publications with | Creating publications for Adaptive Server Anywhere using Sybase Central Creating publications for Adaptive Server Enterprise using Sybase Central |
| Sybase Central : extraction utility | Using the extraction utility from Sybase Central |
| Sybase Central : message types | Using Sybase Central to work with message types Using Sybase Central to work with message types Using commands to work with message types |
| synchronization : about | Synchronizing databases |
| synchronization : of databases | CHAPTER 9. Deploying and Synchronizing Databases Deployment overview |
| synchronization : operating systems | Mixed operating systems and database extraction |
| synchronization : using DBXTRACT | Using the extraction utility |
| synchronization : using ssztract | Using the extraction utility |
| synchronization : using the extraction utility | Using the extraction utility |
| synchronization utility | Extract the remote database information |
| SYNCHRONIZE SUBSCRIPTION statement : about | Synchronizing data over a message system |
| SYNCHRONIZE SUBSCRIPTION statement : syntax | SYNCHRONIZE SUBSCRIPTION statement |
| synchronizing databases | Extract the remote database information Load the remote database information |
| synchronizing databases : using the message system | Synchronizing data over a message system |
| synchronizing subscriptions | SYNCHRONIZE SUBSCRIPTION statement |
| SYSREMOTEUSER table | Status information in the remoteuser table Tracking messages by transaction log offsets |
| system objects : the dbo user | The Database Extraction utility |
| system tables : stable queue | Stable Queue tables |
| system tables : SYSARTICLE | SYSARTICLE table sr_article table |