Data Replication with SQL Remote
PART 4. Reference
CHAPTER 18. Command Reference for Adaptive Server Enterprise
To set the publisher of the current database, or to remove the publisher..
sp_publisher [ user_name ]
Argument |
Description |
|---|---|
user_name |
The user ID to be identifies as the publisher for the database. |
Managing SQL Remote permissions.
Each database in a SQL Remote installation is identified in outgoing messages by a user ID, called the publisher. The sp_publisher procedure sets the publisher user ID associated with these outgoing messages.
Each database can have at most one publisher; if a publisher already exists, sp_publisher changes the name of the publisher.
If no user_name argument is provided, the current publisher is removed, so that the database has no publisher. Only the permission to be the publisher is removed; the user ID is not removed from the database.
The following statement identifies the user ID joe as the publisher of the current database:
sp_publisher joe go
The following statement sets the current database to have no publisher:
sp_publisher go