Validating Full-Text Search CONTAINS parameter RRS feed

  • Question

  • Hi,

    I have a Stored Proc that takes a search term and searches a table using Full-Text Search.

    Is there built in API in ADO to check if the parameter im passing to a SP is a valid full text search parameter that will be places in CONTAINS portion of the SP?




    Monday, August 20, 2007 11:14 PM


  • Full Text is not part of the query engine so what you can do is limited but you can look in the Full Text subfolder in SQL Server folder in programs and look at the noise word list.  Hope this helps.


    Tuesday, August 21, 2007 1:22 PM