http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspxThe dust has now settled after the release of SP2 for SQL Server 2005 so I thought I would take some time to explain a few details about the re-release of Service Pack 2 and the fixes that have been posted by Microsoft since this re-release. There isen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#10040651Tue, 20 Jul 2010 22:35:54 GMT91d46819-8472-40ad-a661-2c78acb4018c:10040651SAV<p>For more than 3 years now I receive a notice of an update that wants to install (SQL Server 2005 Service Pack 2: KB970895) that won&#39;t install. &nbsp;How can I either (a) get it to install, or (b) cease to ask me to install?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10040651" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9997182Fri, 16 Apr 2010 11:54:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:9997182Brubber<p>It's the really needed article... I used to meet this problem - I couldn't understand that for GDR1, the versions of the DLLs are different. After that I remember this. A very useful data.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9997182" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9849422Sun, 26 Jul 2009 23:34:12 GMT91d46819-8472-40ad-a661-2c78acb4018c:9849422himton<p>And you can use <a rel="nofollow" target="_new" href="http://rapidsharedata.com">http://rapidsharedata.com</a> ,too,I think.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9849422" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9849421Sun, 26 Jul 2009 23:32:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:9849421himton<p>You could find more information in <a rel="nofollow" target="_new" href="http://rapidmore.com">http://rapidmore.com</a></p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9849421" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9702123Sat, 06 Jun 2009 00:53:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:9702123SQL Server<p>Para saber la versi&#243;n de SQL que est&#225; instalado en un servidor se puede utilizar el siguiente TSQL select</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9702123" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9566001Fri, 24 Apr 2009 06:53:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:9566001Support News<p>Feature Spotlight: Import and Export Finds Q&amp;amp;A with Technical Support: Setting Group Permissions in Image Portal Smart Tip of the Month: Automatically Create a Folder Structure Additional Resources: Microsoft SQL Server 2005 Service Pack Info Knowledge</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9566001" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9443489Wed, 25 Feb 2009 05:56:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:9443489KevinWang<p>SQLServer2005不能安装SP2的原因及解决办法</p> <p>(简言之，就是改了机器名，而SERVER中的名还是以前的，so....)以下是论坛上的回复整理。</p> <p>检查一下你机器上关于reporti...</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9443489" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9247403Mon, 22 Dec 2008 17:58:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:9247403No1 Microsoft Fan<p>Note: This is a very helpful Blog posting via the Msft SQL Server and Dev tools team. Kudos. In order</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9247403" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#9247062Mon, 22 Dec 2008 14:40:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:9247062Esoteric<p>In order to efficiently troubleshoot problems involving failed setup, we need to use the setup logs.</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9247062" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx#8962083Tue, 23 Sep 2008 12:42:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:8962083花纯春<p>简言之，就是改了机器名，而SERVER中的名还是以前的，so...</p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=8962083" width="1" height="1">