Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enabling full-text search

Status
Not open for further replies.
ncscott

ncscott

MIS
Jan 10, 2003
36
US
When SQL 2000 was installed, full-text search was not enabled. Is there any way to enable it without reinstalling?
 
Sort by date Sort by votes
I think, although I have not tried it that you can do an update install. Use the install disk run install and when it sees the existing sql server, I believe you will get an option to add features.
 
Upvote 0 Downvote
Actually, I've solved the problem. I remembered seeing a stored procedure under the master database called "sp_fulltext_database" running this procedure on the desired database with the argument 'enable' did the trick.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Changed database from Full to simple - Maintenance plan failing
Replies
1
Views
109
SQLBill
SQLBill
TheBugSlayer
  • Locked
  • Question
Restoring from one full database backup and a whole lot of log backups 1
Replies
4
Views
122
TheBugSlayer
TheBugSlayer
denacho
  • Locked
  • Question
SQL Express 2008 database full backups & trans logs
Replies
5
Views
106
denacho
denacho
markdmac
  • Locked
  • Question
Need help replacing all instances of incorrect text 1
Replies
5
Views
103
markdmac
markdmac
NormanCastle
  • Locked
  • Question
I'm having trouble creating a full text catalog
Replies
0
Views
40
NormanCastle
NormanCastle

Part and Inventory Search

Sponsor

Back
Top