Transparent Data Encryption - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Transparent Data Encryption

Author

Topic

AAAV
Posting Yak Master

152 Posts

Posted - 2010-03-19 : 16:40:39

When i encrypt a Db this way, will i be able to see the procedures and the tables?

I created a master key
created a certificate and then gave

CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_128
ENCRYPTION BY SERVER CERTIFICATE MyCertificate
GO
ALTER DATABASE encry
SET ENCRYPTION on
GO

I am still able to see the tables and the procedures.
What am i doing wrong?

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2010-03-19 : 17:29:39

I'm not an expert on TDE. But, as far as I know, it applies to the underlying data and has more to do with backup and recovery than making it so you cannot read the database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources