sys.sysobjkeycrypts
shows symetric keys, encryption or cryptographic property associated with an object. sys.sysobjkeycrypts
is a system base table, thus it needs a dedicated administrator connection to select from it. select obj.name, cry.class, cry.type, cry.status, cry.thumbprint from sys.sysobjkeycrypts cry left join sys.sysschobjs obj on cry.id = obj.id;