Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?
SELECT t.name AS [Table],
c.name AS [Column],
c.encryption_type_desc
FROM sys.all_columns c
INNER JOIN sys.tables t
ON c.object_id = t.object_id
WHERE c.encryption_type IS NOT NULL
ORDER BY t.name,
c.name;