SELECT instance_name,
      cntr_value
FROM   sys.dm_os_performance_counters
WHERE  OBJECT_NAME = 'SQLServer:Deprecated Features'
      AND cntr_value > 0
ORDER BY
      cntr_value DESC

SELECT O.Name,
      col.name AS ColName,
      systypes.name
FROM   syscolumns col
      INNER JOIN sysobjects O
           ON  col.id = O.id
      INNER JOIN systypes
           ON  col.xtype = systypes.xtype
WHERE  O.Type = 'U'
      AND OBJECTPROPERTY(o.ID, N'IsMSShipped') = 0
      AND systypes.name IN ('text', 'ntext', 'image')
ORDER BY
      O.Name,
      Col.Name