thanks for the reply. Adding the single quotes allowed the 'parse' check to be successful but when the code was executed, a syntax error occured.

--

Msg 102, Level 15, State 1, Line 14

Incorrect syntax near 'SERVER_ROLE'.

Msg 105, Level 15, State 1, Line 14

Unclosed quotation mark after the character string ')'.