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 |
|
vlsivajyothi
Starting Member
1 Post |
 Posted - 2009-05-29 : 02:12:46
|
| Hello All,SQL Server2005 is installed in Windows 2003 Server(64-Bit) and updated with Sql Server SP2 and SP3. I installed FilterPack and registered with SQL server as per the steps given in the following link http://support.microsoft.com/kb/945934I'm trying to do Fulltext search on varBinary column (contains visio documents). When setting up the full-text index, I specified the type column(.vsd), in addition to picking the binary column.then I run the following full-text query. select * from visDocuments where freetext([Document],'Dell')But its not returning the rows. I'm sure one of the row is having the word Dell.Please guide me to solve this problem. Thanks in advance.Note: I followed the above steps in Windows XP(32-bit) machine, it worked fine. it returned rows. |
|
|
|
|
|
Full text query on VarBinary column