ALTER QUEUE |
Modifie la queue |
|---|---|
| Microsoft SQL Server |
Syntaxe
|
ALTER QUEUE object queue_settings | queue_action [ ; ] object : := { database_name.schema_name.queue_name | schema_name.queue_name | queue_name } queue_settings : := WITH [ STATUS = { ON | OFF } [ , ] ] [ RETENTION = { ON | OFF } [ , ] ] [ ACTIVATION ( { [ STATUS = { ON | OFF } [ , ] ] [ PROCEDURE_NAME = procedure [ , ] ] [ MAX_QUEUE_READERS = max_readers [ , ] ] [ EXECUTE AS { SELF | 'user_name' | OWNER } ] | DROP } ) [ , ]] [ POISON_MESSAGE_HANDLING ( STATUS = { ON | OFF } ) ] queue_action : := REBUILD [ WITH query_rebuild_options ] | REORGANIZE [ WITH (LOB_COMPACTION = { ON | OFF } ) ] | MOVE TO { file_group | "default" } procedure : := { database_name.schema_name.stored_procedure_name | schema_name.stored_procedure_name | stored_procedure_name } queue_rebuild_options : := { ( MAXDOP = max_degree_of_parallelism ) } |
Description
Cette instruction permet de changer les propriétés de la file d'attente.
Dernière mise à jour : Vendredi, le 19 Juin 2020