Indeed, following on from wshmstr's comment, I ended up raising a MS Connect ticket (http://connect.microsoft.com/SQLServer/feedback/details/694338/instance-collations-with-supplementary-character-option-lead-to-a-failure-to-install-the-deta-sprocs) over an issue with DETA not working on instances using the new Unicode supplementary character collation option in SQL Server 2012.

I almost considered rewriting the SPs that DETA is based on since they looked to have had no maintenance on them since SQL Server 2000-era (ntext data type... *shudder*), but wondered what the dev team would actually do with the bug report.

Thankfully, it's fixed, but I still haven't found the time to go back and work out what they actually did. Maybe this weekend... 🙂