Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Full text indexes

Author  Topic 

vishalg
Starting Member

29 Posts

Posted - 2009-07-14 : 22:13:38
Hello,

I have two columns in a table which stores blobs of text. But one column is a varchar(max) column and other is XML column. So can I setup full text catalogs on both the columns from the same table?

Also, is it better to setup full-text index on xml column or better to setup xml indexes on the xml column?

-Vishal

vishalg
Starting Member

29 Posts

Posted - 2009-07-15 : 16:25:17
No replies?? :(

I can answer if you have doubts about the question. Just to tell you, m using sql server 2005.

-Vishal
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-15 : 23:20:57
Have a look here: http://technet.microsoft.com/en-us/library/cc917695.aspx
Go to Top of Page
   

- Advertisement -