Full-Text Index on an xml column (Sql 2008)

Discussion in 'Databases' started by jbswo, Jul 31, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. In Sql Server 2008, I have a full-text index set up on a column of xml datatype and it does not appear that it is being populated at all. Other full-text columns are working fine, but a query of sys.dm_fts_index_keywords() shows that no information at all is being parsed from the xml column into the index.

    The same steps I'm taking on the DASP server work fine for local instances of Sql and the capability is important for my app.

    I found one link that says that the XML Filter necessary for full-text indexing was disabled by default in Sql Server 2008 RC0, but should have been enabled in the RTM edition. (http://social.msdn.microsoft.com/Forums/en-US/sqlsearch/thread/a45497d8-56c9-4494-9884-f35238c387f5).

    Could this be the problem on the DASP servers? Is there any chance of getting that enabled? Or does someone have full-text indexing working on an xml column on DASP and can point me to a step I am missing?

    Thanks...
     
  2. Did you resolve this issue?

    Hello,

    I was wondering if you ever resolved this issue? We seem to have the same problem and this is one of very few references to the issue so I believe it might be something I have done or forgotten to do :(

    TIA
    Errol
     
  3. No resolution. I didn't push it too hard or submit a ticket or anything. Sidetracked elsewhere and worked around it for now. I'm fairly convinced it is related to that XML filter and configuration on the DASP server that we cannot change but I have not had a chance to investigate further.

    Let me know if you manage to get it configured. I'd like to be able to revisit that but it's on the back-burner at this point.

    Glad to know it's not just me, whatever it is...
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page