• OK, I now see this was entered under 'Articles Requested'. I thought it was a general question. Offhand, I don't know of any limitations that TDE would place on other SQL Server features, other than of course the limitation (by design) that you cannot restore or attach the database on another server without first restoring the same certificate used to encrypt the database encryption key (DEK).

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho