I get the following error when I try to insert a row into a SQL Azure table.
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
My problem is I do have a clustered index on that table. I used SQL Azure MW to generate the Azure SQL Script.
Here's what I'm using:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblPasswordReset]') AND type in (N'U'))DROP TABLE [dbo].[tblPasswordReset]GOSET ANSI_NULLS ONSET QUOTED_IDENTIFIER ONIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tblPasswordReset]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[tblPasswordReset]( [PasswordResetID] [int] IDENTITY(1,1) NOT NULL, [PasswordResetGUID] [uniqueidentifier] NULL, [MemberID] [int] NULL, [RequestDate] [datetime] NULL, CONSTRAINT [PK_tblPasswordReset] PRIMARY KEY CLUSTERED ( [PasswordResetID] ASC)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF))ENDGOWhy doesn't SQL Azure recognize my clustered Key? Is my script wrong?


Check Solution