Denali Contained Databases Not Compatible with Replication
I very much liked the idea of Contained Databases as it would make it much easier to move databases across different servers and even use this feature as part of a disaster recovery strategy. Here is really good article that explains how Contained Databases work in Denali:
http://www.sqldbadiaries.com/2011/02/01/contained-databases-in-sql-server-denali/
While very excited about this feature, I came across a big issue as it is not supported on databases that are either part of Replication, Change Data Capture or Change Tracking.
Now, as most of the databases I have in production are replicated in one way or another, it simply will not be possible to use it.




