0

I've recently installed SQL Server 2008, and I've tried the full text search and now I need to use the thesaurus for synonymous but I can't find any xmq and the ftdata folder which I read should contain the xml files...thank you!!!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Lorenzo
  • 673
  • 1
  • 11
  • 25
  • Have you checked out the appropriate version (for SQL Server **2008** or newer) of [Configure and Manage Thesaurus Files for Full-Text Search](http://msdn.microsoft.com/en-us/library/ms142491.aspx) on MSDN? – marc_s Dec 02 '14 at 16:26
  • Or did you by any chance install the SQL Server 2008 **Express** edition? As far as I know, only the Express **with advanced services** version support full-text search – marc_s Dec 02 '14 at 16:27
  • i checked your link many times, and the full text search is supported, infact i created a full text index and i can query using contains and freetext – Lorenzo Dec 02 '14 at 16:29
  • infact in the link he says "The default location of the thesaurus files is: \MSSQL12.MSSQLSERVER\MSSQL\FTDATA\" in my case i don't have such folder – Lorenzo Dec 02 '14 at 16:31
  • no anything different... my path is C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL – Lorenzo Dec 02 '14 at 16:37
  • i've installed sql management studio once again but the ftdata doesn't appear – Lorenzo Dec 02 '14 at 16:57
  • even if i create the folder and put into the thesaurus it doesn't works...and i don't know why...if i do EXEC sys.sp_fulltext_load_thesaurus_file 1040 it doesn't return an error...where the f... is the thesaurus??? – Lorenzo Dec 02 '14 at 17:23
  • Is there any chance you have *multiple instances* of various versions on your system? That folder you mentioned is from a **2008 R2** version - maybe you've installed the **2008 R2 Express** without FTS support and you're trying to get a thesaurus into that non-FTS enabled instance? – marc_s Dec 02 '14 at 18:01
  • yes i installed 2008 R2 Express then i installed sql management studio, i don't understand if i should or not have that folder because when i use full text queries they works such like SELECT * FROM Libri WHERE CONTAINS(Riassunto, 'FORMSOF (INFLECTIONAL, fare)'); but where shoud i place the thesaurus xml??? when i do EXEC sys.sp_fulltext_load_thesaurus_file 1040 return success, maybe is because the database is not on my local pc? – Lorenzo Dec 03 '14 at 09:11
  • Which ***version*** of SQL Server 2008 R2 Express did you use? There are multiple versions - only the **Express With Advanced Services** version include the fulltext search support! – marc_s Dec 03 '14 at 09:40
  • i downloaded the SQL Server 2008 R2 Express with Service Pack2, BUT if there is not full text support...why am i doing full text queries? i'm asking if maybe because i'm connecting with a remote database i must locate the thesaurus not on my local path – Lorenzo Dec 03 '14 at 09:48
  • You must download one of those two files: `SQLEXPRADV_x86_ENU.exe` or `SQLEXPRADV_x64_ENU.exe` - did you do that? – marc_s Dec 03 '14 at 09:50
  • no...i downloaded the SQLEXPR_x64_ITA.exe but...i'm asking...since i'm connected with a remote database...maybe the path of the thesaurus is not the one on my local pc??? and...why i am i doing full text queries if mine version does not support???? – Lorenzo Dec 03 '14 at 10:06
  • and i repeat if i do EXEC sys.sp_fulltext_load_thesaurus_file 1040 it return success... – Lorenzo Dec 03 '14 at 10:30

1 Answers1

1

I was facing similar issue. The documentation Path didn't work. The following path worked for me. C:\SQLData\MSSQL10.MSSQLSERVER\MSSQL\FTData

Asfandyar Peerzada
  • 96
  • 5