Contents Index sp_populate_sql_anywhere procedure sp_queue_clean procedure

SQL Remote User's Guide
  Command Reference for Adaptive Server Enterprise

sp_publisher procedure


Purpose 

To set the publisher of the current database, or to remove the publisher.

Syntax 

sp_publisher [ user_name ]

Argument Description
user_name The user ID to be identifies as the publisher for the database.
See also 

Managing SQL Remote permissions.

GRANT PUBLISH statement

Description 

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.

Examples 

Contents Index sp_populate_sql_anywhere procedure sp_queue_clean procedure