Part number DC38133-01-0902-01 Last modified October
SQL Remote User’s Guide
Page
Contents
SQL Remote Design for Adaptive Server Enterprise 141
SQL Remote Administration 199
Principles of SQL Remote Design
SQL Remote Design for Adaptive Server Anywhere
Utilities and Options Reference 291
Administering SQL Remote for Adaptive Server Anywhere241
Using SQL Remote with Replication Server 277
System Objects for Adaptive Server Anywhere 325
Command Reference for Adaptive Server Enterprise 379
Command Reference for Adaptive Server Anywhere 353
Index 449
Server Anywhere Differences 437
SQL Remote for Adaptive Server Enterprise and Adaptive
Supported Platforms and Message Links 445
Viii
About This Manual
Mail or file transfer
Systems
Adaptive Server Anywhere Database Administration Guide This
SQL Anywhere Studio documentation
Page
Page
Release Savepoint savepoint-name
Documentation conventions
Xiv
Following icons are used in this documentation
Client application
Database server, such as Sybase Adaptive Server Anywhere
Asademo.db
Adaptive Server Anywhere sample database
Finding out more and providing feedback
Page
Xviii
Introduction to SQL Remote
Page
This chapter introduces SQL Remote and the documentation
Welcome to SQL Remote
About SQL Remote
SQL Remote for Adaptive Server Anywhere Enables replication
About this manual
Product installation
To install the SQL Remote software Windows
To install the SQL Remote software Unix
Page
SQL Remote
SQL Remote Concepts
SQL Remote components
Data server
Client applications
Message Agent
Message system client
Two-table synchronization definition
Publications and subscriptions
At the remote database
Replication
SQL Remote features
Page
Server-to-laptop replication for mobile workforces
Some sample installations
Server-to-server replication among offices
More
Page
Setting Up SQL Remote
You must take some steps to
Setup overview
Each user in the installation
Sybase System Administrator should perform all SQL Remote
Ensuring Tempdb is large enough
Installing the SQL Remote system objects
To install the SQL Remote system objects
Preparing your Adaptive Server Enterprise server
SQL Remote system objects
To install the stable queue
Command-line installation of the stable queue
Page
Upgrading SQL Remote for Adaptive Server Enterprise
To upgrade SQL Remote
Uninstalling SQL Remote
To uninstall the SQL Remote objects from a database
To uninstall the stable queue from a database
Tutorials for Adaptive Server Anywhere Users
Database
Just on those issues important for replication
Introduction
Goals
Tables are described in more detail as follows
Tutorials for Adaptive Server Anywhere Users
Custkey
Replication goals
Repkey
Name
Sybase Central or command-line utilities
To prepare for the tutorial
Preparing for the Sybase Central replication tutorial
To add tables to the consolidated database
Add a SQL Remote message type
Setting up a consolidated database
Add the publisher and remote user to the database
To add an address to a message type
To create a new user as the publisher
To add a remote user
Add publications and subscriptions
To add a publication
Publication for the remote database user fielduser
Set up the remote database in Sybase Central
Enter the expression repkey
Click Finish to create the publication
To extract a database
To create the databases and directories for the tutorial
Preparing for the replication tutorial
Set up the consolidated database
To add the tables to the consolidated database
Create a SQL Remote message type
To create the message type
Grant Publish and Remote at the consolidated database
To create a publisher for the database
Create publications and subscriptions
SQL, to create a publication
Table SalesRep, and some of the rows of the table Customer
Set up the remote database
To create the publication
To create the subscription
Extract the remote database information
Load the remote database information
To load the database information
Select * from SalesRep Select * from Customer
First, enter some data into the consolidated database
Start replicating data
Enter data at the consolidated database
Send data from the consolidated database
Receive data at the remote database
To send the data to the remote database
To receive data at the remote database
Commit the insertion by executing the following statement
To verify that the data has arrived
Custkey Name Repkey
To add the publication to the sample database
Sample publication
Page
Tutorial for Adaptive Server Enterprise Users
Database schema for the tutorial is illustrated in the figure
SalesRep table is many-to-one
Tutorial for Adaptive Server Enterprise Users
Page
First steps
Tutorial Adaptive Server Enterprise replication
To install SQL Remote into the hq database
Setting up the consolidated database
Create the SalesRep table with the following statement
Create the Customer table with the following statement
Create the necessary users and permissions
Create the message links and addresses
To create the subscriber
To create the publisher
Create an empty publication
Create the publication and subscription
Extract the remote database
To create a subscription
Create a subscription to SalesRepData for fielduser , with a
Subscription value of rep1
To load the data into the database using Interactive SQL
Utility on
To create a database file named field.db
Connect to the server using the Interactive SQL utility
To load the data into the database as a batch process
Run the script from Interactive SQL
Connect to the Adaptive Server Enterprise server from isql
To enter data at the Adaptive Server Enterprise database
To receive the data at Adaptive Server Anywhere
To replicate the data from Adaptive Server Enterprise
Commit the row
Custkey Name Repkey
Page
Replication Design for SQL Remote
Page
Principles of SQL Remote Design
SQL Remote replicates data
Adaptive Server Enterprise System Administrator or database
Design overview
Ensuring compatible databases
Between Ssremote and Adaptive Server Enterprise whenever
Using compatible sort orders and character sets
SQL Remote Message Agent does not perform any character set
Conversions
819LATIN1
Eucjapan
Replication of updates
How statements are replicated
Replication of inserts and deletes
Representatives
Clause of the Update statement
User, the row to be updated is not found
Statement
Replication of triggers
Replication of procedures
This case, the Update does not update anything
Procedure call is not replicated
Some Before triggers can produce
Message causing the conflict
Body of your triggers
Actions carried out by conflict
Replication of data definition statements
Replication of blobs
How data types are replicated
Replication of dates and times
Select
Who gets what?
Principles of SQL Remote Design
Replication errors and conflicts
Replication errors
Replication conflicts
Detected
Tracking SQL errors
Issue the following statement
VARCHAR, or Long VARCHAR. The procedure is called once with
Page
SQL Remote Design for Adaptive Server Anywhere
Information each user receives
Publications determine what information
Is shared among which databases
Subscriptions determine what
To publish one or more entire tables SQL
Publishing data
Publishing whole tables
To publish one or more entire tables Sybase Central
Publishing only some columns in a table
For more information, see the Create Publication statement
To publish only some columns in a table Sybase Central
To publish only some columns in a table SQL
Publishing only some rows in a table
Publishing only some rows using a Where clause
To create a publication using a Where clause Sybase Central
To create a publication using a Where clause SQL
Publishing only some rows using a subscription expression
Column
To create an article using a subscription expression SQL
To add articles Sybase Central
Altering existing publications
Dropping publications
To remove articles Sybase Central
To modify an existing publication SQL
To delete a publication Sybase Central
To delete a publication SQL
See also the Drop Publication statement ASA SQL Reference,
Publication design for Adaptive Server Anywhere
Design issues overview
Design tips for performance
Conditions for valid articles
Pay attention to Update Publication Triggers In particular
Here is a simple database that illustrates the problem
Contact example
Three tables are described in more detail as follows
Following information
Those customers assigned to them, from the Customer table
106
Partitioning the Customer table in the Contact example
Partitioning the Contact table in the Contact example
Territory realignment in the Contact example
For which there is no longer a Customer
Reps
Properly transferred to the new sales representative
Along with the Customer
Special Update statement for publications
∙ Customer table
Understanding this helps in designing efficient publications
Assume the following data
∙ SalesRep table
SalesRepData Publication Name rep1 Before list
Sharing rows among several subscriptions
Policy example
Many-to-many relationship in the database
113
With the following information
Entire SalesRep table
Involving the sales rep subscribed to the data
Publication
Contact example on
Territory realignment with a many-to-many relationship
116
Remote databases contain the proper data
Dealing with the customer, taken from the Policy table
Customer being transferred Where custkey = OldRow.custkey
That this subquery can be multi-valued
Can be multi-valued
Customer
SQL Remote Design for Adaptive Server Anywhere
ID Rep Dept Ann Marc
Managing conflicts
Updating
Must be excluded from the installation by proper design
SQL Remote installation at the consolidated database
How SQL Remote handles conflicts
Using conflict resolution triggers
Implementing conflict resolution
Referencing OLD AS oldval
Create Trigger trigger-name
Resolving date conflicts
Conflict resolution examples
Resolving inventory conflicts
Reporting conflicts
Increments from the two updates. For example
Designing to avoid referential integrity errors
Designing triggers to avoid errors
Includes the salesorder table
Page
Ensuring unique primary keys
Using global autoincrement default column values
Setting the Globaldatabaseid value
Declaring default global autoincrement
Primary key values for Global Default Autoincrement values
To set the global database identification number
Database will have Globaldatabaseid set to
How default values are chosen
Using primary key pools
Primary key pool table
Replicating the primary key pool
To replicate the primary key pool SQL
Filling and replenishing the key pool
Cursor for
136
Else
Adding new customers
Insert
Primary key pool summary
To create and manage subscriptions in Sybase Central
Creating subscriptions
140
For more information, see Create Subscription statement on
141
SQL Remote Design for Adaptive Server Enterprise
Design overview
Creating publications
Creating whole-table articles
Creating articles containing some of the columns in a table
Creating articles containing some of the rows in a table
Creating an article using a Where clause
To create an article using a Where clause
Creating an article using a subscription column
To create an article using a subscription column
Spaddremotetable tablename
Spaddarticle publicationname, tablename NULL, columnname
Publication design for Adaptive Server Enterprise
Insert Succeeds
149
To handle this case, using an example
Contain the subscription column
Two tables described earlier in this chapter
150
Are realigned
Exec spcreatepublication ’SalesRepData’ go
Adding a subscription-list column to the Contact table
Log entries are values, not subscribers
For the following operations
Update on the Contact table
Update on the Customer table
Maintaining the subscription-list column
SQL Remote Design for Adaptive Server Enterprise
Tuning extraction performance
To create a subscription view
Create a view that contains this subquery. For example
156
Solving the problem
Foreign KEY
158
Subscriptions to this publication take the following form
These objects
159
Triggers
For Insert AS Begin
161
Ensure the quotedidentifier option is set to on
Tuning extraction performance for shared rows
163
Customer
Managing conflicts
When the conflicting message arrived
Consolidated database, no row will be updated
Any conflict resolution procedures are called
Database objects to handle the resolution
This table must have the same column names
Names of the conflict resolution objects
Remoterowtable. These three are discussed in turn
Table only ever contains a single row
first conflict resolution example
Two-table database is as follows
168
@lostname value is the value that was overridden by
Conflict-causing Update
After the procedure is run, the rows in the OldCustomer
Follows
Second conflict resolution example
To test the example
ConflictLog table has a single row, showing the conflict
Replaces it with the value that was previously present
It when the procedure is executed
Lost and won names
User ID of the remote user. The table is as follows
Currentremoteuser column of the temporary table #remote
Where conflict resolution is carried out by Before triggers
There are several points of note here
User ID of the remote user is stored by the Message Agent
173
Page
Columns of this table have the following meanings 175
Primary key pool
176
To replicate the primary key pool
177
Adding new customers
Testing the key pool
To test the primary key pool
179
Primary key pool summary
Spsubscription create, puborders SamS ’856’
Page
SQL Remote
Page
SQL Remote replication installation
Deploying and Synchronizing Databases
185
Deployment overview
Conflicts as they occur
Resolve update conflicts are all easy to do
Test before deployment
Changes to avoid on a running system
Page
Mixed operating systems and database extraction
Synchronizing databases
Example
To create a remote database from the reload file
Using the extraction utility
Where path is the path of the reload command file 191
Creating a database from the reload files
Before extracting a database
Using the extraction utility from Sybase Central
To extract a database for a remote user Sybase Central
Designing an efficient extraction procedure
An efficient approach to extracting many databases
Extracting groups
Limits to using the extraction utility
This setup is illustrated in the following diagram
Using the extraction utility for Adaptive Server Enterprise
Customizing the system tables
Synchronizing data over a message system
199
SQL Remote Administration
Management overview
Granting and revoking Publish permissions
Managing SQL Remote permissions
202
To create a new user as the publisher Sybase Central
To make an existing user the publisher Sybase Central
To revoke Publish permissions Sybase Central
Exec sppublisher ’SBeaulieu’ go
Granting Remote permissions
Granting and revoking Remote and Consolidate permissions
Send messages to e-mail address sbeaulieu@acme.com
To make an existing user remote Sybase Central
Following options
Use an Smtp e-mail system
Selecting a send frequency
Agent is run
Permissions to user hquser, using the file message link
Granting Consolidate permissions
Statement is executed automatically at the remote database
Assigning permissions in multi-tier installations
To revoke Remote permissions Sybase Central
Permission from user SBeaulieu
Publish
Working with message types
Using message types
Using Sybase Central to work with message types
To add a message type Sybase Central
To alter a message type Sybase Central
Create Remote Message Type type-nameADDRESS address-string
Using commands to work with message types
To drop a message type Sybase Central
To create a message type SQL
213
To alter a message type SQL
To drop a message type SQL
Create Remote Message Type statement on
To set a message control parameter Adaptive Server Anywhere
Setting message type control parameters
By using the file message system
file message system
215
Ftp message system
Troubleshooting ftp problems
Smtp message system
Mote messages
218
SQL Remote Administration
Mapi message system
Sharing SMTP/POP addresses
Supported operating systems on
VIM message system
VIM message control parameters
Enterprise works on
Running the Message Agent
Message Agent batch and continuous modes
Names are ssremote and dbremote, respectively
Connections used by the Message Agent
Replication system recovery procedures
To run the Message Agent in continuous mode
To run the Message Agent in batch mode
Management on
Ensuring consistent Message Agent settings
See the sections Transaction log and backup management on
Adaptive Server Enterprise transaction log and backup
Message Agent and replication security
Troubleshooting errors at remote sites
For more information, see The Message Agent on
Execute the following command against the remote database
To configure a consolidated site to receive log information
Use either the -roor the -rtMessage Agent option
Tuning throughput by controlling Message Agent threading
Tuning Message Agent performance
Tuning throughput by caching messages
Polling interval
Tuning incoming message polling
Requesting resends
Example
231
Tuning the message sending process
Resending messages
To those when tuning the incoming-message polling frequency
Your choices dictate how often updates are sent to
When a remote user requests that a message be
Dbremote -ru 1h
Encoding scheme
Encoding and compressing messages
Creating custom encoding schemes
Message tracking system
Status information in the remoteuser table
Tracking messages by transaction log offsets
Transaction log
Agent -loption to change this setting
Are offsets in the local database transaction log,
Cannot be a later offset than logsent
Its resendcount
Handling of lost or corrupt messages
Page
241
Administering SQL Remote for Adaptive Server Anywhere
Starting the Message Agent
Running the Message Agent as a service
DBA authority grants them no extra permissions
Full DBA permissions from the Message Agent When connecting
Full DBA permissions on the database
Suggested practice is to grant Remote DBA authority at
Page
Agent output
Error reporting and handling
Default error handling
Ignoring errors
246
Implementing error handling procedures
Example e-mailing notification of errors
Following stored procedure implements this notification
Commit Work
Columns have the following meaning 247
248
Here is a sample insert into the table from the above error
Setting the transaction log directory
Transaction log and backup management
Backup utility options
Using the live directory as the transaction log directory
Such a directory is kept in proper shape
Using the backup directory as the transaction log directory
Following command line
252
Managing old transaction logs
Recovery with a single transaction log
To recover the database
254
Recovery with multiple transaction logs
To recover from media failure on the C drive
Backup the mirrored transaction log d\mirdir\consol.mlg
Start the database using the following command line
Make a copy of the database and log file
Backups daily using the following command
Command line would be
Backup the mirrored transaction log d\mirdir\cons.mlg
Backup procedures at remote databases
Apply the renamed transaction logs in order, as follows
Restart your system as normal
258
Upgrading consolidated databases
To unload and reload a consolidated database manual
Using passthrough mode
Uses and limitations of passthrough mode
However, the following dynamic SQL statement is replicated
Operations not replicated in passthrough mode
On a running SQL Remote setup
Procedure on the replicate side has the correct effect
263
Administering SQL Remote for Adaptive Server Enterprise
How the Message Agent for Adaptive Server Enterprise works
Scanning the transaction log
Message Agent on
Stable queue
Administering SQL Remote for Adaptive Server Enterprise
266
Message Agent operation phases
267
TransactionStable Logqueue Message Agent
268
Running multiple Message Agents
For setup instructions, see Setting Up SQL Remote on
To execute
Agent output
Protecting against media failure on the transaction log
Transaction log management
Stable queue recovery issues
274
With the following command
Truncation point can be reset with the following command
Freed by Dump Transaction
Making schema changes
Schema modifications
277
Using SQL Remote with Replication Server
When you need to use the SQL Remote Open Server
How the pieces fit together
Architecture for Replication Server/SQL Remote installations
Message system Stable Queue Agent
On Windows operating systems, the SQL Remote Open Server is
Information to retrieve it when it starts
Remote Open Server on
SQL Remote Open Server is the following executable
Setting up SQL Remote Open Server
Same regardless of previous installations
Add the SQL Remote Open Server to the setup This stage is
To set up the SQL Remote Open Server
Page
Create replication definitions for SQL Remote data
Configuring Replication Server
Set the dsixactgroupsize parameter
Set the dsinumthreads parameter
Suspend and restart the connection
Other issues
288
This part presents reference material for SQL Remote
Page
291
Utilities and Options Reference
Message Agent
Tracking system to ensure message delivery
Dbremote ssremote options directory
Utilities and Options Reference
Replication security on
Listing, see Connections used by the Message Agent on
295
Languagename,charsetname,sortorder
For more information, see Running multiple Message Agents on
Page
Dbremote -rd 30s
Page
NetWare
Registry, at the following location
You should create a file named dbremote.ini
Windows
Extracting a remote database in Sybase Central
Database Extraction utility
303
Extraction utility
304
Remote Adaptive Server Anywhere database
Extraction utility options
Utilities and Options Reference
Optional Database name. If this parameter is not sup
309
Page
Input
SQL Remote Open Server
Server Enterprise and Adaptive Server Anywhere databases
Name of the executable is as follows
Default value for the open server name is SSQueue
Gain access to the SQL Remote system tables
Values default to the -cvalues
Page
SQL Remote options
Page
Yy yyyy mm mmm dd
Hh nn mm Ss.s
318
Relationships on
SQL Remote event-hook procedures
Sphookdbremotebegin and sphookssrmtbegin
Sphookdbremoteend and sphookssrmtend
Sphookdbremoteshutdown and sphookssrmtshutdown
Sphookdbremotereceivebegin and sphookssrmtreceivebegin
Sphookdbremotereceiveend and sphookssrmtreceiveend
Sphookdbremotemessagemissing and sphookssrmtmessagemissing
Sphookdbremotesendbegin and sphookssrmtsendbegin
Sphookdbremotesendend and sphookssrmtsendend
Sphookdbremotemessagesent and sphookssrmtmessagesent
323
Has applied a set of messages from a user
Page
325
System Objects for Adaptive Server Anywhere
SQL Remote system tables
Sysarticle table
Each row describes an article in a SQL Remote publication
Sysarticlecol table
It is in, and the publication it is part
327
Each row describes a SQL Remote publication
Syspublication table
Sysremoteoption table
Sysremoteoptiontype table
329
Sysremotetype table
Sysremoteuser table
Publisher address
Consolidate
330
Syssubscription table
Remote permissions to one publication
331
332
Syspublications view
SQL Remote system views
Sysarticles view
Sysarticlecols view
Sysremoteusers view
Sysremoteoptions view
Syssubscriptions view
Each row lists information about a subscription
335
336
337
System Objects for Adaptive Server Enterprise
Table has a single row
#remote table
Srarticle table
Manage SQL Remote information
339
Srarticlecol table
Srmarker table
Databases in the same session
Each row describes a replication option used by SQL Remote
Srobject table
Sroption table
Srpassthrough table
Srpublication table
Srpublisher table
Srremoteoption table
342
Srremoteoptiontype table
Srremotetable table
Srremotetype table
343
Srremoteuser table
Received
344
345
Srsubscription table
Srarticles view
Srarticlecols view
Srpublications view
Srremoteoptions view
Srremotetables view
Srremotetypes view
348
Srremoteusers view
349
Srsubscriptions view
350
Stable Queue tables
Srqueuestate table
Stable queue
351
Srtransaction table
352
Srconfirmedtransaction table
Srqueuecoordinate table
Each row marks the corresponding row in srtransaction
353
Command Reference for Adaptive Server Anywhere
354
Automatic commit
Alter Remote Message Type statement
Been created
Must have DBA authority
Create Publication statement
Create Publication statement ASA SQL Reference,
Subscribe by expression
Create Remote Message Type message-system
Create Remote Message Type statement
Messages from a database
Create Remote Message Type statement SQL Remote ASA SQL
Create Subscription statement SQL Remote ASA SQL Reference
Create Subscription statement
Create Trigger statement
Create Trigger statement SQL Remote ASA SQL Reference
Update statement on
Must have Resource authority and have Alter permissions on
Table and thus requires exclusive use of the table
Drop Publication statement ASA SQL Reference,
Drop Publication statement
Drop Remote Message Type message-system
Drop Remote Message Type statement
Granted Remote or Consolidate permissions with this type
Drop Remote Message Type statement SQL Remote ASA SQL
Drop Subscription statement SQL Remote ASA SQL Reference
Drop Subscription statement
Send Every AT ’hhmm ss’
Grant Consolidate statement
Current database
Grant Consolidate statement SQL Remote ASA SQL Reference
Grant Publish statement
Grant Remote statement
Grant Remote DBA statement SQL Remote ASA SQL Reference
Identified by password
Grant Remote DBA statement
Connected from the Message Agent
Passthrough statement SQL Remote ASA SQL Reference,
Passthrough mode
Sppassthrough procedure on
Passthrough statement
No automatic commit is done by this statement
Remote Reset statement
Remote Reset statement SQL Remote ASA SQL Reference,
Subscriptions for a remote user in a single transaction
Automatic commit. Drops all subscriptions for the user
Sprevokeconsolidate procedure on
Revoke Consolidate statement
SQL Remote messages from this database
Revoke Publish from userid
Revoke Publish statement
Current publisher
Revoke Publish statement SQL Remote ASA SQL Reference
Revoke Remote statement SQL Remote ASA SQL Reference
Sprevokeremote procedure on
Revoke Remote statement
Messages from this database
Revoke Remote DBA statement SQL Remote ASA SQL Reference
Revoke Remote DBA statement
Splinkoption procedure on
SET Remote Option statement
Message link
Start Subscription
Start Subscription statement
Stop Subscription
Stop Subscription statement
Synchronize Subscription
Synchronize Subscription statement
Update statement
Update statement SQL Remote ASA SQL Reference,
Create Trigger statement on
379
Command Reference for Adaptive Server Enterprise
380
Spaddarticle procedure
Making schema changes on
SalesRepData
382
Spaddarticlecol procedure
To add a column to an article in a publication
Spaddarticlecol publicationname
To mark a table for SQL Remote replication
Spaddremotetable procedure
385
Default conflict resolution
Remote rows are stored in tables named oldCustomer
RemoteCustomer, respectively
Spcreatepublication publicationname
Spcreatepublication procedure
Spdroppublication procedure on
To create a publication
Spdroppublication publicationname
Spdroppublication procedure
Spcreatepublication procedure on
To drop a publication from the database
Spdropremotetype typename
Spdropremotetype procedure
Spdropsqlremote procedure
Spqueuedrop procedure on
Procedure on
Databases acting as remote databases
Spgrantconsolidate procedure
See also Description Example
392
Spgrantremote procedure
Specified
Current database must be granted Remote permissions using
Single quotes
One of the publications in the current database
395
Splinkoption procedure
SET Remote Option statement on
Databases
Smtp message system on
file message system on
Ftp message system on
Mapi message system on
To change the description of an article in a procedure
Spmodifyarticle procedure
Subscription expression
Expression that is the repkey column
399
Managing conflicts on
Spmodifyremotetable procedure
Spaddremotetable procedure on
Spremoveremotetable procedure on
401
Sppassthrough procedure
Sppassthroughpiece procedure
To build a long SQL statement for passthrough
Sppassthroughpiece string
404
Currently being built
Sppassthroughstop procedure
Resents passthrough mode
Sppassthroughstop procedure resents the list of recipients
Sppassthroughsubscription procedure
Statements
Sppassthroughsubscription publicationname
Sppassthroughuser username
Sppassthroughuser procedure
Sppopulatesqlanywhere
Sppopulatesqlanywhere procedure
Consolidated database
Called directly
Sppublisher username
Sppublisher procedure
Log was scanned
Spqueueclean procedure
Spqueueclean
Be called directly
Spqueueconfirmeddeleteold
Spqueueconfirmeddeleteold procedure
Spqueueconfirmedtransaction procedure
Match this offset
Spqueueconfirmedtransaction offset
Spqueuedeleteold procedure
Been confirmed by all remote databases
Spqueuedeleteold
Spdropsqlremote procedure on
Spqueuedrop procedure
Spqueuedumpdatabase procedure
Spqueuedumptransaction procedure on
Stable queue recovery issues on
Spqueuedumptransaction procedure
Spqueuedumpdatabase procedure on
Spqueuedumptransaction
Spqueuegetstate procedure
Queue
Spqueuegetstate
Spqueuelogtransferreset procedure
Be called directly. It resets the page and row IDs to zero
Spqueuelogtransferreset
Spqueueread procedure
Use by the Message Agent
Spqueueread startoffset
Spqueuereset procedure
Ready for a new SQL Remote setup
Spqueuereset
Spqueuesetconfirm procedure
Users in the srqueuestate table
Spqueuesetconfirm confirmoffset
Spqueuesetprogress pageid
Spqueuesetprogress procedure
Spqueuetransaction offset
Spqueuetransaction procedure
Spremote procedure
Message tracking information in the srremoteuser table
Spremote operation
To set a SQL Remote option
Spremoteoption procedure
426
Spremotetype procedure
Spdropremotetype procedure on
Alter Remote Message Type statement on
Spremovearticle publicationname
Spremovearticle procedure
Spaddarticle procedure on
To remove an article from a publication
Spremovearticlecol procedure
To remove a column from an article in a publication
Spremovearticlecol publicationname
Spremoveremotetable tablename
Spremoveremotetable procedure
Spmodifyremotetable procedure on
To mark a table as unavailable for SQL Remote replication
Sprevokeconsolidate procedure
Spgrantconsolidate procedure on
Sprevokeconsolidate username
Sprevokeremote username
Sprevokeremote procedure
Spsubscription procedure
Srsubscription tables to zero or Null
Spsubscriptionreset procedure
To reset all SQL Remote information for all remote users
Spsubscriptionreset
Appendices
Page
437
Types of difference
Differences in functionality
Differences in approach
441
Limitations for Enterprise to Enterprise replication
Page
Page
445
Supported Platforms and Message Links
Supported message systems
Windows NT/2000/XP All message links
Supported operating systems
448
Index
Symbols
450
Index
Current Remote User
451
Sqlremote
452
453
LTM
454
455
Subscribebyremote
456
Remote
457
458
459
Send Every
460
461
462
Tempdb
463
464
465
466
Unix
467
