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 |
|
OMomani
Starting Member
2 Posts |
 Posted - 2008-10-14 : 13:16:03
|
| dears,i have a table with an index constraint on one of its columns, to enhance searching the value of that column using the 'Contains' function...it is working fine, yet i get a backup from my DB to copy it on the deployment server, i restored the DB on the deployment server and still that column working fine (i.e. i mean that i still can search its value using 'Contains')once i delete the content of that table, the index constraint is rebuilt automatically, and then it is no longer working.. i cant figure out what is happening, its a nightmare!any idea??Osama Momani. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-14 : 13:18:49
|
| seems like you've not populated full text catalog. Try repopulating it and then query the table. |
 |
|
|
|
|
|
Full text specification