Export (0) Print
Expand All
9 out of 14 rated this helpful - Rate this topic

Unsupported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

Microsoft Microsoft Azure SQL Database does not support all of the Transact-SQL statements that are delivered in SQL Server 2008. The following table provides a list of the Transact-SQL statements that Microsoft Azure SQL Database does not support.  

 

$PARTITION

fn_syscollector_get_execution_stats

ADD SIGNATURE

fn_trace_geteventinfo

ALTER RESOURCE GOVERNOR

fn_trace_getinfo

ALTER SERVICE MASTER KEY

fn_trace_gettable

ASSEMBLYPROPERTY

fn_virtualfilestats

ASYMKEY_ID

fn_virtualservernodes

ASYMKEYPROPERTY

FREETEXT

BACKUP

FREETEXTTABLE

BACKUP CERTIFICATE

FULLTEXTCATALOGPROPERTY

BACKUP MASTER KEY

FULLTEXTSERVICEPROPERTY

BACKUP SERVICE MASTER KEY

GET CONVERSATION GROUP

BEGIN CONVERSATION TIMER

GET_FILESTREAM_TRANSACTION_CONTEXT

BEGIN DIALOG CONVERSATION

GET_TRANSMISSION_STATUS

BEGIN DISTRIBUTED TRANSACTION

GRANT/REVOKE/DENY ALL

BULK INSERT

GRANT/REVOKE/DENY ALL PRIVILEGES

cdc.fn_cdc_get_all_changes_<capture_instance>

GRANT/REVOKE/DENY Assembly Permissions

cdc.fn_cdc_get_net_changes_<capture_instance>

GRANT/REVOKE/DENY Asymmetric Key Permissions

CERT_ID

GRANT/REVOKE/DENY Certificate Permissions

CERTPROPERTY

GRANT/REVOKE/DENY Endpoint Permissions

CHANGE_TRACKING_CURRENT_VERSION

GRANT/REVOKE/DENY Full-text Catalog Permissions

CHANGE_TRACKING_IS_COLUMN_IN_MASK

GRANT/REVOKE/DENY Server Permissions

CHANGE_TRACKING_MIN_VALID_VERSION

GRANT/REVOKE/DENY Server Principal Permissions

CHANGETABLE

GRANT/REVOKE/DENY Service Broker Permissions

CHECKPOINT

GRANT/REVOKE/DENY Symmetric Key Permissions

CLOSE MASTER KEY

GRANT/REVOKE/DENY System Object Permissions

CLOSE SYMMETRIC KEY

GRANT/REVOKE/DENY XML Schema Collection Permissions

COMPUTE

CONNECTIONPROPERTY

HAS_DBACCESS

CONTAINS

INDEXKEY_PROPERTY

CONTAINSTABLE

IS_OBJECTSIGNED

CREATE/DROP AGGREGATE

KEY_GUID

CREATE/ALTER/DROP APPLICATION ROLE

KEY_ID

CREATE/ALTER/DROP ASSEMBLY

KEY_NAME

CREATE/ALTER/DROP ASYMMETRIC KEY

CREATE/ALTER/DROP BROKER PRIORITY

KILL QUERY NOTIFICATION SUBSCRIPTION

CREATE/ALTER/DROP CERTIFICATE

KILL STATS JOB

CREATE/ALTER/DROP CONTRACT

LOGINPROPERTY

CREATE/ALTER/DROP CREDENTIAL

MOVE CONVERSATION

CREATE/ALTER/DROP CRYPTOGRAPHIC PROVIDER

NEWSEQUENTIALID

CREATE/ALTER/DROP DATABASE AUDIT SPECIFICATION

OBJECT_DEFINITION

CREATE/ALTER/DROP DATABASE ENCRYPTION KEY

OPEN MASTER KEY

CREATE/ALTER/DROP DEFAULT

OPEN SYMMETRIC KEY

CREATE/ALTER/DROP ENDPOINT

OPENDATASOURCE

CREATE/ALTER/DROP EVENT NOTIFICATION

OPENQUERY

CREATE/ALTER/DROP EVENT SESSION

OPENROWSET

CREATE/ALTER/DROP FULLTEXT CATALOG

OPENXML

CREATE/ALTER/DROP FULLTEXT INDEX

ORIGINAL_DB_NAME

CREATE/ALTER/DROP FULLTEXT STOPLIST

ORIGINAL_LOGIN

CREATE/ALTER/DROP MASTER KEY

PathName

CREATE/ALTER/DROP MESSAGE TYPE

PUBLISHINGSERVERNAME

CREATE/ALTER/DROP PARTITION FUNCTION

READTEXT

CREATE/ALTER/DROP PARTITION SCHEME

RECEIVE

CREATE/ALTER/DROP QUEUE

RECONFIGURE

CREATE/ALTER/DROP REMOTE SERVICE BINDING

RESTORE

CREATE/ALTER/DROP RESOURCE POOL

RESTORE FILELISTONLY

CREATE/ALTER/DROP ROUTE

RESTORE HEADERONLY

CREATE/ALTER/DROP SERVER AUDIT

RESTORE LABELONLY

CREATE/ALTER/DROP SERVER AUDIT SPECIFICATION

RESTORE MASTER KEY

CREATE/ALTER/DROP SERVICE

RESTORE REWINDONLY

CREATE/ALTER/DROP SYMMETRIC KEY

RESTORE SERVICE MASTER KEY

CREATE/ALTER/DROP WORKLOAD GROUP

RESTORE VERIFYONLY

CREATE/ALTER/DROP XML SCHEMA COLLECTION

SELECT INTO Clause

CREATE/DROP RULE

SEND

CREATE/DROP XML INDEX

SET ANSI_DEFAULTS

DATABASEPROPERTY

SET ANSI_NULLS

DBCC CHECKALLOC

SET CONCAT_NULL_YIELDS_NULL

DBCC CHECKCATALOG

SET ANSI PADDING_OFF

DBCC CHECKCONSTRAINTS

SET CONTEXT_INFO

DBCC CHECKDB

SET DISABLE_DEF_CNST_CHK

DBCC CHECKFILEGROUP

SET OFFSETS

DBCC CHECKIDENT

SET REMOTE_PROC_TRANSACTIONS

DBCC CHECKTABLE

SETUSER

DBCC CLEANTABLE

SHUTDOWN

DBCC DBREINDEX

SIGNBYASYMKEY

DBCC dllname

SIGNBYCERT

DBCC DROPCLEANBUFFERS

snapshots.fn_trace_getdata

DBCC FREEPROCCACHE

SYMKEYPROPERTY

DBCC FREESESSIONCACHE

sys.fn_all_changes_<capture_instance>

DBCC FREESYSTEMCACHE

sys.fn_builtin_permissions

DBCC HELP

sys.fn_cdc_decrement_lsn

DBCC INDEXDEFRAG

sys.fn_cdc_get_column_ordinal

DBCC INPUTBUFFER

sys.fn_cdc_get_max_lsn

DBCC OPENTRAN

sys.fn_cdc_get_min_lsn

DBCC OUTPUTBUFFER

sys.fn_cdc_has_column_changed

DBCC PROCCACHE

sys.fn_cdc_increment_lsn

DBCC SHOWCONTIG

sys.fn_cdc_is_bit_set

DBCC SHRINKDATABASE

sys.fn_cdc_map_lsn_to_time

DBCC SHRINKFILE

sys.fn_cdc_map_time_to_lsn

DBCC SQLPERF

sys.fn_check_object_signatures

DBCC TRACEOFF

sys.fn_net_changes_<capture_instance>

DBCC TRACEON

sys.fn_translate_permissions

DBCC TRACESTATUS

sys.fn_validate_plan_guide

DBCC UPDATEUSAGE

sys.fn_xe_file_target_read_file

DBCC USEROPTIONS

sys.login_token

DECRYPTBYASYMKEY

sys.user_token

DECRYPTBYCERT

sys.fn_validate_plan_guide

DECRYPTBYKEY

sys.fn_xe_file_target_read_file

DECRYPTBYKEYAUTOASYMKEY

sys.login_token

DECRYPTBYKEYAUTOCERT

sys.numbered_procedure_parameters

DECRYPTBYPASSPHRASE

sys.numbered_procedures

ENCRYPTBYASYMKEY

sys.user_token

ENCRYPTBYCERT

UPDATETEXT

ENCRYPTBYKEY

VERIFYSIGNEDBYASYMKEY

ENCRYPTBYPASSPHRASE

VERIFYSIGNEDBYCERT

END CONVERSATION

WITH CHANGE_TRACKING_CONTEXT

EVENTDATA

WITH XMLNAMESPACES

fn_get_audit_file

WRITETEXT

fn_get_sql

XML_SCHEMA_NAMESPACE

fn_syscollector_get_execution_details

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

See Also

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft. All rights reserved.