查找表或其他对象在某个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%'''