I dropped an index to change the collation of a column and now I am getting the following error message below when I try to recreate it.
Expression: CompareRow ( rightPageRow, *m_pSEBindings, keyCnt, *pHobtAccess, PAGE_LEAF_LEVEL)
Process ID: 19528
Msg 1088, Level 16, State 12, Line 1
Cannot find the object "dbo.company" because it does not exist or you do not have permissions.
The reason for the cannot find object is that the database is switched to the master database! I have recreated other indexes successfully on other columns in the same table and other tables. I ran DBCC CHECKTABLE and it reports no errors. Original collation was Latin1_General_CI_AS and I altered it to SQL_Latin1_General_CP1_CI_AS. Tried to google sobuild but got no valid hits on this type of error. There 80,000 records in this table. The datatype of the column is varchar(100) NULL. The maximum length of any name in this table is 87 characters.
I am temped to leave this column alone, but it will mean that this column will have different collation to the rest of the database.