• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

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

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.

0
niceoneishere
Asked:
niceoneishere
1 Solution
 
Eugene ZCommented:
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
0
 
niceoneishereAuthor Commented:
Thanks unfortunately my website host server does not provide it
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now