Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 TDE

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-08-23 : 17:03:12
Hi,

In SQL Server, where to check that we have Transport Data Encryption (TDE) enable for this instance or database?

Thanks

rx2526
Starting Member

4 Posts

Posted - 2012-08-24 : 00:14:02
Have you checked sys.databases ?
select * from master.sys.databases where is_encrypted = 1
Go to Top of Page

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-08-24 : 11:56:13
Thanks for your help.
Go to Top of Page
   

- Advertisement -