More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
In SQL Server 2005 Full-Text Search, you set up a replacement set like this:
<replacement>
<pat>SS2K5 </pat>
<sub>SQL Server 2005 </sub>
<sub>SQL Server 2K5 </sub>
</replacement>
A search for "SS2K5" doesn't return results with fields that you know contain "SS2K5". What is wrong?
The replacement set does not return results with the search terms, only the specified replacements.
(Continued on next question...)