We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
I have been going thru documents on Alter Fulltext Catalog Reorganize. But unlike Alter Index Reorganize, BOL(Books Online) documentation does not mention whether it's possible to run it without ...
This would save me the redundant ON MyCatalog phrase when I create full-text indices. For example, CREATE FULLTEXT INDEX ON MyTable ( MyField1, MyField2, MyField3 ) KEY INDEX PK_MyKey ON ...
I tried to create a full-text index on my new full-text catalog and got this error: Msg 9967, Level 16, State 1, Line 1 A default full-text catalog does not exist in database 'foo' or user does not ...
I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the ...