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.
| Author |
Topic |
|
kkrishna
Starting Member
23 Posts |
 Posted - 2009-06-19 : 15:07:56
|
| Hi All,I am new to the SQL Server forums and T-SQL. I installed SQL Server Express 2005 with Advanced add-in and am presently working on the T-SQL statements.While trying the full text search on the tables of the AdventureWorks database, I am normally providing the primary key as the key index. Since the rowguid column also contains unique value, can we not use it as key index? How can we find out for which tables the full text index is already created? Or check before creating full text index for column(s)of a table, whether the full text index is already existing?In some cases, such as Production.Document table, the FileName column holds a reference to the doc file for each Title. Will it be possible to automatically open the file referred by the FileName while querying for the full text search?The query is not accepting "TYPE COLUMN FileExtension" statement.Thanks in advance. |
|
|
|
|
|
Full text search ... key index