• The script fails to post in my SQL 2005 studio with the follow errors (fyi CREATE is on the first line):

    Msg 102, Level 15, State 1, Procedure spUtil_Occur, Line 3

    Incorrect syntax near '?'.

    Msg 137, Level 15, State 2, Procedure spUtil_Occur, Line 39

    Must declare the scalar variable "@SearchString".

    Looks OK to me. Am I missing something?

    Thanks for the post!