SQL Azure Quick Reference - Pro SQL Azure - page 263

DECLARE @local_variable MIN_ACTIVE_ROWVERSION WITH (Common Table Exp.)

Partially Supported T-SQL
Table B-2 lists the partially supported T-SQL statements that you can use in SQL Azure. “Partially
supported” means you can use these statements, but with some variations (or limitations) to the syntax.
Examples are provided following the table.

Table B-2. Partially Supported T-SQL Statements

ALTER AUTHORIZATION CREATE PROCEDURE DROP TRIGGER

ALTER DATABASE CREATE SPATIAL INDEX DISABLE TRIGGER

ALTER FUNCTION CREATE SYNONYM ENABLE TRIGGER

ALTER INDEX CREATE TABLE EXECUTE

ALTER LOGIN CREATE TRIGGER EXECUTE AS

ALTER PROCEDURE CREATE TYPE EXECUTE AS Clause

ALTER TABLE CREATE USER GRANT Database Permissions

ALTER TRIGGER CREATE VIEW GRANT Database Principle Perm.

ALTER USER DENY Database Permissions GRANT Type Permissions

ALTER VIEW DENY Database Principle Perm. INSERT

CREATE DATABASE DENY Type Permissions REVOKE Database Permissions

CREATE FUNCTION DROP DATABASE REVOKE Database Principle Perm.

CREATE INDEX DROP INDEX REVOKE Type Permissions

CREATE LOGIN DROP TABLE USE

For example, when you're creating or altering a stored procedure in SQL Azure, the FOR REPLICATION
and ENCRYPTION options aren't supported. Thus, the following isn't valid:

CREATE PROCEDURE GetUsers
WITH ENCRYPTION
FOR REPLICATION
AS