SQL SERVER 查看所有存储过程或视图里包含某个关键字的查询语句

SELECT a.name,a.xtype FROM sysobjects a,syscomments b
WHERE a.id = b.id AND b.text LIKE  '关键字'
order by name