Tables without a clustered index are not supported in this version of SQL Server

Home / SQL Server / Tables without a clustered index are not supported in this version of SQL Server

when you published the MVC application for windows AZURE cloud and SQL Azure it’s giving below mentioned error.

Tables without a clustered index are not supported in this version of SQL Server.

 

You need to create a clustered index on all tables in SQL Azure that you wish to add rows to; otherwise the insert statement always fails.

CREATE UNIQUE CLUSTERED INDEX Idx_TableName ON TableName(yourGUIDColumn);

 

Here is a reference to the general guidelines and limitations specifically regarding these indexes: MSDN Link

Here is another article which explains the reasoning behind this: link

edgedoll.com