Recently we performed some test against SQL Azure. We found that our system was throwing an exception cause SQL Azure requires a clustered index in each table (Wanna know why?).

So how can you find out what tables are causing the issue? The answer is simple, run the following query and you’ll have the list of tables to fix:

SELECT name
FROM sys.objects
WHERE type = ‘U’
AND object_id NOT IN
(SELECT object_id FROM sys.indexes WHERE index_id = 1)

Hope it helps…

Leave a Reply

Your email address will not be published. Required fields are marked *