Hello,

Great idea for the stored procedure. For some reason the code does not execute. Below are the errors I'm getting. Is there an updated version??

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 55

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 56

Incorrect syntax near '?'.

Msg 137, Level 15, State 2, Line 61

Must declare the scalar variable "@ObjectType".

Msg 137, Level 15, State 2, Line 63

Must declare the scalar variable "@ObjectType".

Msg 137, Level 15, State 2, Line 69

Must declare the scalar variable "@SearchText".

Msg 137, Level 15, State 2, Line 70

Must declare the scalar variable "@SearchText".

Msg 137, Level 15, State 2, Line 75

Must declare the scalar variable "@SearchType".

Msg 137, Level 15, State 2, Line 78

Must declare the scalar variable "@SearchType".

Msg 102, Level 15, State 1, Line 80

Incorrect syntax near '?'.

Msg 137, Level 15, State 2, Line 90

Must declare the scalar variable "@SearchType".

Msg 102, Level 15, State 1, Line 92

Incorrect syntax near '?'.

Msg 137, Level 15, State 2, Line 101

Must declare the scalar variable "@SearchType".

Msg 102, Level 15, State 1, Line 103

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 114

Incorrect syntax near '?'.

Msg 137, Level 15, State 2, Line 114

Must declare the scalar variable "@OrderBy".

Msg 102, Level 15, State 1, Line 116

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 119

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 120

Incorrect syntax near 'END'.