We help IT Professionals succeed at work.

how to upload custom thesaurus xml to SQL server 2005 database on a webserver

Medium Priority
435 Views
Last Modified: 2013-11-07
Hi Experts,
i have created my own thesaurus XML file( tsENG.xml). i know on WinXP Professional its located at this path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData. so all i did was uploaded my new tsENG.xml to that folder and restarted the Full Text Search Service. everything works great as it is on localhost.

but i have my website hosted on webserver and that where my database is stored. i have full text search enabled on it and i want to use the newly created tsENG.xml.

how would i know if
1. there is already a tsENG.xml on the database on web server.
2.if not how to upload this new file i created so that Full Text Search can access it.

can someone please help me out with an example or a tutorial or link. i have checked a lot of websites  including MSDN ( i am sure i might have missed the correct one i needed LOL) they all talk about the localhost in Windows nothing about the database on a web server.

Thanks i appreciate it.

Comment
Watch Question

SQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
you own thesaurus XML file( tsENG.xml). needs to be set o theWEB\SQL server at same way as you did on your PC
 
<1. there is already a tsENG.xml on the database on web server.
 --search  the file is you can tsENG.xml :

<2.if not how to upload this new file i created so that Full Text Search can access it.
<i have my website hosted on webserver and that where my database is stored
If it is controlled by Host owner - ask them > maybe you can not do anything about it if it is not dedicated  sql server...
At least you can try

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks unfortunately my website host server does not provide it
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.