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!