SQLTeam.com | Weblogs | Forums

How to find a store procedure which creates a xm logic


#1

I have a huge db. I need to find a sp which is creating the following logic:
< Dutiable>
0.0 </Declared Value>

Could you guide me to run a query? I am running the following query with no luck:

select * from sysobjects
where name like '%0%'


#2

Sorry this is the query im running

select * from sysobjects
where name like '%Dutiable%'

with no luck


#3
select object_name(object_id) name from sys.sql_modules where definition like '%< Dutiable>
0.0 </Declared Value>%';