Listing 4: Inspecting the Prepared Plans in Plan Cache

SELECT usecounts as uses, sql FROM  sys.syscacheobjects
WHERE dbid = db_id('AdventureWorks')
  AND objtype = 'Prepared'
GO