MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips

Welcome to MSSQLTips Sign in | Join | Help

MSSQLTips » SQL Server » SQL Server 2005 » full-text configuration in SQL 2005

full-text configuration in SQL 2005

Last post 07-03-2008 10:01 AM by grobido. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

06-19-2008 12:06 PM

pws
Joined on 06-10-2008
Posts 5

full-text configuration in SQL 2005

Reply Contact

I'd like to run a query against an XML column in my table using full-text search. Can someone shed some light as to the steps to configure an XML index and perform the query?

Thanks!!!

07-03-2008 10:01 AM In reply to

grobido
Joined on 10-11-2007
Wilton, NH
Posts 66

Re: full-text configuration in SQL 2005

Reply Contact

Do you want to create an XML index or create a full text index on the XML column? These are two different things.

If you want to create a full text index on the XML column just create the full text index as normal and select this column as part of your search.

Take a look at this tip:

http://www.mssqltips.com/tip.asp?tip=1332

Take a look at this post too:

http://ewbi.blogs.com/develops/2007/05/sql_server_2005.html

Page 1 of 1 (2 items)