A Guide to SQL Server 2000 Transactional and Snapshot Replication |
Contents
An Introduction to Replication | 1 |
Snapshot Replication with Immediate Updating | 25 |
Planning for Replication | 31 |
Installing Replication | 37 |
Enabling Subscribers | 44 |
26 | 60 |
Using a Remote Distributor | 68 |
Migrating to a Remote Distributor | 74 |
The TransPublication2 Class | 625 |
New Tips | 649 |
The TransArticle2 Class | 678 |
The TransSubscription2 Class | 703 |
DTSPackagePassword | 704 |
The TransPullSubscription2 Class | 716 |
FTPAddress | 717 |
FTPPort | 730 |
New KB articles | 81 |
Replication Alerts | 95 |
Summary | 119 |
List your Publication in Active Directory | 150 |
Subscriptions Options | 164 |
Advanced Options of the Create Publication Wizard | 174 |
Summary | 221 |
Snapshot Agent | 227 |
Advanced Options | 292 |
Setting up Subscribers to use a Transformable | 298 |
Summary | 313 |
Creating Subscriptions to Transctional and Snapshot | 343 |
Pull Subscriptions | 372 |
Pull Subscriptions using Windows Synchronization Manager | 401 |
Copy Subscription Database | 417 |
Replication Stored Procedures for Snapshot | 425 |
Creating and configuring the Snapshot Agent | 472 |
Creating and configuring a pull Subscriber | 565 |
Adding Articles to your Snapshot or Transactional Publication | 574 |
Summary | 582 |
Creating Publications | 588 |
ReInitialize Method | 737 |
Transactional and Snapshot Programming using ActiveX | 749 |
ProfileName Property | 755 |
DistributorAddress | 760 |
SubscriberLogin | 773 |
ReinitializeSubscription | 779 |
Snapshot and Transactional Replication Internals | 785 |
tempdb | 806 |
SnapShot exe | 810 |
LogRead exe | 816 |
Distrib exe | 827 |
Summary | 838 |
General Troubleshooting Tips | 848 |
Testing your Replication Solution | 864 |
Miscellaneous Replication Problems | 899 |
Summary | 925 |
publication | 929 |
Appendix | 953 |
Appendix C | 965 |
Common terms and phrases
Active Directory advanced options allows anonymous subscriptions au_id Authentication Cancel Apply Help check box Code Sample command connect Const Create Publication Wizard data source Data Transformation Services data type DBAs default Delete dialog box Fig Distribution Agent distribution database Distributor DTS package enable error example filter FTP server illustrates the usage Immediate Updating Indexed View INSERT linked server login Merge replication Microsoft Microsoft Message Queuing Microsoft SQL Server NULL object objTransArticle objTransPullSubscription ODBC OK Cancel Apply OK Cancel Help OLE DB parameter password primary key Publisher and Subscriber pull subscription Push Subscription Wizard Queued Updating Replication Monitor rows Schedule schema script selcure Server Enterprise Manager ServerName SET objReplication SET objServer SET objTransPublications Snapshot Agent snapshot files snapshot folder Snapshot publication Snapshot replication Specify SQL Server Enterprise stored procedure string subscription database Subscriptions dialog box Sybase Transactional publication Transactional replication Updatable Subscriptions User Windows NT