Its per database so you will need to run it in every DB.

Also sql_modules stores the definition for

P = SQL Stored Procedure

RF = Replication-filter-procedure

V = View

TR = SQL DML trigger

FN = SQL scalar function

IF = SQL inline table-valued function

TF = SQL table-valued-function

R = Rule (old-style, stand-alone)

But if its not bringing back a object you know has a cursor, check the cursor definition and change the like filter accordingly.