Service Pack 2 for SQL Server 7.0

By Bill Graziano on 9 September 2000 | Tags: Installation

---

We've had a couple of questions about bugs that are resolved by one of the SQL Server service packs. What follows is a brief discussion of SQL Server Service Pack 2 (say that five times fast).

The most common question asked here seems to be "CoInitialize not called". Syl just asked about this earlier. MMC will often report this when trying to open Database Diagrams. It's fixed in the service packs. Also most DTS and OLAP problems are fixed by the latest service pack.

Swynk.com has an article about Service Pack 2 and another about the few minor bugs in service pack 2. Overall, the fixes far outweigh the headaches.

If you haven't already, I'd strongly encourage you to download service pack 2 and install it. It's been out since about March and has proven itself very stable.

Comment from SQLGuru - SQL Server service packs should not only be installed on the server, but your workstation as well. Otherwise, you'll miss out on important bugfixes to the administrative tools.

Related Articles Notes from an Upgrade to SQL Server 2005 (26 February 2007) Migrating from Oracle to SQL Server (29 September 2002) Upgrading from SQL Server 7 to 2000 (Part 2) (29 May 2002) Upgrading from SQL 7 to SQL 2000 (Part 1) (5 May 2002) Can I install SQL Server on Windows 98? (29 July 2000)

Other Recent Forum Posts Pawan Cash loan customer care helpline Number-91 real☎️ 8274004829+($)8274004829 call sjjs js (14m) Pawan Cash loan customer care helpline Number-91 real☎️ 8274004829+($)8274004829 call jshd (15m) Pawan Cash loan customer care helpline Number-91 real☎️ 8274004829+($)8274004829 call (17m) CC Credit Loan App Customer Care Helpline Number + 91)((+8274004829-))℅+/{+8274004829+} Call (19m) CC Credit Loan App Customer Care Helpline Number + 91)((+8274004829-))℅+/{+8274004829+} Call suuey (20m) CC Credit Loan App Customer Care Helpline Number + 91)((+8274004829-))℅+/{+8274004829+} Call (21m) IndWin7 Game CusTomer Care Helpline Number:comet: +91 Rea:📠:l/9264922753call//8653890396Tollfree (23m) IndWin7 Game CusTomer Care Helpline Number:comet: +91 Rea:📠:l/9264922753call//8653890396Tollfree (25m)