SATıŞ: 1-800-867-1389
EN
Bu içerik dilinizde bulunmamaktadır ancak İngilizce sürümüne buradan bakabilirsiniz.

Unsupported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

The following SQL Server Transact-SQL statements are not supported in Microsoft Azure SQL Database.

ImportantImportant
For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

 

$PARTITION

CREATE/ALTER/DROP RESOURCE POOL

fn_syscollector_get_execution_details

RESTORE HEADERONLY

ADD SIGNATURE

CREATE/ALTER/DROP ROUTE

fn_syscollector_get_execution_stats

RESTORE LABELONLY

ALTER RESOURCE GOVERNOR

CREATE/ALTER/DROP SERVER AUDIT

fn_trace_geteventinfo

RESTORE MASTER KEY

ALTER SERVICE MASTER KEY

CREATE/ALTER/DROP SERVER AUDIT SPECIFICATION

fn_trace_getinfo

RESTORE REWINDONLY

ASSEMBLYPROPERTY

CREATE/ALTER/DROP SERVICE

fn_trace_gettable

RESTORE SERVICE MASTER KEY

ASYMKEY_ID

CREATE/ALTER/DROP SYMMETRIC KEY

fn_virtualfilestats

RESTORE VERIFYONLY

ASYMKEYPROPERTY

CREATE/ALTER/DROP WORKLOAD GROUP

fn_virtualservernodes

SELECT INTO Clause

BACKUP

CREATE/ALTER/DROP XML SCHEMA COLLECTION

FREETEXT

SEND

BACKUP CERTIFICATE

CREATE/DROP RULE

FREETEXTTABLE

SET ANSI_DEFAULTS

BACKUP MASTER KEY

CREATE/DROP XML INDEX

FULLTEXTCATALOGPROPERTY

SET ANSI_NULLS

BACKUP SERVICE MASTER KEY

DATABASEPROPERTY

FULLTEXTSERVICEPROPERTY

SET CONCAT_NULL_YIELDS_NULL

BEGIN CONVERSATION TIMER

DBCC CHECKALLOC

GET CONVERSATION GROUP

SET ANSI PADDING_OFF

BEGIN DIALOG CONVERSATION

DBCC CHECKCATALOG

GET_FILESTREAM_TRANSACTION_CONTEXT

SET CONTEXT_INFO

BEGIN DISTRIBUTED TRANSACTION

DBCC CHECKCONSTRAINTS

GET_TRANSMISSION_STATUS

SET DISABLE_DEF_CNST_CHK

BULK INSERT

DBCC CHECKDB

GRANT/REVOKE/DENY ALL

SET OFFSETS

cdc.fn_cdc_get_all_changes_<capture_instance>

DBCC CHECKFILEGROUP

GRANT/REVOKE/DENY ALL PRIVILEGES

SET REMOTE_PROC_TRANSACTIONS

cdc.fn_cdc_get_net_changes_<capture_instance>

DBCC CHECKIDENT

GRANT/REVOKE/DENY Assembly Permissions

SETUSER

CERT_ID

DBCC CHECKTABLE

GRANT/REVOKE/DENY Asymmetric Key Permissions

SHUTDOWN

CERTPROPERTY

DBCC CLEANTABLE

GRANT/REVOKE/DENY Certificate Permissions

SIGNBYASYMKEY

CHANGE_TRACKING_CURRENT_VERSION

DBCC DBREINDEX

GRANT/REVOKE/DENY Endpoint Permissions

SIGNBYCERT

CHANGE_TRACKING_IS_COLUMN_IN_MASK

DBCC dllname (FREE)

GRANT/REVOKE/DENY Full-text Catalog Permissions

snapshots.fn_trace_getdata

CHANGE_TRACKING_MIN_VALID_VERSION

DBCC DROPCLEANBUFFERS

GRANT/REVOKE/DENY Server Permissions

SYMKEYPROPERTY

CHANGETABLE

DBCC FREEPROCCACHE

GRANT/REVOKE/DENY Server Principal Permissions

sys.fn_all_changes_<capture_instance>

CHECKPOINT

DBCC FREESESSIONCACHE

GRANT/REVOKE/DENY Service Broker Permissions

sys.fn_builtin_permissions

CLOSE MASTER KEY

DBCC FREESYSTEMCACHE

GRANT/REVOKE/DENY Symmetric Key Permissions

sys.fn_cdc_decrement_lsn

CLOSE SYMMETRIC KEY

DBCC HELP

GRANT/REVOKE/DENY System Object Permissions

sys.fn_cdc_get_column_ordinal

COMPUTE

DBCC INDEXDEFRAG

GRANT/REVOKE/DENY XML Schema Collection Permissions

sys.fn_cdc_get_max_lsn

CONNECTIONPROPERTY

DBCC INPUTBUFFER

HAS_DBACCESS

sys.fn_cdc_get_min_lsn

CONTAINS

DBCC OPENTRAN

INDEXKEY_PROPERTY

sys.fn_cdc_has_column_changed

CONTAINSTABLE

DBCC OUTPUTBUFFER

IS_OBJECTSIGNED

sys.fn_cdc_increment_lsn

CREATE/DROP AGGREGATE

DBCC PROCCACHE

KEY_GUID

sys.fn_cdc_is_bit_set

CREATE/ALTER/DROP APPLICATION ROLE

DBCC SHOWCONTIG

KEY_ID

sys.fn_cdc_map_lsn_to_time

CREATE/ALTER/DROP ASSEMBLY

DBCC SHRINKDATABASE

KEY_NAME

sys.fn_cdc_map_time_to_lsn

CREATE/ALTER/DROP ASYMMETRIC KEY

DBCC SHRINKFILE

KILL QUERY NOTIFICATION SUBSCRIPTION

sys.fn_check_object_signatures

CREATE/ALTER/DROP BROKER PRIORITY

DBCC SQLPERF

KILL STATS JOB

sys.fn_net_changes_<capture_instance>

CREATE/ALTER/DROP CERTIFICATE

DBCC TRACEOFF

LOGINPROPERTY

sys.fn_translate_permissions

CREATE/ALTER/DROP CONTRACT

DBCC TRACEON

MOVE CONVERSATION

sys.fn_validate_plan_guide

CREATE/ALTER/DROP CREDENTIAL

DBCC TRACESTATUS

NEWSEQUENTIALID

sys.fn_xe_file_target_read_file

CREATE/ALTER/DROP CRYPTOGRAPHIC PROVIDER

DBCC UPDATEUSAGE

OBJECT_DEFINITION

sys.login_token

CREATE/ALTER/DROP DATABASE AUDIT SPECIFICATION

DBCC USEROPTIONS

OPEN MASTER KEY

sys.user_token

CREATE/ALTER/DROP DATABASE ENCRYPTION KEY

DECRYPTBYASYMKEY

OPEN SYMMETRIC KEY

sys.fn_validate_plan_guide

CREATE/ALTER/DROP DEFAULT

DECRYPTBYCERT

OPENDATASOURCE

sys.fn_xe_file_target_read_file

CREATE/ALTER/DROP ENDPOINT

DECRYPTBYKEY

OPENQUERY

sys.login_token

CREATE/ALTER/DROP EVENT NOTIFICATION

DECRYPTBYKEYAUTOASYMKEY

OPENROWSET

sys.numbered_procedure_parameters

CREATE/ALTER/DROP EVENT SESSION

DECRYPTBYKEYAUTOCERT

OPENXML

sys.numbered_procedures

CREATE/ALTER/DROP FULLTEXT CATALOG

DECRYPTBYPASSPHRASE

ORIGINAL_DB_NAME

sys.user_token

CREATE/ALTER/DROP FULLTEXT INDEX

ENCRYPTBYASYMKEY

ORIGINAL_LOGIN

UPDATETEXT

CREATE/ALTER/DROP FULLTEXT STOPLIST

ENCRYPTBYCERT

PathName

VERIFYSIGNEDBYASYMKEY

CREATE/ALTER/DROP MASTER KEY

ENCRYPTBYKEY

PUBLISHINGSERVERNAME

VERIFYSIGNEDBYCERT

CREATE/ALTER/DROP MESSAGE TYPE

ENCRYPTBYPASSPHRASE

READTEXT

WITH CHANGE_TRACKING_CONTEXT

CREATE/ALTER/DROP PARTITION FUNCTION

END CONVERSATION

RECEIVE

WITH XMLNAMESPACES

CREATE/ALTER/DROP PARTITION SCHEME

EVENTDATA

RECONFIGURE

WRITETEXT

CREATE/ALTER/DROP QUEUE

fn_get_audit_file

RESTORE

XML_SCHEMA_NAMESPACE

CREATE/ALTER/DROP REMOTE SERVICE BINDING

fn_get_sql

RESTORE FILELISTONLY

See Also

Bunu faydalı buldunuz mu?
(1500 karakter kaldı)
Geri bildiriminiz için teşekkür ederiz

Topluluk İçeriği

Ekle
Show:
© 2014 Microsoft