locked
Full-Text Search Mystery RRS feed

  • Question

  • I have a full-text search query on an XML column which works fine on our test server 2008 but not on production server 2008.

    Is there something that needs to be refreshed on production server?

    Here's the query:

    SELECT * FROM [DocumentArchive]
    WHERE (CONTAINS(DataXML, @SearchValue))
    ORDER BY [LogID] DESC


    DB Architect

    • Moved by Tom Phillips Monday, May 21, 2012 3:36 PM TSQL question (From:SQL Server Database Engine)
    Friday, May 18, 2012 5:17 PM

All replies

  • Hi Ben,

    What kind of error message have you got?

    How-to install, configure and use Full Text Search


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Monday, May 21, 2012 5:08 AM
  • There's no error message. It just fails to find the record containing the search keyword on one server, while exact same thing works on another server.

    DB Architect

    Monday, May 21, 2012 4:47 PM