kavidha (3/20/2013)
Hi Kevin,Thanks a lot for your reply.
1. No i dont want to use NText...
2. I am not sure about the Single BLOB...so for my scenario, can i use it? is it better solution?
Thanks.
Yes, you can store SOME types of files as blobs (either filestream or not) and then have Full Text Indexing shred them. Some file types will not be FTS-aware. You may wish to consult with an FTS expert to see what is best for your needs. Personally I would set up tests of several different mechanisms and see which works/works best for YOUR needs.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service