If you're asking if Transparent Data Encryption is enabled, you can query sys.databases:
select name, is_encrypted
from sys.databases
where database_id > 4
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------