Post reply

FTS using RBS

  • April 6, 2010 at 5:26 am

    #217527

    Dear All,

    I am using SQL Server 2008 for my application. I am storing the documents in a shared folder and storing the ID of the document alone in the SQL table using the "Remote Blob Storage" concept.

    I have a requirement for doing Full Text search in the documents stored in the database. I will be using the functions ContainsTable function and FreeTextTable function for doing searching.

    I need to know how to do this for RBS data.

    Please help in this regard.

    With Thanks & Regards,

    M. Gangadhar.

  • April 6, 2010 at 11:58 am

    #1146688

    you cant create FTS on RBS but you can create fts on filestream.

    Alex S

  • April 7, 2010 at 11:24 pm

    #1148035

    Dear Alex,

    Thanks for the reply. Is there any option to store the files in a remote machine (using a mapped drive) in the Filestream concept ?

    With Thanks & Regards,

    M. Gangadhar.

Viewing 3 posts - 1 through 3 (of 3 total)

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