This is just a quick post in case you run into this problem. This is an interesting error and it had a coworker worry about table corruption. This coworker connected to a database on a fairly new server, he then executed a query like the following
And here is the error message he got
Then I decided to run the same query from my machine and it all worked without a problem. From here it is pretty easy since the problem must be with the client software. And after we checked the version of SSMS we noticed that he connected to the 2008 instance with a 2005 SSMS client. He then connected with SSMS 2008 and it all worked again. What is interesting is that if you use Query Analyzer then you don’t get an error and it just works
Lesson learned…it is not the server..it is you!