Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators

Top Categories · View All
TSQL Enhancements 28
Discontinued Features 16
SSIS Enhancements 10
SSMS Enhancements 10
Database Engine 10
Database Administration 8
Security 3
Full Text Search 2
DataTime 1
Breaking Changes 1

Browse by Tags · View All
Denali 82
SQL Server 2012 79
SSIS 9
SSMS Enhancements 9
Analytic Functions 8
Usability Enhancements 5
SQL11 4
TSQL 4
Security 3
Database Engine 3
Datetime 3
Query Hints 2
OVER Clause 2
DMV 2
Groups 2
Dynamic Management Functions 2
DMF 2
System stored procedures 2
DBA 2
FTS 2

Browse by Release · View All
All 58
RC0 20
SQL Server 2012 Denali 2
CTP3 2
SQL Server Denali 1

What is new in SQL Server 2012 - Denali

Contained Databases allow you to move a database to a new location along with all the dependencies

Nov 28 2011 8:33PM by Jacob Sebastian   

One of the challenges involved in moving/copying databases to a new location (prior to SQL Server 2012) was copying the dependencies along with the database. External dependencies such as login names, linked servers etc are not automatically copied to the new location when you restore a regular database backup.

SQL Server 2012 (Denali) introduces Contained Databases, a new feature that allows you to embed all the dependencies right into your database. When the database is moved/copied to a new location, all the dependencies are also moved/copied along with the database.

SQL Server 2012 (denali) Contained DB Properties

Read More Have you written a blog post or article related to this feature and want to get them added here? Read More...
Category : Database Administration
Release : All
Tags : Denali, SQL Server 2012, DBA, Database Administration, Contained DB


Jacob Sebastian
1 · 100% · 32235
4



Submit

Your Comment


Sign Up or Login to post a comment.

"Contained Databases allow you to move a database to a new location along with all the dependencies" rated 5 out of 5 by 4 readers
Contained Databases allow you to move a database to a new location along with all the dependencies , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]