InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 15:03:42 GMT20http://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxthanks for the ¿Mon, 29 Aug 2011 10:35:35 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxAdded a note to the answer to specify encrypted databases. It's not necessarily wrong, but it makes the question better, I think.Mon, 29 Aug 2011 10:15:03 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxNice easy Monday question. :-PMon, 29 Aug 2011 08:57:14 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxI checked this view on an instance without any encrypted databases as well and got no results back. I suppose that a better answer choice might have been that it "displays the encryption status of all encrypted databases on an instance." I think the answer was still easy enough to deduce from the choices given though.Mon, 29 Aug 2011 08:40:41 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxGood question but I don't really agree that it displays "The encryption state of all databases on the instance". This view does not have a record for a database that does not have a key. I have an instance with no encryption and the view returns no results. I suppose the argument could be that a database not displayed does indicate the encryption state as non existent.Mon, 29 Aug 2011 08:17:25 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxPlausibility is completely relative.Mon, 29 Aug 2011 08:03:15 GMTDavid Harderhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspx[quote][b]stewartc-708166 (8/29/2011)[/b][hr]Interesting question, with some plausable wrong answersThanks, Steve[/quote]Yes interesting. But are any of the wrong answers actually plausible? Each of them says in effect that any-one with VWSS permission can get hold of actual keys to databases, which seems pretty implausible.Mon, 29 Aug 2011 07:22:28 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxI got a chart at a SQLSaturday that lists all the DMVs and their purpose. Looking at it regularly has really helped me with questions like this. Thanks,Mon, 29 Aug 2011 07:12:35 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxNice question. Thanks.MattMon, 29 Aug 2011 06:17:05 GMTMattrickhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxThanks for the question even though nothing is stored within a view. It is display only in this case.Mon, 29 Aug 2011 05:49:12 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxgood question!Mon, 29 Aug 2011 05:36:11 GMTrfr.ferrarihttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxGreat question, thanks!Mon, 29 Aug 2011 04:27:20 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspx[b]N i c e Q u e s t i o n[/b]Mon, 29 Aug 2011 03:09:36 GMTSree Arjun Divhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxNice Question. Thanks.:-)Mon, 29 Aug 2011 03:01:32 GMTKameswari Aravindhhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxInteresting question, with some plausable wrong answersThanks, SteveMon, 29 Aug 2011 00:41:10 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxThanks for the question.Sun, 28 Aug 2011 21:31:39 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxQuestion is nice but framed incorrectly. since it's a view, It doesn't store.The concept is good.Sun, 28 Aug 2011 01:48:37 GMTCoolCodeSharehttp://www.sqlservercentral.com/Forums/Topic1166659-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Administration/73598/">Database encryption</A>[/B]Sun, 28 Aug 2011 01:13:22 GMTSteve Jones - SSC Editor