7 Comments on “Contained Databases in SQL Server 2012 – Denali”

  1. Hi Sarab…Could you please elaborate how a user can login to the database without having a login. I am bit confused on contained DB part.

  2. Also, can you explain me two-part name & three-part name that you’ve mentioned in the application model & mangement model?

  3. Hi,

    For your first Question: ” Hi Sarab…Could you please elaborate how a user can login to the database without having a login. I am bit confused on contained DB part.”

    Don’t worry about this, i am writing another article on “How to Create and Manage Contained Databases” and i’ll explain everything regarding these users in the article.

    I am busy with lots of other stuff today….will try to publish that tommorow.

  4. Your second question: “Also, can you explain me two-part name & three-part name that you’ve mentioned in the application model & mangement model?”

    Let’s say you are connected to Sales Database and want to get some data out of Employee database, how will you get that data?

    you’ve two options:

    1. Connect to Employee DB …. query for the data you need & then connect back to Sales Database to continue working on whatever you were doing.

    2. Query directly to Employee database by using three part Name i.e., select * from Employee.dbo.PersonalDetails

    Note: Employee is database Name, dbo is Schema Name and PersonalDetails is Table\view Name.

    The same way you can connect to some other Server or SQL Instance also to get some data by providing a four part name:

    ServerName.DatabaseName.SchemaName.TableName

    in some cases you may skip giving schemaName if the schema of the object is either in DBO schema or your default schema.

    Hope this helped. Smile

    Thanks

    Sarab

Leave a Reply

Your email address will not be published. Required fields are marked *