sp_msgadmin  sp_msgadmin 'list'

Chapter 4: Real Time Stored Procedures for Administration

sp_msgadmin 'help'

Description

Provides syntax information about this stored procedure or about particular parameters.

Syntax

 sp_msgadmin 'help'
 sp_msgadmin 'help', 'list'
 sp_msgadmin 'help', ’register’
 sp_msgadmin 'help', ’default’
 sp_msgadmin 'help’, ’remove’

Parameters

’list’

Lists syntax information about message providers, logins, or subscriptions.

’register’

Provides stored procedure syntax to register a message provider, login, or subscription.

’default’

Lists the syntax to specify the default login for a specified message provider.

’remove’

Lists the stored procedure syntax to remove a message provider, login, or subscription.

Examples

Example 1

Describes the syntax for sp_msgadmin ’list’:

sp_msgadmin ’help’, ’list’

Usage

See the Usage section under sp_msgadmin.

Permissions

No special permissions are required.





Copyright © 2004. Sybase Inc. All rights reserved. sp_msgadmin 'list'

View this book as PDF