September 17, 2003 at 12:10 pm
Trying to use full-text seach for the first time, pretty sure I have the SQL correct but I get the error: Search on full-text catalog 'catalog' for database ID 20, table ID 994102582 with search condition 'word' failed with unknown result (1966f970).
Heres my SQL:
SELECT q.question, q.answer
FROM table AS q
INNER JOIN CONTAINSTABLE (table, column, 'word',2) AS k
ON k. = q.rowid
Thanks for any help!
Edited by - rocker333 on 09/17/2003 12:13:21 PM
Edited by - rocker333 on 09/17/2003 12:14:42 PM
A.S.
MCSE, ASE, DBA
Webmaster
Applications Developer
September 17, 2003 at 6:39 pm
Try:
'"word"'
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply