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