SQL Server
Italia (Italiano) Accedi
Home 2012 2008 R2 2008 Versioni precedenti Libreria Forum
Libreria TechNet
SQL Server
SQL Server 2005
Documentazione sul prodotto
Documentazione di SQL Server 2005
Documentazione in linea di SQL Server 2005
Guida di riferimento ai linguaggi di SQL Server
Guida di riferimento a Transact-SQL
Convenzioni della sintassi Transact-SQL (Transact-SQL)
Novità e miglioramenti di Transact-SQL (Transact-SQL)
+ (addizione) (Transact-SQL)
+ (operatore più unario) (Transact-SQL)
+ (concatenamento di stringhe) (Transact-SQL)
- (negativo) (Transact-SQL)
- (sottrazione) (Transact-SQL)
* (moltiplicazione) (Transact-SQL)
/ (divisione) (Transact-SQL)
% (modulo) (Transact-SQL)
% (carattere jolly) (Transact-SQL)
& (AND bit per bit) (Transact-SQL)
| (OR bit per bit) (Transact-SQL)
^ (OR esclusivo bit per bit) (Transact-SQL)
~ (NOT bit per bit) (Transact-SQL)
= (uguale a) (Transact-SQL)
> (maggiore di) (Transact-SQL)
< (minore di) (Transact-SQL)
>= (maggiore o uguale a) (Transact-SQL)
<= (minore o uguale a) (Transact-SQL)
<> (diverso da) (Transact-SQL)
!< (maggiore o uguale a) (Transact-SQL)
!= (diverso da) (Transact-SQL)
!> (non maggiore di) (Transact-SQL)
-- (commento) (Transact-SQL)
/*...*/ (commento) (Transact-SQL)
[ ] (carattere jolly) (Transact-SQL)
[^] (carattere jolly) (Transact-SQL)
_ (carattere jolly per corrispondenze di singoli caratteri) (Transact-SQL)
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQL)
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
ALTER APPLICATION ROLE (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)
ALTER ASYMMETRIC KEY (Transact-SQL)
ALTER AUTHORIZATION (Transact-SQL)
ALTER CERTIFICATE (Transact-SQL)
ALTER CREDENTIAL (Transact-SQL)
ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
ALTER FUNCTION (Transact-SQL)
ALTER INDEX (Transact-SQL)
ALTER LOGIN (Transact-SQL)
ALTER MASTER KEY (Transact-SQL)
ALTER MESSAGE TYPE (Transact-SQL)
ALTER PARTITION FUNCTION (Transact-SQL)
ALTER PARTITION SCHEME (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)
ALTER QUEUE (Transact-SQL)
ALTER REMOTE SERVICE BINDING (Transact-SQL)
ALTER ROLE (Transact-SQL)
ALTER ROUTE (Transact-SQL)
ALTER SCHEMA (Transact-SQL)
ALTER SERVICE (Transact-SQL)
ALTER SERVICE MASTER KEY (Transact-SQL)
ALTER SYMMETRIC KEY (Transact-SQL)
ALTER TABLE (Transact-SQL)
ALTER TRIGGER (Transact-SQL)
ALTER USER (Transact-SQL)
ALTER VIEW (Transact-SQL)
ALTER XML SCHEMA COLLECTION (Transact-SQL)
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)
AsymKey_ID (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-SQL)
BACKUP MASTER KEY (Transact-SQL)
BACKUP SERVICE MASTER KEY (Transact-SQL)
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Transact-SQL)
BEGIN DIALOG CONVERSATION (Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)
BEGIN TRANSACTION (Transact-SQL)
BETWEEN (Transact-SQL)
binary e varbinary (Transact-SQL)
BINARY_CHECKSUM
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST e CONVERT (Transact-SQL)
CATCH (TRY...CATCH) (Transact-SQL)
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
char and varchar (Transact-SQL)
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG (Transact-SQL)
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL)
CLOSE SYMMETRIC KEY (Transact-SQL)
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-SQL)
COMMIT WORK (Transact-SQL)
COMPUTE (Transact-SQL)
Costanti (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
CONTINUE (Transact-SQL)
Elementi del linguaggio per il controllo di flusso (Transact-SQL)
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
CREATE AGGREGATE (Transact-SQL)
CREATE APPLICATION ROLE (Transact-SQL)
CREATE ASSEMBLY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE CONTRACT (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
CREATE DATABASE (Transact-SQL)
CREATE DEFAULT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)
CREATE EVENT NOTIFICATION (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
CREATE FUNCTION (Transact-SQL)
CREATE INDEX (Transact-SQL)
CREATE LOGIN (Transact-SQL)
CREATE MASTER KEY (Transact-SQL)
CREATE MESSAGE TYPE (Transact-SQL)
CREATE PARTITION FUNCTION (Transact-SQL)
CREATE PARTITION SCHEME (Transact-SQL)
CREATE PROCEDURE (Transact-SQL)
CREATE QUEUE (Transact-SQL)
CREATE REMOTE SERVICE BINDING (Transact-SQL)
CREATE ROLE (Transact-SQL)
CREATE ROUTE (Transact-SQL)
CREATE RULE (Transact-SQL)
CREATE SCHEMA (Transact-SQL)
CREATE SERVICE (Transact-SQL)
CREATE STATISTICS (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE SYNONYM (Transact-SQL)
CREATE TABLE (Transact-SQL)
CREATE TRIGGER (Transact-SQL)
CREATE TYPE (Transact-SQL)
CREATE USER (Transact-SQL)
CREATE VIEW (Transact-SQL)
CREATE XML SCHEMA COLLECTION (Transact-SQL)
CURRENT_REQUEST_ID (Transact-SQL)
CURRENT_TIMESTAMP (Transact-SQL)
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursori (Transact-SQL)
DATABASEPROPERTY (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL)
Tipi di dati (Transact-SQL)
DATALENGTH (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
Tipi di dati data/ora (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal e numeric (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
DECLARE CURSOR (Transact-SQL)
DecryptByAsymKey (Transact-SQL)
DecryptByCert (Transact-SQL)
DecryptByKey (Transact-SQL)
DecryptByKeyAutoAsymKey (Transact-SQL)
DecryptByKeyAutoCert (Transact-SQL)
DecryptByPassPhrase (Transact-SQL)
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP AGGREGATE (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
DROP CERTIFICATE (Transact-SQL)
DROP CONTRACT (Transact-SQL)
DROP CREDENTIAL (Transact-SQL)
DROP DATABASE (Transact-SQL)
DROP DEFAULT (Transact-SQL)
DROP ENDPOINT (Transact-SQL)
DROP EVENT NOTIFICATION (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
DROP FUNCTION (Transact-SQL)
DROP INDEX (Transact-SQL)
DROP LOGIN (Transact-SQL)
DROP MASTER KEY (Transact-SQL)
DROP MESSAGE TYPE (Transact-SQL)
DROP PARTITION FUNCTION (Transact-SQL)
DROP PARTITION SCHEME (Transact-SQL)
DROP PROCEDURE (Transact-SQL)
DROP QUEUE (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)
DROP ROLE (Transact-SQL)
DROP ROUTE (Transact-SQL)
DROP RULE (Transact-SQL)
DROP SCHEMA (Transact-SQL)
DROP SERVICE (Transact-SQL)
DROP SIGNATURE (Transact-SQL)
DROP STATISTICS (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
DROP SYNONYM (Transact-SQL)
DROP TABLE (Transact-SQL)
DROP TRIGGER (Transact-SQL)
DROP TYPE (Transact-SQL)
DROP USER (Transact-SQL)
DROP VIEW (Transact-SQL)
DROP XML SCHEMA COLLECTION (Transact-SQL)
DUMP (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL)
ENABLE TRIGGER (Transact-SQL)
EncryptByAsymKey (Transact-SQL)
EncryptByCert (Transact-SQL)
EncryptByKey (Transact-SQL)
EncryptByPassPhrase (Transact-SQL)
END (BEGIN...END) (Transact-SQL)
END CONVERSATION (Transact-SQL)
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT e INTERSECT (Transact-SQL)
EXECUTE AS (Transact-SQL)
Clausola EXECUTE AS (Transact-SQL)
EXECUTE (Transact-SQL)
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Espressioni (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQL)
FILEPROPERTY (Transact-SQL)
float e real (Transact-SQL)
FLOOR (Transact-SQL)
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQL)
fn_listextendedproperty (Transact-SQL)
fn_my_permissions (Transact-SQL)
fn_servershareddrives (Transact-SQL)
fn_trace_geteventinfo (Transact-SQL)
fn_trace_getfilterinfo (Transact-SQL)
fn_trace_getinfo (Transact-SQL)
fn_trace_gettable (Transact-SQL)
fn_virtualfilestats (Transact-SQL)
fn_virtualservernodes (Transact-SQL)
Clausola FOR (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
Funzioni (Transact-SQL)
GET CONVERSATION GROUP (Transact-SQL)
GET_TRANSMISSION_STATUS (Transact-SQL)
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
Has_Perms_By_Name (Transact-SQL)
HashBytes (Transact-SQL)
HAVING (Transact-SQL)
Hint (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (funzione) (Transact-SQL)
IDENTITY (proprietà) (Transact-SQL)
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQL)
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint e tinyint (Transact-SQL)
Clausola INTO (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL)
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOAD (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money e smallmoney (Transact-SQL)
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQL)
NCHAR (Transact-SQL)
nchar e nvarchar (Transact-SQL)
NEWID (Transact-SQL)
NEWSEQUENTIALID()
NOT (Transact-SQL)
ntext, text e image (Transact-SQL)
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQL)
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-SQL)
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-SQL)
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operatori (Transact-SQL)
Clausola OPTION (Transact-SQL)
OR (Transact-SQL)
Clausola ORDER BY (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)
Clausola OUTPUT (Transact-SQL)
Clausola OVER (Transact-SQL)
PARSENAME (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicato (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR (Transact-SQL)
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Parole chiave riservate (Transact-SQL)
Istruzioni RESTORE per il ripristino, il recupero e la gestione dei backup
RESTORE MASTER KEY (Transact-SQL)
RESTORE SERVICE MASTER KEY (Transact-SQL)
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact-SQL)
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
ROW_NUMBER (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL)
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Condizione di ricerca (Transact-SQL)
SELECT @local_variable (Transact-SQL)
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact-SQL)
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact-SQL)
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
Stored procedure di sistema (Transact-SQL)
Tabelle di sistema (Transact-SQL)
Viste di sistema (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL)
sys.fn_translate_permissions (Transact-SQL)
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
TAN (Transact-SQL)
TERTIARY_WEIGHTS
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
timestamp (Transact-SQL)
tinyint (Transact-SQL)
TOP (Transact-SQL)
Flag di traccia (Transact-SQL)
Transazioni (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL)
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQL)
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-SQL)
VerifySignedByAsmKey (Transact-SQL)
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression (Transact-SQL)
WITH XMLNAMESPACES (Transact-SQL)
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact-SQL)
YEAR (Transact-SQL)
Espandi Riduci a icona
Questo argomento non è stato ancora valutato - Valuta questo argomento

DROP MESSAGE TYPE (Transact-SQL)

SQL Server 2005

Elimina un tipo di messaggio esistente.

Copia 

DROP MESSAGE TYPE message_type_name
[ ; ]
message_type_name

Nome del tipo di messaggio da eliminare. Non è possibile specificare i nomi del server, del database e dello schema.

Non è possibile eliminare un tipo di messaggio in caso di contratti che vi fanno riferimento.

L'autorizzazione per eliminare un tipo di messaggio viene assegnata per impostazione predefinita al proprietario del tipo di messaggio, ai membri dei ruoli predefiniti del database db_ddladmin o db_owner e ai membri del ruolo predefinito del server sysadmin.

A. Eliminazione di un tipo di messaggio

In questo esempio il tipo di messaggio //Adventure-Works.com/Expenses/SubmitExpense viene eliminato dal database.

Copia 
DROP MESSAGE TYPE [//Adventure-Works.com/Expenses/SubmitExpense] ;
Il documento è risultato utile?
(1500 caratteri rimanenti)

Aggiunte alla community

AGGIUNGI
Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di MSDN. Se si sceglie di partecipare, quando si lascia il sito Web di MSDN verrà visualizzato il sondaggio in linea.

Si desidera partecipare?
Informativa sulla privacy
© 2013 Microsoft
|
Commenti e suggerimenti sul sito
© 2013 Microsoft. Tutti i diritti riservati.