Stuart Davies (6/14/2013)
I wonder what version of SQL this was tested against - running it against my Test box (2008 R2) all goes well untilINSERT 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?
Since table "IndexTable" is a clustered table and before this insert statement, we have disabled the clustered index. This prohibits us to read/write rows into the table. And hence this error message.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter