This works on Adventure Works when I want to find all occurences of the keyword 'product' in my JobCandidate table :

[font="Courier New"]SELECT * FROM sys.dm_fts_index_keywords_by_document(db_id('AdventureWorks2008'),

object_id('HumanResources.JobCandidate'))

where display_term = 'product';[/font]

One of...

I have a question about the dynamic SQL block of code you have included in your article.

So the way you have constructed your dynamic SQL, you took @FirstName and @LastName...

No I did not change anything. Here is exactly how I ran it :

Step 1: Highlight code block 1 (the main query) and hit the EXECUTE button 3 times.

Step...