InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 20:21:33 GMT20http://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGuessed on the SQL 2012 question and got it right. Thanks for submitting.Mon, 02 Apr 2012 18:58:26 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGot partial, but got the other option wrong. Learnt something.Mon, 02 Apr 2012 03:59:59 GMTskankerhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspx[quote][b]Hugo Kornelis (3/28/2012)[/b][hr]Good question - but what's up with the word "other" in the question?[/quote]ID10T error.I started with one question, and then changed, rewording the answers and explanation to fit. Forgot to remove "other".Fri, 30 Mar 2012 13:21:02 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxAgree with those who say the question is a bit confusing.If you have containment set to NONE, then it's not a contained database, surely ? Especially since all new databases are not contained by default.Or are [b]all [/b]databases in SQL 2012 to be considered as "contained", with the tie-breaker being the type of containment on each ? :-)Thu, 29 Mar 2012 04:40:01 GMTsqlmunkeehttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspx[quote][b]Hugo Kornelis (3/28/2012)[/b][hr]Good question - but what's up with the word "other" in the question?[/quote]It guided me to exclude Contained for an answer :hehe:I looked up for documentation and one answer was obvious but for other there were used fully contained, uncontained and non-contained. I didn't get the second option until looking into :w00t: Create Database.edit: Anyway - it is poorly worded or at least misguiding question :doze:Thu, 29 Mar 2012 02:12:30 GMTdawrynhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxI got confused with the wording too, but I too am happy to see some 2012 questions pop up.Wed, 28 Mar 2012 15:53:09 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGood question, but a little more wording on it would have helped understand what "other" means (options for creation, options for containment model, etc.)"El" Jerry.Wed, 28 Mar 2012 11:10:48 GMTEL Jerryhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGot confused with the word "Other". Thought it was partial and uncontained!!!Wed, 28 Mar 2012 09:53:15 GMTSS999http://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspx? on SQL 2012 +1Wed, 28 Mar 2012 08:41:28 GMTBarbWhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxYippee skippee.Let's have more questions on 2012Wed, 28 Mar 2012 08:07:35 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspx[quote][b]Koen Verbeeck (3/28/2012)[/b][hr]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-containedSo 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 :-D[/quote]This was my understanding of the question as well. Judging by the QOTD responses and that most people answered incorrectly (as did I) the wording threw many of us off.Wed, 28 Mar 2012 07:40:35 GMTAlways Learninghttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxNice 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 [i]for[/i] a contained database (one might of course label it an option [i]against[/i] 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.Wed, 28 Mar 2012 05:00:31 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspx[quote][b]call.copse (3/28/2012)[/b][hr]I kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:[url=http://msdn.microsoft.com/en-us/library/ms176061.aspx]http://msdn.microsoft.com/en-us/library/ms176061.aspx[/url]This clearly defines the options.[/quote]That is indeed a very clear reference. Thanks!Wed, 28 Mar 2012 03:01:07 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxI kind of assumed the 'other' was a simple typo - the better reference I think is just to CREATE DATABASE:[url=http://msdn.microsoft.com/en-us/library/ms176061.aspx]http://msdn.microsoft.com/en-us/library/ms176061.aspx[/url]This clearly defines the options.Wed, 28 Mar 2012 02:47:23 GMTcall.copsehttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGreat to see questions on 2012 now, but also have to ask what is up with the "other" in the question?Wed, 28 Mar 2012 02:34:32 GMTMichael Riemerhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxBit of a strange question.Two days running I've guessed.Two days running I've guessed incorrectly.Aarggh!Wed, 28 Mar 2012 01:55:30 GMTpaul s-306273http://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxNew features are welcome!But, I get it wrong!:-PWed, 28 Mar 2012 00:56:31 GMTCarlo Romagnanohttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGood 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-containedSo 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 :-DWed, 28 Mar 2012 00:39:41 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxGood question - but what's up with the word "other" in the question?Wed, 28 Mar 2012 00:32:05 GMTHugo Kornelishttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxHi Steve, Question on SQL 2012. I guessed and guessed it wrong. Good. to knew about contained databases.--BabuTue, 27 Mar 2012 23:20:03 GMTbaabhuhttp://www.sqlservercentral.com/Forums/Topic1274035-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/SQL+Server+2012/89248/">Contained Databases</A>[/B]Tue, 27 Mar 2012 21:51:18 GMTSteve Jones - SSC Editor