Database containment and c

Question

Post reply

Database containment and c

Thomas Franz

Hall of Fame

Points: 3893
More actions
October 28, 2019 at 12:00 am

#3689801

Comments posted to this topic are about the item Database containment and c
God is real, unless declared integer.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Solomon Rutzky SSCoach Points: 16430 More actions · Answer 1

Hi Thomas. Interesting question. A few notes:

Most importantly, there is a typo in the setup code, implying that the answer should be the opposite of what it really is. In the part where you state that you are going to set the test database to "partial containment", your SQL statement actually sets it to its current state of "none". You have:
```
ALTER DATABASE [test_cont] SET CONTAINMENT = NONE WITH NO_WAIT
```
when it should be:
```
ALTER DATABASE [test_cont] SET CONTAINMENT = PARTIAL WITH NO_WAIT;
```
Changing this would have the T-SQL match the text description of what's going on.
Official documentation is here:Contained Database Collations
Minor point, but your initial setup code block could be simplified to be just the following:
```
CREATE DATABASE [test_cont]
    CONTAINMENT = NONE
    COLLATE Latin1_General_CI_AS_KS;
```
or even just the following, since "NONE" is the default for containment type anyway:
```
CREATE DATABASE [test_cont]
    COLLATE Latin1_General_CI_AS_KS;
```

Take care,

Solomon....

This reply was modified 5 years ago by Solomon Rutzky.

SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR

Carlo Romagnano SSC-Insane Points: 22668 More actions · Answer 2

Here it stats https://docs.microsoft.com/it-it/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-ver15, too.

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 3

Nice question ,thanks Thomas.

Concur with Solomon about the slight mix-up

"

ALTER DATABASE [test_cont] SET CONTAINMENT = NONE WITH NO_WAIT

when it should be:

ALTER DATABASE [test_cont] SET CONTAINMENT = PARTIAL WITH NO_WAIT;

"

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”