azhar.iqbal499 (12/1/2011)
I have created TDE from sa user and I logged in with another user with same rights. But all DB objects were looking unencrypted.
Yes, because TDE is encryption of the database file to prevent people from attaching it on other servers. Nothing whatsoever to do with the objects in the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability