Unsupported Transact-SQL Statements (Windows Azure SQL Database)
Microsoft Windows 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 Windows 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 |
|
Important |
|---|
| For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online. |
See Also
Important