Msdn,en-US© 2009 Microsoft Corporation. All rights reserved.Wed, 25 Nov 2009 03:48:31 ZMsdnen-UShttp://social.msdn.microsoft.com/Forums/en-US/setupprerelease/thread/c7e6606c-2c83-461c-8ee1-80e1a81a21achttp://social.msdn.microsoft.com/Forums/en-US/setupprerelease/thread/c7e6606c-2c83-461c-8ee1-80e1a81a21acAuburghttp://social.msdn.microsoft.com/Profile/en-US/?user=AuburgIs there a release date for VS2010 beta 2 ?Wed, 09 Sep 2009 10:49:05 Z2009-10-22T05:32:31Zhttp://social.msdn.microsoft.com/Forums/en-US/reportabug/thread/3566e81e-ec4f-43b7-9234-0d5435bf3f13http://social.msdn.microsoft.com/Forums/en-US/reportabug/thread/3566e81e-ec4f-43b7-9234-0d5435bf3f13Sudeep Rajhttp://social.msdn.microsoft.com/Profile/en-US/?user=Sudeep%20RajHi,<br/>After the last upgrade why is it that only the Moderators of a forum shown in the top answerers??<br/>Is it that you donot want others to answer the questions and be recognized??<br/>I am an active member of SSIS forum and I dont see any one other than the moderators in the list??<br/><br/>I donot understand the reason for this.. is it intended or an error?<br/><br/>If its intended I would like to know the reason behind this................<hr class="sig">Hope this helps !! Please close the threads once answered - SudeepMon, 31 Aug 2009 09:15:13 Z2009-09-28T16:22:24Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/c7d0a234-763b-4f9c-b7ec-3a40df6340a8http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/c7d0a234-763b-4f9c-b7ec-3a40df6340a8FOCUSGuyhttp://social.msdn.microsoft.com/Profile/en-US/?user=FOCUSGuy<p>When I booted my XP SP3 machine Tuesday night (10/13), the many MS updates loaded.&nbsp; <br /><br />I then let them all install.&nbsp;</p> <p>All updates installed except for one.&nbsp; <br /><br />I am getting the following message, for KB970892:</p> <pre>The following updates were not installed. Security Update for SQL Server 2005 Service Pack 3 (KB970892)</pre> <p>I am running SQL Server Express 2005:</p> <pre>Microsoft SQL Server Management Studio Express 9.00.4035.00 Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.11 Microsoft .NET Framework 2.0.50727.3603 Operating System 5.1.2600</pre> <p><br /><br /><br /></p>Fri, 16 Oct 2009 02:17:36 Z2009-11-23T07:14:52Zhttp://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/bad23a21-2009-46ad-b4d8-1c4fcd796050http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/bad23a21-2009-46ad-b4d8-1c4fcd796050nodakhttp://social.msdn.microsoft.com/Profile/en-US/?user=nodakSQL update will not install KB970892 error code&nbsp;0x663. Now I can not open any of my programs that need sql. I have been on hold with microsoft on and off for two hours now. ANY HELPThu, 15 Oct 2009 16:08:33 Z2009-11-25T02:48:00Zhttp://social.msdn.microsoft.com/Forums/en-US/linqtosqlprerelease/thread/43249c18-6e4c-4afe-921a-59527905cf77http://social.msdn.microsoft.com/Forums/en-US/linqtosqlprerelease/thread/43249c18-6e4c-4afe-921a-59527905cf77kainharthttp://social.msdn.microsoft.com/Profile/en-US/?user=kainhartThere is a known issue with Union and Concat in LINQ to SQL where the use of the same constant value more than once will not produce the expected projection and cause the underlying SQL UNION command to fail. This has been explained as a consequence of early optimization by the query provider and according to <a href="http://social.msdn.microsoft.com/Forums/en-US/linqtosql/thread/3de28327-c8f9-4ef7-b690-64b22c66d3be">Damien Gaurd's thoughtful post</a> this is supposed to be addressed in LINQ to SQL within .NET 4.0. Unfortunately this has been contradicted on <a href="https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=355734">this post</a> (ID#355734) on the Microsoft Connect site where a member of the LINQ to SQL team reported &quot;we will not be fixing this in the next release of LINQ to SQL&quot;.<br/> <br/> Can we get some kind of confirmation on whether this will be addressed in .NET 4.0 and what time frame we are looking at until we will see it come through in public beta's or release candidates?<br/> <br/> My only workaround at this point is to use a let statement for every constant that I introduce into my projection for the sake of making my projections similar so that Union and Concat work. Now that I have more than 100 let statements in a particular query I have a feeling that this is contributing to other this other<a href="http://social.msdn.microsoft.com/Forums/en-US/linqtosql/thread/86cd891a-e25a-46b0-92d2-bf88f5c75a35"> scary TypeLoadException issue</a> that I have just recently began to run into. At this point this bug is affecting my ability to design what is otherwise an elegant data access layer.<br/> <br/>Thu, 10 Sep 2009 16:59:17 Z2009-10-07T23:57:41Z