var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SP and trigger body
I want to get all the trigges and SP's that uses the keyword USER
I tried the ff;
select * from systrigbody where data like "%USER%";
select a.procname,b.data from sysprocedures a,sysprocbody b
where a.procid = b.procid
and upper(b.data) like "%USER%"
and lower(a.procname) like "v3%"
I guess what I'm saying is can anyone suggest a better way of doing it.