Reversing or disabling Contained Databases in Microsoft SQL Server 2012
I started by looking for a way to use this with AlwaysOn and my Infor Visual Manufacturing database on SQL 2012 Enterprise Edition (Required for AlwaysOn) so that my users would show up in the secondary database servers without having to copy their profiles from server to server using tools that export the Hash and SID, like sp_help_revlogin (Look into this! It works great and is a safer alternative).
Turns out that this was a bad idea. I tested it in a lab and it worked fine, but I didn't test every function and I found that Info Visual Manufacturing ERP has a collation error in the Audit Maintenance window. This was the error:
WHERE DP.TYPE IN ('S')
AND DP.is_disabled = 1;