How is Thesaurus data configured in SQL Server 2

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How is Thesaurus data configured in SQL Server 2005 Full-Text Search?

Answer
An XML file in the file system named tsxxx.xml where xxx is a code.
Explanation
The thesaurus file for SQL Server 2005 is an XML file containing data and stored in SQL_Server_install_path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\ directory. There is one for each language and it is named tsxxx_.xml, where xxx is the three letter language code.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005, which network protocols use endpoints?
• Can you use Full-text search to index this column?
• What does the sqlwb utility do?
• You want to disable the trigger dEmployee on the HumanResources...
• Which RAID levels store parity information?
• In SQL Server 2005, which network protocols use endpoints?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• When the network service built-in account connects to a network resource, what is the context?
• What level of permissions does a user need to create an assembly with UNSAFE permissions?
• You are wondering if your indexing scheme for the SQL Server 2005 database that you are managing is appropriate?
• More...