When you modify a view in SQL 2005 Management Studio, and there's an
incorrect column name (that you typed in the SQL pane), you get a silly
error message:

Invalid column name "Categorry"
Invalid column name "Categorry"

It's so nice they named it twice!

And it's not like I had 2 errors or anything.  Strange.

David Walker

DWalker (n***@none.com) writes:
Let me guess, you have something like: 

    Categorry IN (1, 2)

SQL Server performs some transformations of the query, before it checks
for correct column names. One of these transformations is changing IN
to a bunch of OR operations. This results in double error messages.

I've seen this for other constructs as well.

Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
How do you insert a carriage return in Management Studio?
SQL Agent keeps failing
SQLCMD error -100
Can't use Profiler to get execution plan for a particular query