<div>
Hi<br />
must be possible with MS and its indexing.<br />
if you have a Linux client you can use you can try &quot;<br />
<a href="http://www.cyberciti.biz/faq/howto-search-find-file-for-text-string/" rel="ugc">was going to type it out but here this will at least explain it :)</a> &quot;<br />
i'll have a scout in windows, I have a feeling you might need to enable advanced searching and indexing if on a server but that will add load.
</div>


<div>
Hi Stolsie,<br />
<br />
Thanks for the response.<br />
<br />
We are using windows &amp;&nbsp;sql server.<br />
<br />
And I want to search a string with in the document from sql query.<br />
<br />
Thanks.
</div>


<div>
ahh sorry I read it as you wanted to search a document for a specific line.. oops...<br />
What I know about SQL is dangerous, I'll bow out, sorry. <br />
I'll leave you with this <a href="http://stackoverflow.com/questions/7884999/how-to-convert-string-into-query-in-sql-server" rel="ugc">click me :)</a>
</div>


<div>
I vaguely remember something like this a while back. <br />
<br />
<a href="https://www.mssqltips.com/sqlservertip/2769/sql-server-semantic-search-to-find-text-in-external-files/" rel="ugc">https://www.mssqltips.com/sqlservertip/2769/sql-server-semantic-search-to-find-text-in-external-files/</a><br />
<br />
Hope it helps
</div>


<div>
@srivatsavaye - I already checked this.<br />
<br />
But looks like I don't have any option than to try this.<br />
<br />
I will keep you posted once I try this.<br />
<br />
Thanks.
</div>


<div>
I forgot that I am using SQL Server 2008 R2. <br />
<br />
I think &nbsp;Semantic Search will work from SQL Server 2012.
</div>


<div>
Bummer!! I didn't realize you are using 2008 R2. I don't think i can help you with this. Sorry. <br />
<br />
Good luck.
</div>


<div>
Hi vitor,<br />
<br />
Documents are stored in the file system and not in the database. Can you please help me.<br />
<br />
Thanks.
</div>


<div>
Hi Vitor,<br />
<br />
I am on a vacation and could not respond.<br />
<br />
Documents are stored in file system and not in the column.<br />
<br />
Is there a way to do the below.<br />
<br />
Loading the documents from file system to the tables using query and then index the column as you said above.<br />
<br />
Thanks.
</div>


<div>
Thanks Vitor.<br />
<br />
I am going through it.
</div>


<div>
Finally I have done it by enabling FileStream and created a database with file Stream datafile.<br />
<br />
&nbsp;Created a table &amp;&nbsp;added a full text on the table.<br />
<br />
Thanks all for your help.
</div>


<div>
I'm very glad to hear that.<br />
Cheers.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Can you please help me in searching keywords with in the documents stored in file system from SQL Server.<br />
<br />
I do remember that I used to do this using full text by using the path of the document, file name and keyword in single query. I could not get the exact way.<br />
<br />
Thanks in advance.
</div>
</div>


Hi,

Can you please help me in searching keywords with in the documents stored in file system from SQL Server.

I do remember that I used to do this using full text by using the path of the document, file name and keyword in single query. I could not get the exact way.

Thanks in advance.

Search keyword in Documents stored in file system from SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.