查询数据库不为空的数据库
select distinct object_name(id),rowcnt from sys.sysindexes where rowcnt>0
查询数据包含某个字段
SELECT b.name as TableName,a.name as columnname
From syscolumns a INNER JOIN sysobjects b
ON a.id=b.id
AND b.type='U'
AND a.name='你的要查询的字段名'
查询包含储存过程的名称
select distinct name
from sysobjects a,syscomments b
where a.id=b.id
and b.text like '%你的储存过程名称%'