Deployment to SQL Azure....index errors...

UKRoysterUKRoyster Posts: 9
edited January 28, 2013 6:48AM in SQL Compare Previous Versions
Hi there,

I have a local sql database thati am comparing to the SQL Azure. Script is generated but when i run it in Azure i get the following issue...

Msg 40054, Level 16, State 2, Line 1
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.

Is there an option to say that it must conform to SQL Azure?

Require urgent advice if possible,


Looking for great hotel deals? Try http://lovehoteldeals.co.uk/


Sign In or Register to comment.