This stored procedure configures and administers messaging-related information.
sp_msgadmin
sp_msgadmin ‘help’, sp_msgadmin ‘help’, ‘list’ sp_msgadmin ‘help’, ‘register' sp_msgadmin ‘help’, ‘default’ sp_msgadmin ‘help’, ‘remove’ sp_msgadmin 'list', 'provider' [, provider_name] sp_msgadmin 'list’, ’login’ [, provider_name, [login_name], sp_msgadmin 'list', 'subscription' [, subscription_name] sp_msgadmin 'register', 'provider', provider_name, provider_class, messaging_provider_URL sp_msgadmin 'register', 'login', provider_name, local_login, provider_login, provider_password [, role_name] sp_msgadmin 'register’, 'subscription', subscription_name, endpoint [, selector [, delivery_option [, durable_name, client_id]]] sp_msgadmin 'default’, 'login', provider_name, provider_login, provider_password sp_msgadmin 'remove', ’provider', provider_name sp_msgadmin 'remove', 'login', provider_name, local_login [, role] sp_msgadmin 'remove', 'subscription', subscription_name
sp_msgadmin ’register’,’provider’,’one_jms_provider’, ’TIBCO_JMS’,’tcp://my_jms_host:7222’ sp_msgadmin ’default’, ’login’, ’one_jms_provider’, ’loginsa’, ’abcdef123456’
sp_msgadmin cannot be used inside a transaction.
The permissions required depend on the subcommand.
Copyright © 2004. Sybase Inc. All rights reserved. |
![]() |