Article ID: 313980
Article Last Modified on 7/13/2004
APPLIES TO
- Microsoft SQL Server 7.0 Service Pack 4
- Microsoft SQL Server 7.0 Service Pack 1
- Microsoft SQL Server 7.0 Service Pack 2
- Microsoft SQL Server 7.0 Service Pack 3
This article was previously published under Q313980
SUMMARY
This article provides information about the bugs fixed by SQL Server 7.0 service packs. Because service packs are cumulative, subsequent service packs also fix the bugs fixed by previous service packs. For example, SQL Server 7.0 Service Pack 4 (SP4) has the bug fixes from SQL Server 7.0 Service Pack 3 (SP3), Service Pack 2 (SP2), and Service Pack 1 (SP1).
For additional information about obtaining SQL Server 7.0 service packs, click the article number below to view the article in the Microsoft Knowledge Base:
301511 INF: How to Obtain the Latest SQL Server 7.0 Service Pack
MORE INFORMATION
SQL Server 7.0 Service Pack 4
239473 FIX: 70rebind.exe for Windows 2000 and MDAC Upgrades on Clustered SQL Server 7.0 Servers
249730 FIX: SQL Server 7.0 T-SQL Scheduled Task May Take Longer to Run Than SQL Server 6.5 Task
260182 FIX: Unable to Restore to a Point in Time in First Transaction Log Backup
276281 FIX: Replication Logreader Fails with Error Message 18773
280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures
281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result
282243 FIX: Incorrect Results with Join of Column Converted to Binary
283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled
284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3
285870 FIX: Update With Self Join May Update Incorrect Number Of Rows
286788 FIX: Server Side Cursor May Return Incorrect Results
288426 FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled
290629 FIX: Update Query That Uses Star Joins May Cause Access Violation
291561 FIX: Invalid Float Data May Lead to Floating Point Exception and Incorrect Stored Values
293279 FIX: Linked Server SELECT COUNT(*) Sent as SELECT COUNT((0))
293636 FIX: Invoking SQL-DMO Methods By Using "By Reference" Parameters May Cause a Memory Leak
293758 FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2
294753 FIX: SQL Server 7.0 Readme Files Do Not Document Installation Warning
295378 FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of the Schedule for the Day
296189 FIX: DBCC SHOW_STATISTICS Truncates Output for Fixed-Length Numeric Types
296456 FIX: Full Text Query May Return 0 Rows When Valid Results are Present
297271 FIX: Point in Time Recovery May Recover Database if the Transaction Log That is Applied Does Not Contain Any Transactions
298643 FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values
298832 FIX: Uppercase Characters are not Sorted Before Their Corresponding Lowercase Characters When You Use the Nocasepref Sort Order
299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have
299950 FIX: Bad Cardinality Estimate Results in Sub Optimal Join Strategy
300258 FIX: INSERT EXEC of Extended Stored Procedure Incorrectly Inserts Empty String Instead of NULL
300519 FIX: Problems Occur When Connecting to SQL Server from ADO Application
302615 FIX: Incorrect Cardinality Estimate And Bad Plan for Query with OR and AND on Same Column
302664 FIX: Query with SET NO_BROWSETABLE Option Set ON May Generate Access Violation
302828 FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell
303344 FIX: Exception Access Violation Encountered in CONSTANT::CONSTANT
303727 FIX: Cancelling Parallel Query May Abort Transaction
304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers
307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory
307541 FIX: Error 1203 and Failed Assertion Occurs When You Run a Query with a Parallel Plan
308016 FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000
308114 FIX: Query with Multiple Predicates and a Star Join May Cause an Access Violation
308126 FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented
308267 BUG: DTS Copy Objects Task (DMO) Breaks Transaction Log Backup Chain By Switching Recovery Mode to Simple During Transfer
308627 FIX: DBCC SHRINKDATABASE or DBCC SHRINKFILE May Expand Database with Text or Image Data
308881 FIX: AV on DECLARE CURSOR with Correlated Subquery and KEYSET or DYNAMIC Cursor Type
310572 FIX: Cursor Type and Column Updatability May Change with Some Sort Orders
311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128
312537 FIX: SQL Server Stops Unexpectedly During Restore
313247 FIX: Existing Users Lose Connectivity If Error Message 17836 Occurs
313661 FIX: Error Message: "Timeout expired" Occurs When You Connect to SQL Server Over TCP/IP and the Kerberos MaxTokenSize is Greater Than 0xFFFF
314117 FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr
314971 FIX: Backup of Multi-File Database to Striped Media May Encounter CPU Spin
315938 FIX: SELECT That References Several Tables May Return Invalid TDS Error or Cause Client Application to Stop Responding
316004 FIX: Floating Point Underflow Exception Causes Bad Cardinality Estimate
316976 FIX: Tuning Wizard May Fail When You Specify a Workload File for Non-dbo Owned Objects
317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source
318053 FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation
318171 FIX: Binding a Variable to More Than One Output Parameter May Cause an Access Violation
318733 FIX: SQL Server May Become Unresponsive When a Large Number of Databases and Roles are Used
319357 FIX: DBCC CHECKALLOC Enhanced to Detect Allocation Inconsistencies
319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers
319690 FIX: Sqldiag.exe Cannot Generate the Winmsd Report on Windows 2000 for the Sqldiag.txt File
319691 FIX: Merge Subscriptions May Reinitialize Unexpectedly If Incremental Schema Change Fails
319693 FIX: A Backup Log with the NO_TRUNCATE Option May Cause an Access Violation
319694 FIX: Uppercase Characters Are Not Sorted Before Lowercase Characters with the Nocasepref Sort Order
319697 FIX: SQL Enterprise Manager Restore to Point in Time Does Not Stop at Requested Time and the Database is Left in a Loading State
319698 FIX: Transform Data Task Might Stop Responding (hang) While Importing Data From Text File
319699 FIX: @@IDENTITY Does Not Process a New Value When You Use INSERT EXEC
319701 FIX: SQL Enterprise Manager RESTORE Msdb Leaves Database in Loading State and Does Not Apply Differential or Log Backups
319704 FIX: Application Error May Occur in Index Tuning Wizard with a Query That Uses Full Text Search Functions
320068 FIX: DTC May Experience a Spinloop That Causes SQL Server to Become Unresponsive
320406 FIX: Procedure Names That Begin with "sp_" Can Fail with an Access Violation
SQL Server 7.0 Service Pack 3
For additional information about the problems fixed by SQL Server 7.0 Service Pack 3, click the article number below to view the article in the Microsoft Knowledge Base:
274797 INF: SQL Server 7.0 Service Pack 3 Fixlist
SQL Server 7.0 Service Pack 2
For additional information about the problems fixed by SQL Server 7.0 Service Pack 2, click the article number below to view the article in the Microsoft Knowledge Base:
254369 INF: SQL Server 7.0 Service Pack 2 Fixlist
SQL Server 7.0 Service Pack 1
For additional information about the problems fixed by SQL Server 7.0 Service Pack 1, click the article number below to view the article in the Microsoft Knowledge Base:
225019 INF: SQL Server 7.0 Service Pack 1 Fixlist
Comments about this or other Microsoft Knowledgebase articles? Drop us a note at SQLKB@Microsoft.com
Additional query words: kbSQLServ700sp4fixlist kbSQLServ700sp3fixlist kbSQLServ700sp2fixlist kbSQLServ700sp1fixlist
Keywords: kbinfo KB313980
