I worked past the issue above by rebuilding the Full Text Catalog by right mouse clicking on the catalog and selecting rebuild. I am now running into this error message...

Both of the suggestions work.

Which should I use?

Thanks for your help. Notice that I have the where clause commented out. When you remove the comments I do not get expected results. Live is a flag to determine...

Thanks for your help.

I am still getting this error on the execution of this code.

Exec usp_AdvancedSearchArticles 'Standards'

Msg 7630, Level 15, State 3, Procedure usp_AdvancedSearchArticles, Line 22

Syntax error near 'Standards' in...

The problem is when I remove the char(34) + and run code like this.

exec usp_AdvancedSearchArticles 'test hi'

I get this error

Msg 7630, Level 15, State 3, Procedure usp_AdvancedSearchArticles, Line 22

Syntax error...

Thanks for your help! When I try an execute this procedure I get this error.

exec usp_AdvancedSearchArticles 'Standards'

Msg 7630, Level 15, State 3, Procedure usp_AdvancedSearchArticles, Line 22

Syntax error near 'Standards' in...

How would I get the rest of the fields into the select?

Thanks for your help!

GSquared, thank you so much for this it is a much better solution. I was using a script which auto generated the triggers and audit tables.

I will read what you...

Hi G Squared, thanks for your prompt response. Here is my entire trigger. Thanks again for your help. I tried some things at the bottom but it is not...