业务中，某些表等等发生变化，查看用到这个对象的 存储过程，视图

 

--sysobjects;syscomments
---sqlコードチェックツール


declare @checkstr as varchar(8000)
declare @checktype as varchar(10)
declare @checkobj  as varchar(100)
---変数設定
set @checkstr ='130'----調査対象
set @checktype = 'v'--v:ビュー p:ストアド

if object_id('tempdb..#checkresult') is not null
drop table #checkresult
create table #checkresult
(
obj varchar(200)
)

if object_id('tempdb..#t') is not null
drop table #t

select 
 name
 into #t
from dbo.sysobjects
where xtype=@checktype
order by name

---コードチェック
while exists (select 1 from #t)
begin
 set @checkobj=(select top 1 * from #t)

 if exists
 (
  select 1 
  from syscomments 
  where 
   id=object_id(@checkobj) 
  and text like '%'+@checkstr+'%' 
 )
 begin
  insert into #checkresult
  select @checkobj
 end

 delete from #t where  name=@checkobj
end
----合っている対象出し
select *from #checkresult