InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:57:25 GMT20http://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspx1 point and really 50% chance to get itit's well paidTue, 19 Feb 2013 08:34:49 GMTjfgoudehttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxGood One!Tue, 15 Jan 2013 13:40:05 GMTasifkareemhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxI too would have liked an explanation for the purpose of "FOR BROWSE" in relation to that DMV.At the moment the new "knowledge" about this DMV is useless, without knowing when to use it an for what purpose.Thu, 10 Jan 2013 01:35:11 GMTChristian Buettner-167247http://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxThanks for the 2012 question. I'm not sure why you would use the browse flag or not though.Wed, 02 Jan 2013 17:33:00 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxSince i don't have 2012 i'm unable to test it.. But got it correctly by referring Pinal dave's blog. Pls tell me usage of this view.Wed, 02 Jan 2013 03:12:46 GMTDineshbabuhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxGreat question. Got to know about this DMV from this question. Got just 1 point but it was worth.Mon, 31 Dec 2012 03:16:04 GMTsqlnaivehttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxThanks for the question..Sun, 30 Dec 2012 19:07:37 GMTpchiragshttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxFine learning... thank you for the question. (this is completely new for me) :-)Sat, 29 Dec 2012 00:05:02 GMTRaghavendra Mudugalhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxThis is a straight-forward enough QOD, I suppose. But I do wonder what the point is of having the "Include_browse_information" switch to begin with. Why would MS think it necessary to provide a control for whether those five columns are populated in the results?Fri, 28 Dec 2012 15:52:59 GMTjohn.arnotthttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxNice easy question.The explanation is a bit sparse though, as Koen said.Fri, 28 Dec 2012 13:40:52 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxThanks for the question.Fri, 28 Dec 2012 09:54:54 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxNice question with a good use of the new 2012 Adventure Works database.Fri, 28 Dec 2012 08:35:53 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspx[quote][b]bitbucket-25253 (12/28/2012)[/b][hr][quote][b]Koen Verbeeck (12/27/2012)[/b][hr]Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about :-)[/quote]I thought the explanation provided was sufficient, for after all it says:....[/quote][/quote]Ron your explination only says: [quote]This dynamic management function takes an @object_id as a parameter and describes the first result metadata for the module with that ID.[/quote]The Linked MSDN article has the text you quoted, not your explination..... :-PFri, 28 Dec 2012 08:34:51 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspx[quote][b]Koen Verbeeck (12/27/2012)[/b][hr]Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about :-)[/quote]+1Fri, 28 Dec 2012 08:30:20 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspx[quote][b]Koen Verbeeck (12/27/2012)[/b][hr]Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about :-)[/quote]I thought the explanation provided was sufficient, for after all it says:[quote]@include_browse_information@include_browse_information is type bit. If set to 1, each query is analyzed as if it has a FOR BROWSE option on the query. Returns additional key columns and source table information.[/quote]Fri, 28 Dec 2012 06:07:29 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxVery interesting, Ron. ThanksFri, 28 Dec 2012 05:17:14 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspx[quote][b]Koen Verbeeck (12/27/2012)[/b][hr]Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about :-)[/quote]+1Fri, 28 Dec 2012 01:18:11 GMTCarlo Romagnanohttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxNice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about :-)Thu, 27 Dec 2012 23:19:44 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxThanks Ron for another one on SS-2012. Keep them pouring :-)Thu, 27 Dec 2012 22:16:28 GMTLokesh Vijhttp://www.sqlservercentral.com/Forums/Topic1400788-1222-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/95547/">TSQL 2012 #1</A>[/B]Thu, 27 Dec 2012 22:03:52 GMTbitbucket-25253