I wonder what version of SQL this was tested against - running it against my Test box (2008 R2) all goes well until INSERT INTO [dbo].[IndexTable]
VALUES(3, 'Value3')
Then I get the error "Msg 8655, Level 16, State 1, Line 1
The query processor is unable to produce a plan because the index 'PK_IndexTable' on table or view 'IndexTable' is disabled."
Any ideas?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx