SQL Server查询表在存储过程中的使用

----查找关键字在哪个库的存储过程里
DECLARE @namess varchar(100),@sql NVARCHAR(MAX),@totals VARCHAR(10),@procname VARCHAR(50)
SET @procname = LOWER('大写的表名')
--所有的数据库的库名
declare db_cursor cursor 
for (SELECT NAME FROM Master..SysDatabases t)   
OPEN db_cursor
fetch next from db_cursor into @namess
while @@FETCH_STATUS = 0
    BEGIN
        --PRINT('数据库：'+@namess);
        SET @sql = 'select @totals = count(1)
from '+@namess+'.dbo.syscomments a, '+@namess+'.dbo.sysobjects b
where a.id=b.id  and b.xtype=''p'' and lower(a.text) like ''%'+@procname+'%'''
exec sp_executesql @sql,N'@totals int out',@totals OUT

        IF @totals > 0
        BEGIN 
         PRINT('@totals：'+@totals + '        数据库名:' + @namess);
         SET @sql = 'select distinct '''+@namess+''' as 数据库名,b.name 存储过程名
from '+@namess+'.dbo.syscomments a, '+@namess+'.dbo.sysobjects b
where a.id=b.id  and b.xtype=''p'' and lower(a.text) like ''%'+@procname+'%'' order by b.name'
PRINT('SQL：'+@sql);
exec sp_executesql @sql
END
        
        FETCH next from db_cursor into @namess
    END
close db_cursor
deallocate db_cursor