Sql Server 遍历数据库文件找出使用了某个表/存储过程的所有存储过程

Sql Server 遍历数据库文件找出使用了某个表/存储过程的所有存储过程。

CREATE Procedure SP_GetProc      
@Object_Name Varchar(50)      
as      
Set nocount on      
  
DECLARE @tmptable TABLE    
(    
ID int IDENTITY (1, 1),    
[DataBase] Varchar(100),  
Name Varchar(500),  
Type Varchar(100),  
Create_Date Datetime  
)    
  
DECLARE @SQLText TABLE    
(    
ID int IDENTITY (1, 1),    
SQLText Varchar(Max)  
)    
  
if Charindex('#', @Object_Name) > 0  
begin   
  Select @Object_Name = replace(@Object_Name, '#', '')  
  
  Insert Into @SQLText  
    Select '      
    Select ''' + Name + ''' [DataBase], CONVERT(VARCHAR(500), a.Name COLLATE Chinese_PRC_CI_AS) Name, a.Type, a.Create_Date      
      From ' + Name+ '.sys.all_objects a   
      Where a.Name Like ''%' + @Object_Name + '%'''      
      From sys.databases where database_ID > 4      
end  
else begin  
  Insert Into @SQLText  
    Select '      
    Select ''' + Name + ''' [DataBase], CONVERT(VARCHAR(500), a.Name COLLATE Chinese_PRC_CI_AS) Name, a.Type, a.Create_Date      
      From ' + Name+ '.sys.all_objects a, ' + Name + '.sys.syscomments b       
      Where a.object_id = b.id and b.text Like ''%' + @Object_Name + '%'''      
      From sys.databases where database_ID > 4      
end  
  
Declare @ID Int, @MID Int, @SQl Varchar(Max)  
Select @ID = 1, @MID = MAX(ID) From @SQLText  
While @ID <= @MID  
begin   
  Select @SQl = SQLText From @SQLText Where ID = @ID  
  Insert Into @tmptable Exec (@SQl)   
  Select @ID = @ID + 1  
end  
  
Select * From @tmptable Order by ID