• Cliff Jones (4/12/2012)


    Steve Jones - SSC Editor (4/12/2012)


    The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense. So if you move a partially contained database to a server that has a matching login, the login isn't contained.

    Not a big deal, but interesting.

    That is interesting. I was confused by Contained versus Partially Contained and assumed your question pertained to the former. Thanks for the interesting question.

    Contained Databases are only partially contained in SQL Server 2012. Hopefully SQL Server 2014/2015 will be completely contained.