Small Business Susan

SQL sp2 fix up info

PSS SQL Server Engineers : SQL Server 2005 Service Pack 2 (SP2) Re-release and post fixes explained:
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx


I don’t have SQL Server 2005 SP2 yet


  1. Apply SP2 from http://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
  2. Apply GDR2 from http://support.microsoft.com/?kbid=934458 (Microsoft Update will also notify you of this after you applied SP2)
  3. You will now be on version 9.00.3054

I installed SP2 but don’t know if I applied this before March 5th


  1. Don’t worry about checking when you applied SP2, just go right to GDR2 at http://support.microsoft.com/?kbid=934458 (Microsoft Update may have already notified you)
  2. You will now be on version 9.00.3054

I have applied SP2 and the GDR1 fix


  1. You should have a version of 9.00.3050
  2. If you do, then apply GDR2 at http://support.microsoft.com/?kbid=934458 (Microsoft Update will also notify you of this)
  3. You will now be on version 9.00.3054

I haven’t installed SQL 2005 SP2 so I’m up at that top one.