In "normal" web application it is not the logged in user that access the database, but a single trusted nt user or a sql user in the connecting string.

So where...

Thanks for the answer

I had a suspicion that i needed to OR or AND a lot of contains expression. Was just hoping that I could get it all for free:P

Thanks for the great article. As soon as I read it. I started to implement full text search on our most used table.

I have altered the code to use CONTAINSTABLE(tblsite,*,@ftsQuery)...