To change address of a publisher, alter its message type. You cannot change the name of an existing message type; instead, you must delete it and create a new message type with the new name.

To alter a remote message type (Sybase Central)

1. Connect to a database as a user with DBA authority.

2. In the left pane, expand the SQL Remote Users directory for a database.

3. In the right pane, click the Message Types tab.

4. In the right pane, right-click the message type you want to alter and choose Properties.

5. Update the message type properties and click OK.

To alter a remote message type (SQL)

1. Connect to a database as a user with DBA authority.

2. Make sure you have decided on a new address for the publisher under the message type.

3. Execute an ALTER REMOTE MESSAGE TYPE statement.

See also

• ALTER REMOTE MESSAGE TYPE statement [SQL Remote]
• Create message types
• Delete message types