sp_msgadmin 'remove'

Description

Removes the specified message provider, login, or subscription.

Syntax

 sp_msgadmin 'remove’, 'provider’, provider_name
 sp_msgadmin ’remove’, ’login’, provider_name, local_login 
       [, role_name]
 sp_msgadmin ’remove’, ’’subscription’’, subscription_name

Parameters

‘provider’

Removes a messaging provider previously defined by this call:

sp_msgadmin ’register’, ’provider’, provider_name

provider_name

The name of the messaging provider from which the specified login is removed.

‘login’

Removes the mapping previously created between an Adaptive Server login and a service provider login, defined by this call:

sp_msgadmin ’register’, ’login’, local_login,... 

local_login

The mapping to the Adaptive Server login that you are removing.

role_name

The name of the SQL role specified.

‘subscription’

Removes a subscription previously created by this call:

sp_msgadmin ’register’, ’subscription’, subscription_name, ...

subscription_name

The name of the subscription to remove.

Examples

Example 1

Removes the messaging provider “my_jms_provider”:

sp_msgadmin ’remove’, ’provider’, ’my_jms_provider’

Example 2

Removes the Adaptive Server login “ase_login1”associated with the messaging provider “my_jms_provider”:

sp_msgadmin ’remove’, ’login’, ’my_jms_provider’,’ase_login1’

Example 3

Removes the default login, indicated by a null login parameter:

sp_msgadmin ’remove’, ’login’, ’my_jms_provider’,null

Example 4

Removes all logins for role “sa_role” on “my_jms_provider”:

sp_msgadmin ’remove’, ’login’, ’my_jms_provider’,null, ’sa_role’

Example 5

Removes the subscription “subscription_1”:

sp_msgadmin ’remove’, ’subscription’, ’subscription_1’

Usage

• Removing a messaging provider does not affect messages that are in transit (that is, messages that are in the process of being sent or received) to this message provider.

• sp_msgadmin 'remove' does not affect any current connections to the message provider. This means that if a message provider, login, or default is removed while there is a current connection to the specified message provider, the connection is not affected. However, Sybase does not recommend this practice.

• See sp_msgadmin for usage common to the variants of sp_msgadmin.

• You must specify local_login as null if you specify role_name.

Permissions

You must have messaging_role and sso_role permissions to issue sp_admin 'remove'.

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF