Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
calebsandfort
Starting Member
1 Post |
 Posted - 2009-03-18 : 17:08:01
|
| HiWe have a table that has a full text index on a bunch of ntext columns that are on it. For our next release we are trying to change those columns to nvarchar(max). We have a third party tool that generates our upgrade scripts. The script it generated basically drops the full text index, creates a new temp table, copies the records into the temp table, deletes the old table, renames the temp table and creates the full text index.The only problem is that after this change all full text searches on the table return no results. Every record has a rank of 0 where previously the ranking was over 500.Any idea what the problem could be or a different way to go about doing the upgrade?Thanks |
|
|
|
|
|
Nvarchar(max) is breaking full text search