Nilssond
Hall of Fame
Points: 3285
More actions
August 10, 2004 at 9:27 am
#86042
I am trying to write a script which will search all stored procedures and DTS packages for a database table name. Any help out there?
JBZ
SSC-Addicted
Points: 400
August 10, 2004 at 9:35 am
#518342
Something like this?
select o.name from sysobjects o
inner join syscomments c
on o.id = c.id
where text like '%table_name%'
Julia
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply