Comments like this make it worthwhile so thanks! 😎

I guess my scripts as they are only work for one database comprehensively 😀

Quick answer - everywhere where there are commands affecting XX_DATABASE_XX copy and paste them as many times...

I did not want to write yet another article about TDE that tells you lots of complicated theory and background but then does not actually tell you how to use...

By chance my site only has one database that uses TDE with no other application databases on the same instance. Definitly try any change in DEV or TEST before PROD....

You can see an alternative "article" I wrote for this at:

http://www.sqlservercentral.com/Forums/Topic947481-391-1.aspx

Glad you like it. I was quite impressed with myself too 🙂

Have you ever automatically generated the script for a SQL Agent Job in SQL Server Management Studio? When you do this it includes GOTO statements. I've got bigger fish to...

Good stuff

Sorry Sam but you are mistaken. All the scripts are in the zip file and always were.

It already explains in the article that dbadata database needs to exist in advance. Alternatively you can globally replace dbadata with another "dba database" you already have on the server.

You may need some additional permissions/config if your server does not already have them:

exec sp_configure ‘show advanced options’, 1

exec sp_configure ‘Agent XPs’, 1

For reasons unknown you may also need to...

SQL2008 Yes

SQL2005 No

Thanks for the compliment! I'll treat myself to a hazelnut. The article is no different to this post. The code is also complete with no planned updates at this stage....

http://www.sqlservercentral.com/Forums/Topic947481-391-1.aspx

still exists and is the same. I posted it in SQL2005 and SQL 2008 forum but now is only in SQL 2008. It will also be published as an article...

Attachments updated with better document and bug fix to initial install process. There was the possibility of a "begin tran" with no "rollback" if @JobLogDir path was wrong. Subsequent attempts...