Experts Please Help

Dear All,
I am trying to implement FULL TEXT service on my table but for some reason
its not working. What i want to achieve is that I should be able search text
in my word documents also
Here is the Structure of my table:
ItemID int (Primary Key)
ModuleID int,
CreatedByUser nvarchar(100),
CreatedDate datetime,
FileFriendlyName nvarchar(250),
FileNameUrl nvarchar(150),' The path o fthe file
Content image(16),
ContentType nvarchar(50) ' it has all the file extensions
ContentSize int
I am creating Full TEXT index using Enterprise Manager. Below are the steps
I am following:
1) I right click my table which is called Documents
2)I select the unique index
3) I check the columns CreatedByUser ,CreatedDate ,FileNameUrl
,FriendlyFileName,ContentSize when it comes to Content column I also add
ContentType column in the Main Document Column a new catalog and give it a
name
5) I skip Select or Create Population Schedules
6) I click finish
7) Again I go back to my table and right click it and select Start Full
Population.
8) The Full population Starts and stops
9) I go to Full-text Catalogs and and see the name of my Catalog with its
status idle.
10) Full Text indexing is finished.
Now I am using ASPX.Net web Form I Have a Text Box and a search button . I
have a Doc file called MyWork.doc in the database. When I type MyWork in the
text box it returns the MyWork file.Thats fine with me. But The problem is
that I cant search content in MyWork. In MyWork.doc I have a sentence called
"My
Name is Sunil". When I type the word Sunil in the text box its not
returning any Document
Can some 1 tell me where is the problem. I am using SQL Server Developer
Edition.
Below is my Query.
SELECT
FileFriendlyName,FileNameUrl,CreatedDate,Content,C ontentType,CreatedByUser,ItemID FROM rb_Documents WHERE FREETEXT(*,'Sunil')
I am really sruggling Any help would be greatly appreciated.
cheers,
Sunil Sabir
what do you get if you issue this query?
sp_help_fulltext_catalogs --obtaain the name of your full text catalog
select FULLTEXTCATALOGPROPERTY ( 'test', 'uniquekeycount' )--replace test
with the name of your full text catalog.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sunil Sabir" <SunilSabir@.discussions.microsoft.com> wrote in message
news:2874536E-011C-4F35-8B10-04695CF67E4A@.microsoft.com...
> Dear All,
> I am trying to implement FULL TEXT service on my table but for some reason
> its not working. What i want to achieve is that I should be able search
text
> in my word documents also
> Here is the Structure of my table:
> ItemID int (Primary Key)
> ModuleID int,
> CreatedByUser nvarchar(100),
> CreatedDate datetime,
> FileFriendlyName nvarchar(250),
> FileNameUrl nvarchar(150),' The path o fthe file
> Content image(16),
> ContentType nvarchar(50) ' it has all the file extensions
> ContentSize int
> I am creating Full TEXT index using Enterprise Manager. Below are the
steps
> I am following:
> 1) I right click my table which is called Documents
> 2)I select the unique index
> 3) I check the columns CreatedByUser ,CreatedDate ,FileNameUrl
> ,FriendlyFileName,ContentSize when it comes to Content column I also add
> ContentType column in the Main Document Column a new catalog and give it a
> name
> 5) I skip Select or Create Population Schedules
> 6) I click finish
> 7) Again I go back to my table and right click it and select Start Full
> Population.
> 8) The Full population Starts and stops
> 9) I go to Full-text Catalogs and and see the name of my Catalog with its
> status idle.
> 10) Full Text indexing is finished.
> Now I am using ASPX.Net web Form I Have a Text Box and a search button . I
> have a Doc file called MyWork.doc in the database. When I type MyWork in
the
> text box it returns the MyWork file.Thats fine with me. But The problem is
> that I cant search content in MyWork. In MyWork.doc I have a sentence
called
> "My
> Name is Sunil". When I type the word Sunil in the text box its not
> returning any Document
> Can some 1 tell me where is the problem. I am using SQL Server Developer
> Edition.
> Below is my Query.
> SELECT
>
FileFriendlyName,FileNameUrl,CreatedDate,Content,C ontentType,CreatedByUser,I
temID FROM rb_Documents WHERE FREETEXT(*,'Sunil')
> I am really sruggling Any help would be greatly appreciated.
> cheers,
> Sunil Sabir
>
>
|||Dear Hilary,
Thanks for your reply. when i issue
"Hilary Cotter" wrote:

> what do you get if you issue this query? when i issue this command select FULLTEXTCATALOGPROPERTY ( 'test', 'uniquekeycount' ). I get the following results
(No Column Name)
46
Sorry I dont know what this means. Please kindly help me.
cheers,
Sunil Sabir
> sp_help_fulltext_catalogs --obtaain the name of your full text catalog
> select FULLTEXTCATALOGPROPERTY ( 'test', 'uniquekeycount' )--replace test
> with the name of your full text catalog.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Sunil Sabir" <SunilSabir@.discussions.microsoft.com> wrote in message
> news:2874536E-011C-4F35-8B10-04695CF67E4A@.microsoft.com...
> text
> steps
> the
> called
> FileFriendlyName,FileNameUrl,CreatedDate,Content,C ontentType,CreatedByUser,I
> temID FROM rb_Documents WHERE FREETEXT(*,'Sunil')
>
>