How can we improve SQL Source Control?

Add contained database support in SQL 2012

Need to have better support for contained databases feature of SQL Server 2012. For example a new feature - user WITH PASSWORD is scripted as a user WITHOUT LOGIN.

7 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Roman TumaykinRoman Tumaykin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Andrew NikoloffAndrew Nikoloff commented  ·   ·  Flag as inappropriate

        Almost 4 years later it still does not support contained database users. How that?!

        This is what you get, when you try to commit a contained database user:

        Severity: Medium
        Object: XXXXXX
        Title: The user XXXXXX does not have an associated login. If the user was not defined with WITHOUT LOGIN then the source database is in an inconsistent state. Please fix this by using sp_change_users_login.
        ----------------------------------------------------

      Feedback and Knowledge Base