--适用MSSQL2000、MSSQL2005use masterdeclare @dbid intSelect @dbid = dbid from sysdatabases where name = 'Test'--修改成数据库的名称selectdbid,UseCounts ,RefCounts,CacheObjtype,ObjType,DB_Name(dbid) as DatabaseName,SQLfrom syscacheobjectswhere dbid=@dbidorder by dbid,useCounts desc,objtype
