Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.

Microsoft SQL Server 7.0 Builds

The following table lists all builds of SQL Server 7.0 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

Codename RTM SP1 SP2 SP3 SP4
Codename Sphinx 7.00.623 7.00.699 7.00.842 7.00.961 7.00.1063

Microsoft SQL Server 7.0 Builds Breakdown:

Build KB / Description Release Date
7.00.1152 948113 MS08-040: Description of the security update for SQL Server 7.0: July 8, 2008 May 9, 2012
7.00.1149 867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0 June 1, 2006
7.00.1143 830233 New Connection Events Are Not Recorded in SQL Server Traces October 25, 2005
7.00.1143 829015 FIX: An attention signal that is sent from a SQL Server client application because of a query time-out may cause the SQL Server service to quit unexpectedly October 25, 2005
7.00.1097 822756 A Complex UPDATE Statement That Uses an Index Spool Operation May Cause an Assertion October 25, 2005
7.00.1094 821279 MS03-031: Security patch for SQL Server 7.0 Service Pack 4 May 11, 2006
7.00.1094 815495 MS03-031: Cumulative security patch for SQL Server May 10, 2006
7.00.1092 820788 FIX: Delayed domain authentication may cause SQL Server to stop responding October 25, 2005
7.00.1087 814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation September 27, 2005
7.00.1079 329499 FIX: Replication Removed from Database After Restore WITH RECOVERY October 11, 2005
7.00.1078 327068 INF: SQL Server 7.0 Security Update for Service Pack 4 September 27, 2005
7.00.1077 316333 SQL Server 2000 Security Update for Service Pack 2 November 24, 2006
7.00.1063 SQL Server 7.0 Service Pack 4 (SP4)
7.00.1033 324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactions October 12, 2005
7.00.1026 319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED October 18, 2005
7.00.1004 304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers August 5, 2004
7.00.996 299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have August 9, 2004
7.00.978 285870 FIX: Update With Self Join May Update Incorrect Number Of Rows October 28, 2003
7.00.977 284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3 April 25, 2002
7.00.970 283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled October 15, 2002
7.00.970 282243 FIX: Incorrect Results with Join of Column Converted to Binary October 29, 2003
7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
7.00.921 283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled October 15, 2002
7.00.919 282243 FIX: Incorrect Results with Join of Column Converted to Binary October 29, 2003
7.00.918 280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures June 29, 2004
7.00.917 279180 FIX: Bcp.exe with Long Query String Can Result in Assertion Failure September 26, 2005
7.00.910 275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221 October 31, 2003
7.00.905 274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624 July 15, 2004
7.00.889 243741 FIX: Replication Initialize Method Causes Handle Leak on Failure October 5, 2005
7.00.879 281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349 March 14, 2006
7.00.857 260346 FIX: Transactional Publications with a Filter on Numeric Columns Fail to Replicate Data March 14, 2006
7.00.843 266766 FIX: Temporary Stored Procedures in SA Owned Databases May Bypass Permission Checks When You Run Stored Procedures March 14, 2006
7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
7.00.839 SQL Server 7.0 Service Pack 2 (SP2) Unidentified
7.00.835 SQL Server 7.0 Service Pack 2 (SP2) Beta
7.00.776 258087 FIX: Non-Admin User That Executes Batch While Server Shuts Down May Encounter Retail Assertion March 14, 2006
7.00.770 252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table March 14, 2006
7.00.745 253738 FIX: SQL Server Components that Access the Registry in a Cluster Environment May Cause a Memory Leak October 7, 2005
7.00.722 239458 FIX: Replication: Problems Mapping Characters to DB2 OLEDB Subscribers October 5, 2005
7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
7.00.689 SQL Server 7.0 Service Pack 1 (SP1) Beta
7.00.677 SQL Server 7.0 MSDE from Office 2000 disc
7.00.662 232707 FIX: Query with Complex View Hierarchy May Be Slow to Compile October 5, 2005
7.00.658 244763 FIX: Access Violation Under High Cursor Stress March 14, 2006
7.00.657 229875 FIX: Unable to Perform Automated Installation of SQL 7.0 Using File Images October 5, 2005
7.00.643 220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special Characters October 5, 2005
7.00.623 SQL Server 7.0 RTM
7.00.583 7.0 RC1
7.00.517 7.0 Beta 3

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 7.0, and SP stands for service pack. All SQL Server service packs and hot-fixes are cumulative, meaning that each new service pack and hot-fixes contains all the fixes that are included with previous service packs, hot-fixes and new fixes issues.

Please use comment section, if you find build that is not listed here.


Comments

Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...