查找表或其他对象在某个Server上的存在

EXEC sp_MSforeachdb 'use ? ;  IF EXISTS(SELECT top 1 1 FROM sys.syscomments WHERE text LIKE ''%test%'')  SELECT ''?'' as dbname,object_name(id) as object FROM sys.syscomments  WHERE text LIKE ''%test%'''