Full text search Folder

Question

Full text search Folder

Bobby Glover

SSCarpal Tunnel

Points: 4143
More actions
October 19, 2011 at 3:30 am

#146129

I have a server that I have never seen before. It has 2 Folders on it for FULL TEXT SEARCH. How can I tell which one SQL is currently using one is a copy of the other date stamps are very similiar.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Bobby Glover SSCarpal Tunnel Points: 4143 More actions · Answer 1

How do I see where the FULL TEXT CATALOG is for a specific db. None of the DMVs here are useful http://msdn.microsoft.com/en-us/library/ms174971.aspx

derek.colley SSCrazy Eights Points: 8040 More actions · Answer 2

If you want to use SSMS and you know where the table(s) are that are using FTIs, use the context menu (right-click) on one of the tables, go to Full Text Indexes... then Properties. You should be able to see the pathname in there.

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Bobby Glover SSCarpal Tunnel Points: 4143 More actions · Answer 3

Still no indication of where the folder is that the FTI is using.

Bobby Glover SSCarpal Tunnel Points: 4143 More actions · Answer 4

Found the solution, In the db under STORAGE find the CATALOG then right click script as will produce the folder location in the script.