Error on table creation

Question

I am receiving an error that comes up with I try to create a table.  My code is...

CREATE TABLE [dbo].[VehiclePlatform](
    [vehiclePlatform_id] [uniqueidentifier]  NOT NULL,
    [descr] [varchar](50) NOT NULL,
    [year] int NOT NULL,
 CONSTRAINT [PK_VehiclePlatform] PRIMARY KEY CLUSTERED
(
    [vehiclePlatform_id] ASC
)WITH ( STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

and it is telling me that ALLOW_ROW_LOCKS is not supported in this version.  That's fine, I can just remove it, however is there an exhaustive list of supported WITH clauses, as well as a document that describes what locking the tables support?  If you can point me in the right direction that'd be great!

Thanks

Jon

Answer 1

Hello,
One place that you can take a look at is SQLAzure Migration Wizard (http://sqlazuremw.codeplex.com/)
If you download the binaries, there will be a file "NotSupportedByAzureFile.Config" - it is what it says. However if the guys who write this very useful tool got this list from somewhere - it should exist :) but I don't know where.
Anyway - this file is pretty complete list of what is not supported in SQL Azure. And since SQL Azure is still CTP, the list may change very often. That's why I guess there still isn't a public list of what is fully supported and what is not supported.

Answer 2

The TSQL documentation for SQL Azure shows that ALLOW_ROW_LOCKS is not supported. 

In general, I would use the SQL Azure documentation as a starting point, but if you find something that doesn't work but the documentation doesn't call it out, please let us know so we can file a bug.

Evan

Answer 3

Hello,
Here is a list of supported T-SQL commands:
http://msdn.microsoft.com/en-us/library/ee336270.aspx