Full Text Search

Question

Full Text Search

freens77

SSC-Addicted

Points: 495
More actions
January 14, 2009 at 11:18 am

#199999

Hello,
I'm new to DB programming and am currently in a LearnKey class on writing queries in SQL 2005. In order to follow along, I downloaded SQL Server 2005 and Management Studio Express, along with the AdventureWorks DB. I've gone through the class without a problem until the 5th disc (of 5), which touches on the topic of "Full Text Search". This is not installed in my version of Management Studio and I'm having a hard time figuring out how to do so.
If someone could point me in the right direction or better yet, tell me what to do, I would really appreciate it.
Thanks in advance for any help.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

It may just be your Express version of Management Studios. We had a developer here who was having problems seeing the service broker and it was because he had Express installed. He installed the full version of MS and was just fine.

By the way, the FT stuff should appear in the Storage/Full Text Catalogs folder. Can you see this folder?

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

freens77 SSC-Addicted Points: 495 More actions · Answer 2

The folder is there, John. Thanks for your feedback, I appreciate it. I'll try installing the full version of MS tonight. I hope its free as well. 🙂

freens77 SSC-Addicted Points: 495 More actions · Answer 3

Since the full version is not free, I did some more research and found a potential solution using Express, but with the Advanced Services included. I've installed that and attempted to use this:

http://www.wherecanibuyit.co.uk/ASP/full-text-search.html

as a solution. I've now encountered a different problem once I try to actually create the index (I was able to create the catalog). Here's the error message I'm getting:

Msg 7641, Level 16 State 1, Line 1

Full-Text catalog 'mycatalog' does not exist in database 'AdventureWorks' or user does not have permission to perform this action.

I've tried rebooting both the FullText Service and the Server.

Can anyone please give me any additional tips or potential solutions?

Thanks very much in advance.

freens77 SSC-Addicted Points: 495 More actions · Answer 4

Sorry, I should add that I was able to create the catalog "mycatalog"....its creating the index that I had a problem with.

That said, I copied the table from adventureworks to a new DB and everything executed succesfully. So, it seems to be a permission issue. I've tried

changing my security level in multiple ways, but had no luck in getting it to work in adventureworks.

Any tips for how to do this would be greatly appreciated.