Missildigital 10 X 25 Camera Binoculars Review

Contained in SQL Server Database SQL Denali Denali

databases are not always easy to move from one server to another because there are many agencies such as tempdb, log, collation, among others. To facilitate the operations of moving a database from one server to another SQL Server introduces the concept of Denali Contained Databases. Contained

A database includes all the settings and metadata that are needed to define the database and has no dependencies to an instance of SQL Server in particular. In this way it has isolated the database Database Engine component which makes it easy to move physical server.

To create a database with these characteristics we can use the following script:

USE [master];

GO CREATE DATABASE [ContainedSampleDB1] COLLATE SQL_Latin1_General_CP1_CI_AS;
GO

- Must allow the type of authentication for database

Contained EXEC sp_configure 'show advanced options', 1;

GO RECONFIGURE WITH OVERRIDE;

GO EXEC sp_configure 'container database authentication', 1;
EXEC sp_configure 'show advanced options', 0;

GO RECONFIGURE WITH OVERRIDE;
GO

- Now you must enable such features in the database you just created

ALTER DATABASE [ContainedSampleDB1] Containment = PARTIAL SET, GO

Greetings, Mr. Eduardo Castro

Martinez, PhD - Microsoft SQL Server MVP

http://tiny.cc/comwindows

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com