<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Contained Databases
21 posts, Page 1 of 3
1
2
3
»
»»
Contained Databases
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Tuesday, March 27, 2012 9:51 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436,
Visits: 13,751
Comments posted to this topic are about the item
Contained Databases
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1274035
baabhu
baabhu
Posted Tuesday, March 27, 2012 11:20 PM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:58 AM
Points: 1,112,
Visits: 970
Hi Steve,
Question on SQL 2012. I guessed and guessed it wrong.
Good. to knew about contained databases.
--Babu
Post #1274057
Hugo Kornelis
Hugo Kornelis
Posted Wednesday, March 28, 2012 12:32 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:21 AM
Points: 5,244,
Visits: 7,062
Good question - but what's up with the word "other" in the question?
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1274078
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, March 28, 2012 12:39 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
Good to see questions on SQL Server 2012.
I did find the question itself poorly phrased, because of the use of "other" and the general term "options".
When I look at the reference, I see the following:
contained, uncontained, partial, non-contained
So it looks like there are more two correct answers, but there is no explanation given why some are correct and others aren't.
edit: after reading the reference a few times, it makes more sense
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1274080
Carlo Romagnano
Carlo Romagnano
Posted Wednesday, March 28, 2012 12:56 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 12:56 AM
Points: 1,972,
Visits: 1,822
New features are welcome!
But, I get it wrong!
Post #1274084
paul s-306273
paul s-306273
Posted Wednesday, March 28, 2012 1:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,161,
Visits: 642
Bit of a strange question.
Two days running I've guessed.
Two days running I've guessed incorrectly.
Aarggh!
Post #1274111
Michael Riemer
Michael Riemer
Posted Wednesday, March 28, 2012 2:34 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:50 AM
Points: 1,241,
Visits: 347
Great to see questions on 2012 now, but also have to ask what is up with the "other" in the question?
Post #1274136
call.copse
call.copse
Posted Wednesday, March 28, 2012 2:47 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 2:48 AM
Points: 1,088,
Visits: 693
I kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:
http://msdn.microsoft.com/en-us/library/ms176061.aspx
This clearly defines the options.
Post #1274143
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, March 28, 2012 3:01 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
call.copse (3/28/2012)
I kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:
http://msdn.microsoft.com/en-us/library/ms176061.aspx
This clearly defines the options.
That is indeed a very clear reference. Thanks!
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1274151
L' Eomot Inversé
L' Eomot Inversé
Posted Wednesday, March 28, 2012 5:00 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 7,110,
Visits: 7,184
Nice to see a question on sql 2012.
But the wording could have been better. Like Koen and Hugo and call.copse I find that word "other" in the question bizarre. My first reaction was "other than what".
Obviously "NONE" is not an option for a contained database: CONTAINMENT = NONE in CREATE DATABASE certainly doesn't generate a contained database! I guess the options concerning contained databases are "have a partially contained database" and "don't have a contained database", but the latter is certainly not an option
for
a contained database (one might of course label it an option
against
a contained database.
After much cogitatin I decided the word "other" was meaningless and that "options for a contained database" must mean "options for the containment or otherwise of a database" since it certainly couldn't mean what it said, so I scored the point. But that was because I guessed right about what the question meant, not because the question said what it intended to mean.
There were only 24% correct answers to date; it's quite possible that some of the other 76% were caused by the really strange wording of the question.
Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1274192
« Prev Topic
|
Next Topic »
21 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
