title: SQL Server TDE - how to tell when complete?
body: <p>Is there a way to tell when a database is completely encrypted when using SQL 2008 TDE? I.e.,</p>
  
  <p>ALTER DATABASE mydb SET ENCRYPTION ON</p>
  
  <p>The only way I can think of is to keep trying to detach mydb. It won't detach until all pages are encrypted.  However, I'd like to have a cleaner way that does not involve detaching?</p>
  
  <p>Thanks.</p>