SQLTeam.com | Weblogs | Forums

Question on storing Text in Database


I have not had to store large amount of text in a database before. I know how to import it with SSIS of SQL code.
However, I want to be able to do Full Tet searches on it; an I know how to do that too; including setting it up and indexing it.
What I do not know, is how this is normally done. That is it would seem to me, and what I need to happen, is that each record holds the text. This is big text as it is from audio transcripts.
Can you tell me how do this please.



create a table with at least one nvacrhar(max) column. store the text in there. Then, set up the indexing. That's it.


Okay thanks


And use of FULLTEXT / FREETEXT perhaps?