exec master.dbo.sp_MSForEachDb
'
  if ''?'' != ''tempdb''
  begin
    if exists
    (
       select 1 from sys.dm_database_encryption_keys
       where DB_NAME(database_id) = ''?''
    )
    begin
       while not exists
       (  
          select encryption_state from sys.dm_database_encryption_keys
          where DB_NAME(database_id) = ''?'' and encryption_state = 1
       )
       begin
          set @DateStr = convert(varchar, getdate(), 120)
          raiserror(''%s Waiting 5 seconds for database encryption to complete'', 0, 0, @DateStr) with   nowait
          waitfor delay ''00:00:05'' 
       end
    end
  end
'