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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 creating a fultext catalog

Author  Topic 

rohans
Posting Yak Master

194 Posts

Posted - 2004-10-13 : 11:58:09
Hello,
I am not seeing the create nfull-text catalog when i right-click on my database. What would cause this.

All help appreciated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-13 : 13:21:38
Did you install it?

Tara
Go to Top of Page

rohans
Posting Yak Master

194 Posts

Posted - 2004-10-13 : 16:04:21
I cannot remember it asking me when I was installing it. If I didn't how may I add it?

All help appreciated.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-13 : 16:07:47
Rerun setup.

Tara
Go to Top of Page

rohans
Posting Yak Master

194 Posts

Posted - 2004-10-13 : 16:36:33
That is not a nice think, I fear I loose my data. Is that the only way?

All help appreciated.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-13 : 16:44:25
When you say right click on your database, what do you mean? Right click in EM? If so, did you go to New...?

And from BOL:

quote:

The full-text search engine (Microsoft Search service) is installed by default with a typical installation of Microsoft® SQL Server™ 2000, Standard and Enterprise editions.




But that doesn't mean someone didn't uncheck this.

Tara
Go to Top of Page

rohans
Posting Yak Master

194 Posts

Posted - 2004-10-13 : 17:16:07
yes, in EM and I went to new and I don't see that option . But I see it in another DB on another server so i think is the setup that was different. Where in the setup is the option for the full-text.

All help appreciated.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-13 : 18:13:56
I believe you need to select Advanced Options, then when you get to the program list, you'll see it listed there.

Tara
Go to Top of Page
   

- Advertisement -