Seen almost the same before, the difference being the text qualifiers and the missing parameter delimiter. Guess you will have to query the sys.all_sql_modules

😎

SELECT

OBJECT_NAME(ASM.object_id) AS OBJ_NAME

,OBJECT_SCHEMA_NAME(ASM.object_id) AS OBJ_SCHEMA_NAME

,ASM.definition

FROM sys.all_sql_modules ASM

WHERE ASM.definition LIKE N'%RAISERROR%'

AND ASM.object_id > 100;