SQL Server 7.0 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 7.0 that have been released in October 2013. The list is daily updated.

867763 FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0 Q867763 KB867763 October 26, 2013
842192 How to install SQL Server 7.0 Enterprise Edition on Microsoft Cluster Server Q842192 KB842192 October 26, 2013
818671 PRB: Access Violation Exception Occurs When Optimized Query Plan Uses Hash Match Team Operator Q818671 KB818671 October 26, 2013
816759 FIX: SqlClient Throws "Timeout Expired" with Extended Stored Procedure Q816759 KB816759 October 26, 2013
815063 PRB: Error 1927: "There Are Already Statistics on Table <Table_Name> Named <Statistics_Name>" Q815063 KB815063 October 26, 2013
814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation Q814693 KB814693 October 26, 2013
814578 PRB: OLE Automation Error Occurs When SQL Server Runs a Stored Procedure Q814578 KB814578 October 26, 2013
811953 FIX: SQL Server Thread Goes into an Infinite Loop When it Runs Sp_MSdbuseraccess Q811953 KB811953 October 26, 2013
811906 PRB: The "Use Encryption for Data" Property Is Not Recognized When You Run a DTS Package on a Computer with MDAC 2.5 or Earlier Q811906 KB811906 October 26, 2013
327424 PRB: An Access Violation Occurs If the Sqlsort.dll Version Is Not Compatible with the SQL Server Version Q327424 KB327424 October 26, 2013
324122 BUG: BULK INSERT Fails with Error Message 7399 Q324122 KB324122 October 26, 2013
320068 FIX: DTC May Experience a Spinloop That Causes SQL Server to Become Unresponsive Q320068 KB320068 October 26, 2013
319493 FIX: SQL Server Stops Processing Results After First Error From Linked Server Q319493 KB319493 October 26, 2013
316203 BUG: INSERT of RESTORE HEADERONLY Results into Temp Table May Generate an Access Violation Q316203 KB316203 October 26, 2013
315005 PRB: SQL Server Agent Job Fails with Error Message "...Driver's SQLSetConnectAttr failed..." Q315005 KB315005 October 26, 2013
313247 FIX: Existing Users Lose Connectivity If Error Message 17836 Occurs Q313247 KB313247 October 26, 2013
310822 BUG: Xp_sendmail with @Query Parameter on a Cluster Generates Error 17969 Q310822 KB310822 October 26, 2013
310631 PRB: Error 2757 If Table Has More Than 254 Columns in a Publication Q310631 KB310631 October 26, 2013
295939 BUG: sp_OAMethod May Cause Access Violation When @@servername Is NULL Q295939 KB295939 October 26, 2013
291961 PRB: Debugging Stored Procedure Fails with "Cannot load the DLL mssdi98.dll, or one of the DLLs it references" Error Message Q291961 KB291961 October 26, 2013
284938 BUG: Ghosted Record Cleanup Process May Go Into CPU Spin Due to an Invalid Check for Cleanup Type Q284938 KB284938 October 26, 2013
280872 FIX: SQL Server 7.0 Microsoft Search Fails to Start With Error 1332 Q280872 KB280872 October 26, 2013
279697 FIX: Text Truncated in Replication Property Page with Japanese Locale Q279697 KB279697 October 26, 2013
278629 FIX: Merge Replication Agent Fails with "The merge process could not initialize the subscription" Error Message Q278629 KB278629 October 26, 2013
278371 FIX: Executing SQL Diagnostics During Connect/Disconnect Can Cause AV or Server Shutdown Q278371 KB278371 October 26, 2013
278366 FIX: Concurrent Shrink Operations Against Heaps Can Result in Errors 8968, 8905, and 8906 Q278366 KB278366 October 26, 2013
278353 FIX: Race Condition When Server Allocates Memory Can Cause Access Violation Q278353 KB278353 October 26, 2013
278021 FIX: Clearing "Enforce constraint for replication" Check Box for a CHECK Constraint Breaks Constraint Checking on All Nonreplication Operations Q278021 KB278021 October 26, 2013
277549 PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel Q277549 KB277549 October 26, 2013
276303 FIX: Fatal Exception "EXCEPTION_FLT_OVERFLOW" Occurs During Query Optimization Q276303 KB276303 October 26, 2013
275661 FIX: Error Message 6107 Occurs with Transact-SQL KILL Command After Pooled Connection is Reset Q275661 KB275661 October 26, 2013
274762 BUG: DTSRUN Fails to Run Package Stored in Repository on Secondary Node of Cluster Q274762 KB274762 October 26, 2013
274030 BUG: Outer Joins with Many Tables May Cause 701 Error Message "..Insufficient System Memory ..." Q274030 KB274030 October 26, 2013
273472 FIX: Enterprise Manager Returns Unexpected Error on Table or View Q273472 KB273472 October 26, 2013
267599 FIX: Running a Stored Procedure While SET FMTONLY is Off and On Can Cause 602, 604 and 618 Error Messages Q267599 KB267599 October 26, 2013
264170 FIX: Immediate Updating Subscribers Receive Error Message 7415 When Performing UPDATES and INSERTS Q264170 KB264170 October 26, 2013
262699 FIX: User Logged Into DB in Single User Mode May Encounter 924 Error Q262699 KB262699 October 26, 2013
259021 FIX: Parallel Hash Join with Empty Result Set Incorrectly Flows Error Back on Client Connection Q259021 KB259021 October 26, 2013
256052 FIX: Sqlservr.exe Non-Trusted Connection Through OPENROWSET Allows Access to Service Account Q256052 KB256052 October 26, 2013
255097 BUG: Error 7356 from a Distributed Query Q255097 KB255097 October 26, 2013
254598 BUG: Index Cannot be Dropped if the Name Begins with "#" Character Q254598 KB254598 October 26, 2013
254555 Readme.txt for SQL Server 7.0 Service Pack 2 Q254555 KB254555 October 26, 2013
252865 FIX: Replay of Prepared Cursor Statements May Generate Error 16902 Q252865 KB252865 October 26, 2013
248999 INF: Readme.txt for SQL Server 7.0 SP2 Beta Q248999 KB248999 October 26, 2013
248798 FIX: Restore Filegroup Allowed After Truncating the Transaction Log Q248798 KB248798 October 26, 2013
248749 FIX: Possible Denial of Service Attack with Appropriate NULL Bytes in TDS Header Q248749 KB248749 October 26, 2013
247974 FIX: Perfmon Errors Logged in Event Log when SQL Server Not Running Q247974 KB247974 October 26, 2013
247751 BUG: Database Maintenance Plan Does Not Shrink the Database Q247751 KB247751 October 26, 2013
247181 FIX: SQLMaint.exe -CkDBRepair Option Does Not Work Correctly Q247181 KB247181 October 26, 2013
247052 FIX: DTS Package Creator/Owner Name Does Not Change When Another User Saves a New Package Q247052 KB247052 October 26, 2013
246775 FIX: Error 7102 with Keyset-Driven Cursors on Table with Text Column Q246775 KB246775 October 26, 2013
246694 PRB: Setup on Windows 2000 Fails Through Terminal Client Q246694 KB246694 October 26, 2013
246607 FIX: ODS Function Srv_describe May Fail on Certain Type Conversions Q246607 KB246607 October 26, 2013
246328 PRB: SQL performance counters may be missing after MDAC installation on a cluster Q246328 KB246328 October 26, 2013
246323 FIX: Check Constraint Is Not Enforced if Marked "Not for Replication" Q246323 KB246323 October 26, 2013
246199 BUG: Changed Locale Settings in Extended Stored Procedure May Cause Incorrect Results Q246199 KB246199 October 26, 2013
245631 FIX: Error Message "8624 - Internal SQL Server Error" Q245631 KB245631 October 26, 2013
244549 FIX: SELECT Query Involving Bit Datatype Slower on SQL 7.0 than SQL 6.5 Q244549 KB244549 October 26, 2013
243377 FIX: Merge System Tables not Dropped When Restoring Merge-Published DB Over Non-published DB Across Servers Q243377 KB243377 October 26, 2013
243302 FIX: Deletion May Inappropriately Fill the Transaction Log Q243302 KB243302 October 26, 2013
240798 FIX: Insert from Linked-Server Into Table with BIT Field Having a DEFAULT Constraint Causes AV Q240798 KB240798 October 26, 2013
240688 PRB: Replication Subscribers Unable to Synchronize with Pull Subscription Q240688 KB240688 October 26, 2013
240356 BUG: SQLOLEDB Treats AutoTranslate, UseProcForPrepare and WSID as Read-Only Q240356 KB240356 October 26, 2013
240290 FIX: Replication Error: 14262 Specified @job_id Not Found Q240290 KB240290 October 26, 2013
240039 FIX: DBCC OPENTRAN Does Not Report Replication Information Q240039 KB240039 October 26, 2013
239133 FIX: Errors Running Wizards Against Objects not Owned by DBO Q239133 KB239133 October 26, 2013
238238 FIX: ODS API srv_revert_to_self Does Not Revert Multi-Protocol Connections Q238238 KB238238 October 26, 2013
237303 INF: How to Upgrade SQL Server 7.0 Evaluation Edition to Retail Version Q237303 KB237303 October 26, 2013
236568 FIX: Error 644, 5180 Updating Text or Ntext Column with ISNULL Q236568 KB236568 October 26, 2013
234814 FIX: Merge Agent Fails During Synchronization of Rollup Subscriber Q234814 KB234814 October 26, 2013
234268 FIX: SQLDMO - .Login and .Password Properties are Ignored with .LoginSecure = FALSE Q234268 KB234268 October 26, 2013
234028 BUG: sp_articleview May Generate an Arithmetic Overflow Q234028 KB234028 October 26, 2013
233525 FIX: Mmc.exe Remains in the Task List After Closing the Console Window Q233525 KB233525 October 26, 2013
233338 PRB: Repl Logreader Fails on Remote Distributor after Cluster Failover Q233338 KB233338 October 26, 2013
232522 FIX: Error 16943 When Dropping Pull Subscription with 'ALL' as Parameter Value Q232522 KB232522 October 26, 2013
230258 INF: DTC Setup Changes Starting with SQL Server 6.5 SP5 and SQL Server 7.0 Q230258 KB230258 October 26, 2013
229608 BUG: SQL 7.0 Desktop Edition Install on Windows 98 Causes "Assertion Failed File: ..\SRC\SQLSSPI.C Line: 119" Q229608 KB229608 October 26, 2013
229052 BUG: SQL Enterprise Manager Generates SQL-DMO Error for DBO Updating Permissions Q229052 KB229052 October 26, 2013
225141 FIX: SELECT Statements With UNION May Cause Error 8618 Q225141 KB225141 October 26, 2013
224996 FIX: Access Violation Selecting Linked Table Q224996 KB224996 October 26, 2013
224162 FIX: Unhandled exception during upgrade when excluding database with 30-character name Q224162 KB224162 October 26, 2013
224157 FIX: Internal Error 998 Reported from Profiler Q224157 KB224157 October 26, 2013
221513 BUG: DTS - Error Creating File Mapping View Q221513 KB221513 October 26, 2013
220842 BUG: Error 924 When Cross-Database Query Run from Context of Database in Single User Mode Q220842 KB220842 October 26, 2013
218739 PRB: BACKUP with NO_TRUNCATE Not Possible with Missing Primary Data File Q218739 KB218739 October 26, 2013
216812 INF: Small Business Server 4.5 SQL Server 7.0 Limitations Q216812 KB216812 October 26, 2013
201760 BUG: Restore With STANDBY Option May Recover a Database Q201760 KB201760 October 26, 2013
200103 INF: SQL Server 7.0 Startup Parameters Q200103 KB200103 October 26, 2013
198473 INF: How to Run NetMon Based on a Specific Error Occurring Q198473 KB198473 October 26, 2013
197299 BUG: SELECT INTO with Fixed Memory May Cause Errors 802 and 17803 Q197299 KB197299 October 26, 2013
196790 FIX: BULK INSERT with BATCHSIZE Disregards LASTROW Parameter Q196790 KB196790 October 26, 2013
196658 INF: Differential Backup Time Considerations Q196658 KB196658 October 26, 2013
196629 BUG: DBCC MEMUSAGE Is Not Supported in SQL Server 7.0 Q196629 KB196629 October 26, 2013
195757 Frequently asked questions - SQL Server 7.0 - Replication Q195757 KB195757 October 26, 2013
170496 INF: Tips for Debugging Stored Procedures from Visual Basic Q170496 KB170496 October 26, 2013
163446 PRB: Guarantee @@IDENTITY Value on a Per Table Basis Q163446 KB163446 October 26, 2013
152134 PRB: XP_CMDSHELL Does Not Work with XCOPY Q152134 KB152134 October 26, 2013
110905 INF: Readpipe Return Codes Q110905 KB110905 October 26, 2013
80629 PRB: Transaction Log Partially Truncated Q80629 KB80629 October 26, 2013
275146 INF: Frequently Asked Questions - SQL Server 7.0 - Log Shipping Q275146 KB275146 October 25, 2013
320406 FIX: Procedure Names That Begin with "sp_" Can Fail with an Access Violation Q320406 KB320406 October 24, 2013
319704 FIX: Application Error May Occur in Index Tuning Wizard with a Query That Uses Full Text Search Functions Q319704 KB319704 October 24, 2013
319694 FIX: Uppercase Characters Are Not Sorted Before Lowercase Characters with the Nocasepref Sort Order Q319694 KB319694 October 24, 2013
319693 FIX: A Backup Log with the NO_TRUNCATE Option May Cause an Access Violation Q319693 KB319693 October 24, 2013
319357 FIX: DBCC CHECKALLOC Enhanced to Detect Allocation Inconsistencies Q319357 KB319357 October 24, 2013
318733 FIX: SQL Server May Become Unresponsive When a Large Number of Databases and Roles are Used Q318733 KB318733 October 24, 2013
318171 FIX: Binding a Variable to More Than One Output Parameter May Cause an Access Violation Q318171 KB318171 October 24, 2013
318053 FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation Q318053 KB318053 October 24, 2013
316004 FIX: Floating Point Underflow Exception Causes Bad Cardinality Estimate Q316004 KB316004 October 24, 2013
315938 FIX: SELECT That References Several Tables May Return Invalid TDS Error or Cause Client Application to Stop Responding Q315938 KB315938 October 24, 2013
314971 FIX: Backup of Multi-File Database to Striped Media May Encounter CPU Spin Q314971 KB314971 October 24, 2013
314117 FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr Q314117 KB314117 October 24, 2013
312537 FIX: SQL Server Stops Unexpectedly During Restore Q312537 KB312537 October 24, 2013
311313 FIX: ADO Returns No Resultset for Prepared Parameterized Query Involving CHAR Data with SQLOLEDB Q311313 KB311313 October 24, 2013
308126 FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented Q308126 KB308126 October 24, 2013
304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers Q304851 KB304851 October 24, 2013
303727 FIX: Cancelling Parallel Query May Abort Transaction Q303727 KB303727 October 24, 2013
303344 FIX: Exception Access Violation Encountered in CONSTANT::CONSTANT Q303344 KB303344 October 24, 2013
302615 FIX: Incorrect Cardinality Estimate And Bad Plan for Query with OR and AND on Same Column Q302615 KB302615 October 24, 2013
301964 Cluster Service Receives Error 1024 with SNMP Installed with SQL Server 7.0 Q301964 KB301964 October 24, 2013
301383 BUG: DTS May Return a Success Even When it Fails to Transfer Data Q301383 KB301383 October 24, 2013
301382 BUG: DTS May Transfer the Unnecessary Lead Byte of a Double-Byte Character Q301382 KB301382 October 24, 2013
300959 BUG: Duplicate Rows Inserted by BCP into a Table That Has a Unique Nonclustered Index Q300959 KB300959 October 24, 2013
245685 Errors linking SQL Server 7.0 table that has spaces in table name Q245685 KB245685 October 24, 2013
300258 FIX: INSERT EXEC of Extended Stored Procedure Incorrectly Inserts Empty String Instead of NULL Q300258 KB300258 October 23, 2013
299950 FIX: Bad Cardinality Estimate Results in Sub Optimal Join Strategy Q299950 KB299950 October 23, 2013
298643 FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values Q298643 KB298643 October 23, 2013
296189 FIX: DBCC SHOW_STATISTICS Truncates Output for Fixed-Length Numeric Types Q296189 KB296189 October 23, 2013
294753 FIX: SQL Server 7.0 Readme Files Do Not Document Installation Warning Q294753 KB294753 October 23, 2013
294180 BUG: ADO: Append Cannot Be Used with OLE DB Provider For SQL Server if the Name of the Table Contains Spaces Q294180 KB294180 October 23, 2013
293279 FIX: Linked Server SELECT COUNT(*) Sent as SELECT COUNT((0)) Q293279 KB293279 October 23, 2013
288185 FIX: Stored Procedure Continues to Use Parameter Value Passed During First Execution Q288185 KB288185 October 23, 2013
285127 FIX: Updates Are Replicated as Delete/Insert Pair Even When Updates Should Not Be Replicated Q285127 KB285127 October 23, 2013
284942 PRB: ADO Does Not Support Default Values in Stored Procedures Q284942 KB284942 October 23, 2013
284351 FIX: SQL Server Profiler and SQL Server Agent Alerts May Fail to Work After Installing SQL Server 7.0 SP3 Q284351 KB284351 October 23, 2013
283837 FIX: SQL Server May Generate Nested Query For Linked Server When Option Is Disabled Q283837 KB283837 October 23, 2013
248988 FIX: RESTORE Fails When Fewer Devices Used on RESTORE than BACKUP Q248988 KB248988 October 22, 2013
248745 FIX: DB-Library Cursors on Stored Procedures May not be Created Q248745 KB248745 October 22, 2013
248688 FIX: Keyset, Dynamic and Forward Only Cursor Queries May not Get Auto-Parameterized Q248688 KB248688 October 22, 2013
248624 FIX: Creating Publication Fails if Table Has Long Column Name Q248624 KB248624 October 22, 2013
248623 FIX: No Mechanism for Cleaning Up Merge System Tables Q248623 KB248623 October 22, 2013
248604 FIX: SELECT with Subquery Containing BETWEEN Clause is Slow When Starting Range is the Minimum Value Q248604 KB248604 October 22, 2013
248492 FIX: SQL Server Does Not Properly Inform the DTC of Aborted Transactions Q248492 KB248492 October 22, 2013
248454 FIX: Access Violation May Occur with BCP when Skipping a Column from Input Data File Q248454 KB248454 October 22, 2013
248434 FIX: Non-Conflicting Column Updates May Cause Erroneous Metadata Mismatch Conflicts Q248434 KB248434 October 22, 2013
248420 FIX: DTS Designer Fails with Unspecified Error When Adding Table to DTS Query Designer Window Q248420 KB248420 October 22, 2013
248380 PRB: SQL 7.0 Failover Wizard Error when Updating Binaries on Cluster Q248380 KB248380 October 22, 2013
248307 FIX: Arithmetic Overflow in sp_checkdbtempsize and sp_checktabletempsize Q248307 KB248307 October 22, 2013
248156 FIX: Incorrect Error Trace Information for Query Interface Failure Q248156 KB248156 October 22, 2013
248135 FIX: Merge Snapshot Fails with "Line 1: Incorrect syntax near '[Object Name>]'." Q248135 KB248135 October 22, 2013
248062 FIX: Distributed Query with Oracle Cannot Work with Table Exported by DTS Q248062 KB248062 October 22, 2013
248046 BUG: SQL Debugging with SQL Server 7.0 Fails on Third Session in Visual InterDev Q248046 KB248046 October 22, 2013
247891 FIX: Event Log and DTS Error File does not Show DTS Error Detail Q247891 KB247891 October 22, 2013
247871 FIX: DTC commit/abort operation may leave suspended worker thread with waittype 0x0201 Q247871 KB247871 October 22, 2013
247870 FIX: Logreader Fails when Using XCALL Syntax with Text or Image Column Q247870 KB247870 October 22, 2013
247673 FIX: Data Column Host Process ID does not Show PID of Process Being Traced in Profiler Q247673 KB247673 October 22, 2013
247500 FIX: Parallel Sort May Be Slower Than Non-Parallel Sort Q247500 KB247500 October 22, 2013
247492 FIX: Primary Key Can Be Dropped if Table is Published Q247492 KB247492 October 22, 2013
247313 FIX: SEM 7.0 Login Failed Message When Editing or Running DTS Package Q247313 KB247313 October 22, 2013
247312 FIX: SQLDMO: Changing Length of a Column Within a DoAlter Does Not Work Q247312 KB247312 October 22, 2013
247307 FIX: SQLDMO: DBFile.Shrink and LogFile.Shrink with SQLDMOShrink_EmptyFile Generates Invalid DBCC Command Q247307 KB247307 October 22, 2013
247235 FIX: Sp_Change_Users_Login with Auto_Fix Fails When Run with Local Cursor Database Option Set Q247235 KB247235 October 22, 2013
247208 FIX: Custom Stored Procedure Resolver Does Not Log Merge Conflict Correctly Q247208 KB247208 October 22, 2013
247134 FIX: Many ISNULLs Within an Expression May Cause Access Violation Q247134 KB247134 October 22, 2013
247125 FIX: Optimizer May Choose Inefficient Query Plan When Using NOT LIKE with an Empty String Q247125 KB247125 October 22, 2013
247108 FIX: Test Button Fails if DTS Transform Has No Destination Columns Q247108 KB247108 October 22, 2013
247107 FIX: Generating Scripts to Multiple Files May Yield Error 20524 Q247107 KB247107 October 22, 2013
247056 FIX: Error 8630 When Querying A View Created with a UNION Clause Q247056 KB247056 October 22, 2013
247019 FIX: Access Violation When Adding CHECK Constraint w/ ESCAPE Keyword Q247019 KB247019 October 22, 2013
246893 FIX: Subquery in IN Clause with DISTINCT and JOINs May Cause Access Violation Q246893 KB246893 October 22, 2013
246824 FIX: Memory Leak May Occur When Calling Bulk Insert From a Stored Procedure Q246824 KB246824 October 22, 2013
246702 FIX: Regression: Specific Inner Join Slower with Service Pack 1 Applied Q246702 KB246702 October 22, 2013
246678 FIX: Creating a New Database User from Enterprise Manager May Fail with Error 16916 Q246678 KB246678 October 22, 2013
246646 FIX: SQL Server Has Fatal Exception When Attempting to Shrink Database Q246646 KB246646 October 22, 2013
246598 FIX: Columns Listed Multiple Times in GROUP BY WITH CUBE Clause Cause Access Violation Q246598 KB246598 October 22, 2013
246588 FIX: DBO Unable to Alter Database Using Enterprise Manager Q246588 KB246588 October 22, 2013
246571 FIX: Access Violation When Loading 5 MB SQL File in Execute SQL Task on Win 9x Q246571 KB246571 October 22, 2013
246565 FIX: Non-Compute Query Preceding Compute Query May Cause OSQL to Stop Responding Q246565 KB246565 October 22, 2013
246564 FIX: SQL Enterprise Manager AVs on Copy of Large SQL Script from Preview Q246564 KB246564 October 22, 2013
246498 FIX: SP1 Query Analyzer Reports an Illegal Operation and Exits on Windows 9x Q246498 KB246498 October 22, 2013
246474 FIX: Optimizer Chooses Inefficient Clustered Index on Query with Date Range Condition Q246474 KB246474 October 22, 2013
246229 FIX: Access Violation in kill_proc During Per Server Licensing Cleanup May Cause Server Hang Q246229 KB246229 October 22, 2013
246226 FIX: Heap Memory Corruption and AV in kill_proc May Occur when Using Per Server Licensing Q246226 KB246226 October 22, 2013
246191 FIX: INSERT SELECT Containing a HAVING Clause with a SUBSELECT Causes AV Q246191 KB246191 October 22, 2013
246189 FIX: Execution of IS_MEMBER May Cause AV When Many Roles Exist Q246189 KB246189 October 22, 2013
246177 FIX: Optimizer Chooses Table Scan Instead of Index Seek for Simple SELECT Involving @@identity Q246177 KB246177 October 22, 2013
246139 FIX: BCP Into a TEXT Column May Cause SQL Server to Stop Executing Q246139 KB246139 October 22, 2013
246031 FIX: Queries Using Linked Servers May Cause Access Violation and CPU Spin Q246031 KB246031 October 22, 2013
246028 FIX: "Out of Memory" Error with Bulk Insert Q246028 KB246028 October 22, 2013
245833 FIX: Immediate Updating Subscriber May Fail If a Text Column Comes Before Primary Key Q245833 KB245833 October 22, 2013
245795 FIX: Objects Created and Stored in DTS Global Variables Released Prematurely Q245795 KB245795 October 22, 2013
245662 FIX: Access Violation When Using Generate SQL Scripts Option in SQL Server Enterprise Manager Q245662 KB245662 October 22, 2013
245406 FIX: Nonclustered Index Not Chosen with Varchar and LIKE Clause Q245406 KB245406 October 22, 2013
245253 BUG: DTS Packages Stored in the Repository Are Not Listed Q245253 KB245253 October 22, 2013
244943 FIX: Security Information Not Persistent for the Connection Object in a DTS Package Q244943 KB244943 October 22, 2013
244934 FIX: Killing Running Query May Result in a SPID in Constant ROLLBACK State and AV Q244934 KB244934 October 22, 2013
244763 FIX: Access Violation Under High Cursor Stress Q244763 KB244763 October 22, 2013
244548 FIX: SQL 7.0 Slower than SQL 6.5 on Multiple Left Outer Join Q244548 KB244548 October 22, 2013
244538 FIX: Upgrade Wizard Fails with "Backup 6.x Devices - phase II" Error if Using Tape Q244538 KB244538 October 22, 2013
244537 BUG: DTS: Table Transfers Incorrectly If Using Char or Varchar Larger Than 4000 Characters Q244537 KB244537 October 22, 2013
244446 FIX: SQL 7.0 Slower than SQL 6.5 on UNIONed Left Outer Join and View Q244446 KB244446 October 22, 2013
244273 FIX: Changing the Number of Columns in a DTS File Connection May Cause Error Q244273 KB244273 October 22, 2013
244230 FIX: Slow Query Performance Using Correlated Subquery with "Or Exists" Clause Q244230 KB244230 October 22, 2013
243775 INF: How to Use Lookups in Data Transformation Services Q243775 KB243775 October 22, 2013
243740 FIX: Replication AddSubscription Method Causes Handle Leak on Failure Q243740 KB243740 October 22, 2013
243664 FIX: Secondary SPIDs Enlisted in DTC Transaction do not Obtain DTC Isolation Level Q243664 KB243664 October 22, 2013
243502 FIX: SERIALIZABLE Isolation Allows Phantom Inserts with SELECT...ORDER BY DESC Q243502 KB243502 October 22, 2013
243292 FIX: Creating a Table in Enterprise Manager When Using a Domain Account May Cause Server AV Q243292 KB243292 October 22, 2013
243211 FIX: Poor Performance with In Clause Using Multiple Correlated Subqueries Unioned Together Q243211 KB243211 October 22, 2013
242047 FIX: Using Srv_paramsetoutput to Set an Output Parameter to NULL Fails Q242047 KB242047 October 22, 2013
241678 FIX: Replication Merge JOIN Filters May not be Completely Evaluated when a Filtered Table is Modified Q241678 KB241678 October 22, 2013
241658 FIX: REPL: "Too Many Arguments Were Supplied" Error When Inserting a Row Q241658 KB241658 October 22, 2013
241448 FIX: Replication with Immediate-Updating Subscribers Fails with Error 21082 Q241448 KB241448 October 22, 2013
240858 FIX: sp_statistics May Return Incorrect Results After ALTER TABLE DROP COLUMN Q240858 KB240858 October 22, 2013
240853 FIX: Lock Escalation With Parallel Query May Cause 1203 Error And Server Shutdown Q240853 KB240853 October 22, 2013
240678 BUG: DOC Error: DNR and Compilation Section Incorrectly States Stored Procedures Do Not Execute Q240678 KB240678 October 22, 2013
240194 FIX: Conflict Viewer Shows Incorrect Format for Datetime Column Q240194 KB240194 October 22, 2013
240192 FIX: Unresolved Merge Conflicts With Constraints And Triggers Q240192 KB240192 October 22, 2013
282175 FIX: Parallel Query on Four CPUs Using NLS Is Slower Than Two CPUs Q282175 KB282175 October 21, 2013
282174 FIX: Restoring or Altering a Database Might Result in CPU Spin Q282174 KB282174 October 21, 2013
281809 BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup Q281809 KB281809 October 21, 2013
281340 PRB: File Compare Utility Fails to Run from Xp_cmdshell Q281340 KB281340 October 21, 2013
281338 FIX: Select Distinct Fails to Eliminate Duplicate Null Values on Bit Datatype Q281338 KB281338 October 21, 2013
281191 FIX: SQL Server Replication Synchronization to DB2 Subscriber Fails with Numeric Data Type Q281191 KB281191 October 21, 2013
281141 FIX: Replication Distribution Agent That Uses ActiveX Control May Skip INSERT Commands Under Stressed Condition Q281141 KB281141 October 21, 2013
280807 DTS packages in SQL Server 7.0 cannot be saved using SQL Server 2000 encrypted format Q280807 KB280807 October 21, 2013
280791 FIX: Assert Occurs in SQL Server When You Run DBCC CHECKDB or sp_adddistributiondb Q280791 KB280791 October 21, 2013
280739 FIX: DTS Wizard Hangs at Startup While Enumerating OLEDB Providers Q280739 KB280739 October 21, 2013
280685 FIX: Preparing a Statement That References a Missing Object Incorrectly Succeeds Q280685 KB280685 October 21, 2013
279690 FIX: Duplicate Hotkeys in German SQL Server 7.0 DTS Import Wizard Q279690 KB279690 October 21, 2013
279505 FIX: Transaction Log Space Grows on Standby Server Q279505 KB279505 October 21, 2013
279319 FIX: Query Using Nested IN and a CASE Clause Causes an Access Violation Q279319 KB279319 October 21, 2013
279088 FIX: Merge Agent May Ignore Subscriber-Side Changes in Articles with the Same Name Q279088 KB279088 October 21, 2013
278980 FIX: Insert with SUBSTRING Operation Fails if JOIN Comparison is Based on NULL Values and LIKE Clause Q278980 KB278980 October 21, 2013
278965 FIX: Patindex Function May Return Incorrect Result on SQL Server 7.0 with DBCS Codepage Q278965 KB278965 October 21, 2013
278964 FIX: Temporary Tables Are Not Dropped When the Merge Agent Runs in Continuous Mode Q278964 KB278964 October 21, 2013
278855 FIX: Assert in Errorlog During WITH STANDBY Recovery on a Replicated Database Q278855 KB278855 October 21, 2013
278443 FIX: DTS Import Wizard Closes When You Browse for SQL Server Servers Q278443 KB278443 October 21, 2013
278421 FIX: A SELECT Statement with a Large IN Clause May Fail with a Stack Overflow and the Client Disconnects Q278421 KB278421 October 21, 2013
278394 FIX: Error Message 8509 Not Returned to Client Correctly When DTC Import Fails Q278394 KB278394 October 21, 2013
278387 FIX: INFORMATION_SCHEMA.KEY_COLUMN_USAGE.ORDINAL_POSITION Column Reflects Incorrect Data Q278387 KB278387 October 21, 2013
278383 FIX: Replication Monitor Is Not Updated After Anonymous Subscription (Distribution or Merge) Expires Q278383 KB278383 October 21, 2013
278372 FIX: Running Stack Dumper Can Cause Memory Leak of Virtual Bytes Q278372 KB278372 October 21, 2013
278369 FIX: Stack Dumps May Be Incorrect or Incomplete When UMS Runs in Fiber Mode Q278369 KB278369 October 21, 2013
278363 FIX: Attentions During Nonlogged Allocations in Tempdb Can Result in Errors 8906 and 8946 Q278363 KB278363 October 21, 2013
278285 FIX: Attention During Tempdb Auto Stats May Result in Server Shutdown Q278285 KB278285 October 21, 2013
278280 FIX: Abort of Multi-Database Transaction Can Fail with Assertion Q278280 KB278280 October 21, 2013
278250 FIX: DTS: Transfer Objects and Data May Cause Access Violation Q278250 KB278250 October 21, 2013
277897 FIX: OLEDB: DBCC SHOW_STATISTICS May Cause Protocol Error Message in TDS Stream Q277897 KB277897 October 21, 2013
277843 FIX: Restore of Log in Standby Mode May Cause 9004 Error Message if the Original Database has Shrink Enabled Q277843 KB277843 October 21, 2013
277839 FIX: Active SDES for Negative Object ID Message Logged Followed by Process Termination Q277839 KB277839 October 21, 2013
277716 FIX: OPENQUERY/OPENROWSET with DB2 Linked Server May Return Incorrect Results with Decimal Datatype Q277716 KB277716 October 21, 2013
277698 FIX: LEFT OUTER JOIN on a View that Uses the DISTINCT Keyword Produces Incorrect Results Q277698 KB277698 October 21, 2013
277547 FIX: Table Corruption When Using BCP with SELECT INTO/BULK COPY, Nonclustered Index, and IGNORE_DUP_KEY Q277547 KB277547 October 21, 2013
276992 FIX: Bulk Insert or Snapshot Replication May Corrupt Table During NOLOCK Scans Q276992 KB276992 October 21, 2013
276751 FIX: Bulk Insert May Leak Memory in Abort Cases Q276751 KB276751 October 21, 2013
276595 FIX: Replication Agents Print Logon Password When You Use the Output Parameter Q276595 KB276595 October 21, 2013
276583 FIX: Error Message Occurs When You Open a DTS Package Saved with Characters that do not Exist in SQL Server Code Page Q276583 KB276583 October 21, 2013
276533 FIX: Error Message 20026 When You Upgrade a SQL Server 7.0 Republishing Merge Subscriber to SP2 Q276533 KB276533 October 21, 2013
276427 FIX: Snapshot Fails with Duplicate Key Row in MSmerge_genhistory Q276427 KB276427 October 21, 2013
276281 FIX: Replication Logreader Fails with Error Message 18773 Q276281 KB276281 October 21, 2013
276225 FIX: SQL Server 7.0 Service Pack 2 May Fail to Delegate the Filter Condition to the Provider Q276225 KB276225 October 21, 2013
276067 FIX: Duplicate Distribution Steps May Lead to Bad Plan Selection for >= or =< Predicates Q276067 KB276067 October 21, 2013
276060 FIX: SELECT with ORDER BY Does Not Maintain Sort Order if Run in Parallel Q276060 KB276060 October 21, 2013
276041 FIX: Retrieving Text/Image Data May Return Error 5180 Q276041 KB276041 October 21, 2013
275992 FIX: Running Sp_vupgrade_replication May Fail with Timeout Expired Error Message During Service Pack 2 Upgrade Q275992 KB275992 October 21, 2013
275724 FIX: Queries May Not Run After You Perform a Replace All in Query Analyzer Q275724 KB275724 October 21, 2013
275670 FIX: DTS Wizard Parses Custom Datatypes Incorrectly Q275670 KB275670 October 21, 2013
275619 FIX: RPC That Calls Another RPC Returns an Error Message and Incorrect Results Q275619 KB275619 October 21, 2013
275615 FIX: Restore Command That Uses Large File Names May Cause Access Violation Q275615 KB275615 October 21, 2013
275608 FIX: Mathematical Operations on Numeric or Decimal Columns with Negative Numbers May Return Unexpected Results Q275608 KB275608 October 21, 2013
275536 FIX: Linked Server Query with Hyphen in LIKE Clause May Run Slower than Expected Q275536 KB275536 October 21, 2013
275503 FIX: BCP Out Fails with Exception Error if You Use a Format File to Change Order of Columns Q275503 KB275503 October 21, 2013
275487 FIX: Stack Overflow Exception Error Occurs When You Insert 250 KB or More of Data Into a Text or Image Column Q275487 KB275487 October 21, 2013
275427 FIX: SP2 Regression: Update That Contains a Join Causes a 601 Error Message and Produces Incorrect Results Q275427 KB275427 October 21, 2013
275339 FIX: DTS Wizard Specifies Destination Table Name Incorrectly Q275339 KB275339 October 21, 2013
274993 FIX: Column Level Permissions May Be Displayed Incorrectly When GRANT_WITH_GRANT Option Is Used Q274993 KB274993 October 21, 2013
274811 FIX: Keyset Cursor Fetches Same Row Repeatedly Q274811 KB274811 October 21, 2013
274801 FIX: SQL Server 7.0 Clients on Windows 2000 May Cause Extra Trip to Domain Controller During Integrated Logon Q274801 KB274801 October 21, 2013
274765 FIX: SELECT Statement May Generate Incorrect Results When Hash Join Is Used in the Parallel Query Plan Q274765 KB274765 October 21, 2013
274661 FIX: Delete Operation May Fail to Delete Qualified Rows with a Self Referenced Subquery Q274661 KB274661 October 21, 2013
274521 FIX: BULK INSERT May Silently Reject NULL Values for NOT NULL Columns Q274521 KB274521 October 21, 2013
274470 FIX: SELECT DISTINCT May Return Incorrect Results Unless Column Set Equal to Itself Q274470 KB274470 October 21, 2013
274428 FIX: Revoking Update Permissions on a Table Also Revokes Column-Level Select Permissions Q274428 KB274428 October 21, 2013
274376 INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage Q274376 KB274376 October 21, 2013
274353 FIX: Query Analyzer: Empty Row is Returned with COMPUTE on SMALLINT Data Q274353 KB274353 October 21, 2013
273789 BUG: DTS Truncates ActiveX Scripts Q273789 KB273789 October 21, 2013
273584 FIX: Multiserver Jobs Fail to Download on French Localized TSX Q273584 KB273584 October 21, 2013
273009 FIX: sp_helptext May Fail to Return the Correct Text when a New Line Begins at Multiples of 8000 Bytes Q273009 KB273009 October 21, 2013
272457 FIX: SQL Server Exception Encountered in CQDynArray::Resize Q272457 KB272457 October 21, 2013
272220 FIX: TEXT/IMAGE Data Storage Space Not Reclaimed Correctly Q272220 KB272220 October 21, 2013
271564 BUG: DTS Designer Might Send an Attention Signal Before SQL Task Completes Q271564 KB271564 October 21, 2013
271247 PRB: DTS Wizard "Fixed Field Column Positions" Wraps Text Q271247 KB271247 October 21, 2013
271144 BUG: DTS Execute SQL Task Fails to Complete When Constraints are Violated Q271144 KB271144 October 21, 2013
269839 FIX: Access Violation Occurs When Querying a Remote Index Provider Q269839 KB269839 October 21, 2013
269697 FIX: SPID Returns to ROLLBACK Status When You Cancel a SELECT Statement with a Parallel Plan Q269697 KB269697 October 21, 2013
239794 INF: Changes to SQL-DMO Objects in SQL Server 7.0 Q239794 KB239794 October 21, 2013
239773 FIX: Using DBCC Stackdump or CTRL+C + D Causes Fatal Exception on Windows 95 & Windows 98 Q239773 KB239773 October 21, 2013
239766 FIX: DTC Transaction IDs and Isolation Levels Not Captured Q239766 KB239766 October 21, 2013
239583 INF: DTS Transfer SQL Server Objects Does Not Transfer Table with User-Defined Datatype Q239583 KB239583 October 21, 2013
239475 FIX: sp_execute Results in Handled AV After Error 2627 Q239475 KB239475 October 21, 2013
239015 FIX: Non-convergence Problem with Merge Replication Q239015 KB239015 October 21, 2013
238822 INF: How to Rebuild the Repository in SQL Server 7.0 Q238822 KB238822 October 21, 2013
238658 FIX: Distribution Agent Fails with 'Incorrect Syntax' for Updating Subscribers Q238658 KB238658 October 21, 2013
238637 FIX: Update on View Based Cursor to Multiple Rows in Fetch Buffer Fails with 1203 Msg. Q238637 KB238637 October 21, 2013
238547 FIX: Update on View-based Cursor Fails to Modify Row if View Contains a Join Q238547 KB238547 October 21, 2013
238523 FIX: DTS "Execute SQL Task" Terminates Prematurely Without Completing All Commands in Batch Q238523 KB238523 October 21, 2013
238455 FIX: BCP IN with 4GB or Larger File Fails with Unexpected EOF Q238455 KB238455 October 21, 2013
238356 FIX: Use of 25 Different Tables in a Query May Raise Error 1203 Q238356 KB238356 October 21, 2013
238348 INF: SMS 2.0 Evaluation and SQL Server 7.0 Evaluation Q238348 KB238348 October 21, 2013
238332 PRB: Differences Between DMO 7.0 and DMO 6.5 With ExecuteWithResults Q238332 KB238332 October 21, 2013
238206 FIX: Password Dangling and Decrypted When Changing Security Mode For Replication Q238206 KB238206 October 21, 2013
238091 FIX: Creating New TCP/IP Advanced Entry Deletes Existing Advanced Entries Q238091 KB238091 October 21, 2013
237898 INF: Data Transformation Services and Logged Loads Q237898 KB237898 October 21, 2013
237793 FIX: Using Wildcard Operator '%' with LIKE May Produce Inconsistent Row Patterns Q237793 KB237793 October 21, 2013
237703 FIX: Permissions Not Changed Correctly Using SQL Enterprise Manager Q237703 KB237703 October 21, 2013
237412 PRB: Quick Links from SQL Server 7.0 Support Highlights Page Do Not Contain Information on SQL Server Q237412 KB237412 October 21, 2013
237411 SQL Server 7.0 Books Online points to Personal Support Pages Q237411 KB237411 October 21, 2013
236955 FIX: Lock Conversion Processing Does Not Properly Wakeup Lock Waiter Q236955 KB236955 October 21, 2013
236440 FIX: sp_OAGetProperty Fails on Properties From Inherited Interface Q236440 KB236440 October 21, 2013
236439 FIX: Memory Leak with DB-Library Connection Using TCP/IP or IPX/SPX Q236439 KB236439 October 21, 2013
236424 FIX: Stack Overflow Running CHECKDB Against DB With Many Objects Q236424 KB236424 October 21, 2013
236334 BUG: Multi-Protocol Connection Fails with SQL 6.5 and Integrated Security Using 7.00.623 Netlib Q236334 KB236334 October 21, 2013
236068 FIX: Null Parameter for DTS Lookup Causes MMC to Exit Q236068 KB236068 October 21, 2013
235987 Virtual SQL Server 7.0-Based Server Only Supports the Use of One TCP/IP Address Q235987 KB235987 October 21, 2013
235502 FIX: Disproportional Data File Filling Q235502 KB235502 October 21, 2013
235401 FIX: 8623 Error with INSERT-SELECT when Nullable Clustered Keys not Referenced Q235401 KB235401 October 21, 2013
235366 PRB: Profiler Errors If Connected Using SQL Authentication via TCP/IP Socket Q235366 KB235366 October 21, 2013
235060 FIX: Distributed Query Predicate not Remoted when IDBSchemaRowset not Supported Q235060 KB235060 October 21, 2013
235007 FIX: Modifying SQL 6.5 Logreader on SQL 7.0 Distributor Fails with Error "The required parameter '-PublisherDB' is missing." Q235007 KB235007 October 21, 2013
234938 FIX: Expanding the Server Tree in Enterprise Manager is Slow When Server Has a Large Number of Windows NT Logins Q234938 KB234938 October 21, 2013
234906 BUG: Source Control Times Out When You Add Stored Procedures Q234906 KB234906 October 21, 2013
234883 FIX: Wrong Index Chosen When Query References Values Beyond Statistics Q234883 KB234883 October 21, 2013
234861 FIX: SEM May AV When Changing the Size of a Pane in Design View Q234861 KB234861 October 21, 2013
234647 Windows 95/98 Clients Hang with "Mprexe.exe Not Responding" Error Message Q234647 KB234647 October 21, 2013
234256 FIX: sp_addtype Does Not Allow Owner Qualified Object Names Q234256 KB234256 October 21, 2013
234174 FIX: Db_owner Role Members Cannot Use sp_[un]bindrule and sp_[un]bindefault Q234174 KB234174 October 21, 2013
234031 FIX: Existing Connection Combo Box in DTS UI Displays Incorrect Connections Q234031 KB234031 October 21, 2013
233542 FIX: Concurrent Execution of Keyset Cursors may Cause AV & SDES Errors Q233542 KB233542 October 21, 2013
233374 BUG: Error 7356 When Using SQL 7.0 to Select From a SQL 6.5 View Q233374 KB233374 October 21, 2013
233190 FIX: Access Violation When Using UNIONs in Transact-SQL Cursors Q233190 KB233190 October 21, 2013
233019 FIX: DTSWIZ /? Shows /r as an Option but it Does Not Exist Q233019 KB233019 October 21, 2013
232984 PRB: Unable to See VIEWs Using Query Builder in DTS Import/Export Wizard Q232984 KB232984 October 21, 2013
232926 FIX: Complex Query Containing Redundant Logic May Cause Access Violation Q232926 KB232926 October 21, 2013
232244 FIX: Delay Between Responses Fails for Perf Condition Alert Q232244 KB232244 October 21, 2013
232234 INF: How to Differentiate SQL 7.0 Standard and Developer Edition Q232234 KB232234 October 21, 2013
231759 FIX: SEM Generates SQL-DMO Error When Adding an ODBC Subscriber Q231759 KB231759 October 21, 2013
269560 FIX: LoginTimeout and QueryTimeout Properties in Replication ActiveX Control Are Not Used During Execution Q269560 KB269560 October 20, 2013
268150 FIX: INSERT..SELECT with NOT EXISTS Can Choose Slower Merge Join Plan Q268150 KB268150 October 20, 2013
267264 FIX: Distribution Agent May Fail to Report That a Subscription is Marked as Inactive Q267264 KB267264 October 20, 2013
266234 FIX: Parallel Query That Has Many Bit Columns May Cause Access Violation Q266234 KB266234 October 20, 2013
266158 FIX: Complex Merge Join Might Cause Handled Access Violation Q266158 KB266158 October 20, 2013
265865 FIX: Float Data Inaccurately Converted When Sent to Linked Server Q265865 KB265865 October 20, 2013
265355 FIX: NCHAR Columns Padded with Empty Strings Instead of Spaces During BCP/BULK INSERT Q265355 KB265355 October 20, 2013
264489 FIX: Index Tuning Wizard Does Not Process Parameterized Workload Across Batches Q264489 KB264489 October 20, 2013
264192 FIX: Bulk Load Operation on Nchar Field Pads Incorrectly Q264192 KB264192 October 20, 2013
263649 FIX: Handled Access Violation on INSERT Through Cursor Q263649 KB263649 October 20, 2013
263304 FIX: UPDATE Fails Under INSERT/UPDATE Stress on Non-Indexed Table Q263304 KB263304 October 20, 2013
262446 FIX: Error Message "Permission Denied" When You Update A View Q262446 KB262446 October 20, 2013
262023 FIX: Queries With Large Numeric Values May Not Use Appropriate Index Q262023 KB262023 October 20, 2013
262019 FIX: Aborting Parallel Query With Hash Operation May Orphan Extents in Tempdb Q262019 KB262019 October 20, 2013
260346 FIX: Transactional Publications with a Filter on Numeric Columns Fail to Replicate Data Q260346 KB260346 October 20, 2013
260342 FIX: Replication Agents May Fail With Arithmetic Overflow Errors Due to Large Latencies Q260342 KB260342 October 20, 2013
260320 BUG: DTS Transfer May Fail with "Incorrect syntax..." Error Message Q260320 KB260320 October 20, 2013
260087 FIX: Large Error Numbers May Cause Heap Corruption in SQLServerAgent Service Q260087 KB260087 October 20, 2013
258145 No DSN is available for the sample sites when you set up Site Server 3.0 Commerce Edition Q258145 KB258145 October 20, 2013
258087 FIX: Non-Admin User That Executes Batch While Server Shuts Down May Encounter Retail Assertion Q258087 KB258087 October 20, 2013
258083 FIX: Abort of Distributed Transaction with Xproc May Cause Assertions, Access Violations and Server Shutdown Q258083 KB258083 October 20, 2013
258082 FIX: Abort of Command That Uses a Worktable May Result in Orphaned Extents in the Tempdb System Database Q258082 KB258082 October 20, 2013
257868 How To Get the PackageID for Use in the LoadFromRepository Function Q257868 KB257868 October 20, 2013
256649 FIX: Simultaneous DTC Operations May Cause Errors Q256649 KB256649 October 20, 2013
255900 FIX: DTS Package Created on Uplevel (2.5/2.6) MDAC May Fail on Computer with Downlevel (2.1) MDAC Q255900 KB255900 October 20, 2013
255804 FIX: Incorrect Results with Count Distinct and Aggregate in Select List Q255804 KB255804 October 20, 2013
255643 FIX: Incorrect Costing Causes Other Joins to be Favored Over Loop Join Q255643 KB255643 October 20, 2013
255633 FIX: SET ROWCOUNT or TOP With Partitioned View May Cause Poor Performance Q255633 KB255633 October 20, 2013
254910 FIX: Slow Performance with NOT NULL Comparison and Empty Table Q254910 KB254910 October 20, 2013
254905 FIX: xp_trace_setqueryhistory not Flushed by Access Violation Q254905 KB254905 October 20, 2013
254126 FIX: Incorrect Error Numbers Reported on Big Endian Client Q254126 KB254126 October 20, 2013
254123 FIX: Incorrect Values for Datetime, Smalldatetime, and Money Types With Big-Endian Client Q254123 KB254123 October 20, 2013
252434 PRB: Table Designer Automatically Clears Results Pane When Idle Q252434 KB252434 October 20, 2013
252375 FIX: Pull Subscribers Unsynchronized if Reinitialized from Subscriber Causing Distribution Failures Q252375 KB252375 October 20, 2013
252372 FIX: Join Filters with Dynamic Filters May Lead to Non-convergence Problem Q252372 KB252372 October 20, 2013
251229 FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors Q251229 KB251229 October 20, 2013
251190 FIX: Performance Impact of Remote Stored Procedures That do not Return Result Sets Q251190 KB251190 October 20, 2013
251094 FIX: Sampling Inconsistency Results in Access Violation or Slow-Running Queries Q251094 KB251094 October 20, 2013
251077 FIX: Enterprise Manager Slow in Opening the Database Properties Dialog Box Q251077 KB251077 October 20, 2013
250994 FIX: Update Generation Markers After Applying the MSmerge_genhistory.bcp Q250994 KB250994 October 20, 2013
250345 FIX: Prefetching of Rows by Bookmark Lookup May Not Release Locks in Read Committed Isolation Q250345 KB250345 October 20, 2013
249842 PRB: DTS Package Creation May Fail with "Could not create Component Categories Manager" Q249842 KB249842 October 20, 2013
226154 FIX: Async Keyset Cursors and Memory Pressure May Cause AV and Server Shutdown Q226154 KB226154 October 20, 2013
226122 FIX: Conn Using MP Netlib with Low Memory can Fail with AV Q226122 KB226122 October 20, 2013
226109 FIX: SQLServerAgent May Shut Down If SQL Server Is Started from the Console Q226109 KB226109 October 20, 2013
225705 FIX: BCP Import with Extended Character as a Column Delimiter Fails Q225705 KB225705 October 20, 2013
225093 FIX: Poor Performance with Inner Join with Multiple LIKE Clauses Using Variables Q225093 KB225093 October 20, 2013
224986 FIX: Query Analyzer Truncates Output of COMPUTE Clause at Six Characters Q224986 KB224986 October 20, 2013
224581 FIX: Very Large Numbers of Predicates AND-ed Together May Cause Stack Overflow Q224581 KB224581 October 20, 2013
224539 FIX: Query Optimizer Fails to Consider Anti Semi Join for NOT IN Queries Q224539 KB224539 October 20, 2013
224160 FIX: Create DB Wizard Incorrectly Sets Transaction Log File Growth Q224160 KB224160 October 20, 2013
223786 PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly Q223786 KB223786 October 20, 2013
223257 FIX: RPC Using SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT May Cause AV Q223257 KB223257 October 20, 2013
223031 BUG: Optimizer Picks Table Scan for IF EXISTS Subquery with BETWEEN and Local Variable Q223031 KB223031 October 20, 2013
222843 Usage Import Does Not Import IIS Logs from SQL Server 7.0 Database Q222843 KB222843 October 20, 2013
222183 BUG: DTS Import/Export Wizard Does Not Display Scheduling Q222183 KB222183 October 20, 2013
222073 INF: Getting Started with Data Transformation Services (DTS) Q222073 KB222073 October 20, 2013
221243 FIX: Users Added Through Windows NT Groups Not Able to View List of Tables Q221243 KB221243 October 20, 2013
221148 PRB: SQL 7.0 Upgrade Fails w/ 'Could not find stored procedure' Msg Q221148 KB221148 October 20, 2013
254321 Clustered SQL Server do's, don'ts, and basic warnings Q254321 KB254321 October 14, 2013
219865 FIX: Sqltrace.dll May Cause Heap Corruption with Zero Length Binary RPC Parameter Q219865 KB219865 October 14, 2013
219756 FIX: Connections to SQL Server May Result in Handle Leak If SQLTRACE Is Enabled Q219756 KB219756 October 14, 2013
219425 FIX: DTS Wizard new database causes errors when targer server is SQL Server 6.5 Q219425 KB219425 October 14, 2013
218605 FIX: Progress Indicators Not Shown When Transferring Data Using DTS Q218605 KB218605 October 14, 2013
216200 Running Site Server 3.0 with SQL Server 7.0 Q216200 KB216200 October 14, 2013
215457 FIX: Logreader Fails to Replicate When Updating Non-NULL Text Fields with Empty Space Q215457 KB215457 October 14, 2013
214818 FIX: UPDATE of Table Column with a FOREIGN KEY Constraint May Fail with Msg 8623 Q214818 KB214818 October 14, 2013
214601 PRB: ANSI_NULLS OFF Behavior in SQL Server 6.x and 7.0 Q214601 KB214601 October 14, 2013
208927 FIX: Transfer Manager Leaves Open Connection in Source DB Q208927 KB208927 October 11, 2013
207809 INF: DTS/Replication Licensing for Desktop SQL Server 7.0 Q207809 KB207809 October 11, 2013
207451 FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed Q207451 KB207451 October 11, 2013
207446 BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns Q207446 KB207446 October 11, 2013
205557 PRB: SQL Server Tape Backup is Unsupported on Windows 95/98 Computers Q205557 KB205557 October 11, 2013
203777 FIX: ITW/Perform Index Analysis Fails on Table Names Not Represented in System Locale Q203777 KB203777 October 11, 2013
202429 FIX: Error 21761 When Binding Non-DBO Default Q202429 KB202429 October 11, 2013
201868 PRB: View Designer Errors if Query Cannot Display Graphically Q201868 KB201868 October 11, 2013
201533 FIX: Enterprise Manager Displays 'SQL Server Standard' for Desktop Edition Q201533 KB201533 October 11, 2013
201001 BUG: Table Designer "Table and Index Properties" Button Fails Q201001 KB201001 October 11, 2013
200795 FIX: DBCC CHECKCATALOG May Incorrectly Report Error 2513 Q200795 KB200795 October 11, 2013
200118 FIX: Adding Database Files During Upgrade May Cause Errors Q200118 KB200118 October 11, 2013
199280 BUG: DTS Query Builder Problem with Inline Comment Q199280 KB199280 October 11, 2013
199240 BUG: DTS Fails When Importing Table with a Timestamp Column Q199240 KB199240 October 11, 2013
199232 BUG: Right Align Numerics Has No Effect on the Grid Result Q199232 KB199232 October 11, 2013
199223 BUG: Immediate Updating Subscriber Builds Trigger Incorrectly Q199223 KB199223 October 11, 2013
199217 PRB: Uninstall Does Not Remove All Replication Files Q199217 KB199217 October 11, 2013
199213 BUG: Web Assistant: Can Only Save File with .sql Extension Q199213 KB199213 October 11, 2013
199204 How To Put Stored Procedures Under Remote Source Control in Visual InterDev 6.0 Q199204 KB199204 October 11, 2013
199105 BUG: ROUND Function with NULL Length Returns TDS Error Q199105 KB199105 October 11, 2013
199054 BUG: Double Precision Synonym Mapped to REAL Instead of FLOAT Q199054 KB199054 October 11, 2013
198921 FIX: Visual C++ ATL Provider Fails when Used with SQL DTS Q198921 KB198921 October 11, 2013
198884 FIX: DTS Cannot Save a Package to Repository with Login Greater Than 20 Characters Q198884 KB198884 October 11, 2013
198674 FIX: SERIALIZABLE Isolation Fails When Using Aggregate Functions Q198674 KB198674 October 11, 2013
198521 FIX: SQL Profiler May Cause Divide By Zero Exception Q198521 KB198521 October 11, 2013
198515 FIX: Address Book in Send Mail Task Adds Only First Address Q198515 KB198515 October 11, 2013
198514 FIX: Restore to New Server Causes Transactions to Remain in Log Q198514 KB198514 October 11, 2013
198487 INF: INSERT EXEC of Text/Image/Ntext from XP Is Not Supported Q198487 KB198487 October 11, 2013
198416 INF: Trace Flag 8816 to Help Year 2000 Conversion Q198416 KB198416 October 11, 2013
198265 FIX: Failed Sp_prepare Incorrectly Closes Transaction Q198265 KB198265 October 11, 2013
198168 BUG: Problems Might Occur When You Change Account Information for SQL Server Cluster Q198168 KB198168 October 11, 2013
198163 FIX: FT Wizard Fails with Windows NT Authentication and Not Sysadmin Q198163 KB198163 October 11, 2013
198106 BUG: "Do You Want to Delete This Index" Message When Creating Index Q198106 KB198106 October 11, 2013
198105 BUG: Errors When Creating a View Using the WITH CHECK OPTION in SQL Enterprise Manager Q198105 KB198105 October 11, 2013
198064 PRB: Filter on Saved Profiler Trace Replaces Previous File Q198064 KB198064 October 11, 2013
198032 BUG: Adding Steps to Database Maintenance Job Results in Error in SQL Enterprise Manager Q198032 KB198032 October 11, 2013
198030 BUG: Query Against Sysprocesses May Fail with Message 1105 Q198030 KB198030 October 11, 2013
197800 FIX: Cursor overhead higher in SQL Server 7.0 than in SQL Server 6.x for small result sets Q197800 KB197800 October 11, 2013
197799 PRB: Cannot Create FK Relationship Using Design Table Interface Q197799 KB197799 October 11, 2013
197798 BUG: Table Designer Gives an Error with Quotes in a Column Name Q197798 KB197798 October 11, 2013
197797 BUG: Table Designer Error with Single Quote in a Table Name Q197797 KB197797 October 11, 2013
197581 BUG: QA: No Execution Plan for DECLARE CURSOR & SELECT...FOR BROWSE Q197581 KB197581 October 11, 2013
197562 BUG: Heterogeneous Query Showplan May Not Display Site Name Q197562 KB197562 October 11, 2013
197462 BUG: Slow Performance Using Cursor Positioned Update If No PK Q197462 KB197462 October 11, 2013
197390 BUG: SetupAdmin Member Not Allowed to Add Linked Server in SEM Q197390 KB197390 October 11, 2013
197389 BUG: MSG 15417 Trying to Change Compatibility Level of Master DB Q197389 KB197389 October 11, 2013
197385 FIX: DTSRun: Package Reports False Success with User Password Q197385 KB197385 October 11, 2013
197352 BUG: Mmc.exe Application Error Closing Script Generation Dialog Box Q197352 KB197352 October 11, 2013
197246 BUG: (local) Disappears When Using DTS Transfer SQL Server Object Q197246 KB197246 October 11, 2013
197245 INF: How to Determine Tempdb Size Required by DBCC CHECKDB Q197245 KB197245 October 11, 2013
197043 BUG: BULK INSERT Fails While Inserting into an IMAGE Column Q197043 KB197043 October 11, 2013
196919 FIX: Descending Index Scans May Block with High Transaction Isolation Q196919 KB196919 October 11, 2013
196905 INF: Backup with INIT or FORMAT Is Documented in Error Log Q196905 KB196905 October 11, 2013
196789 BUG: CREATE TABLE in Stored Procedure with the Name "sp_" May Fail Q196789 KB196789 October 11, 2013
195761 Frequently asked questions - SQL Server 7.0 - Failover Q195761 KB195761 October 11, 2013
195760 Frequently asked questions - SQL Server 7.0 - Server Q195760 KB195760 October 11, 2013
195444 Frequently asked questions - SQL Server 7.0 - Conversion Q195444 KB195444 October 11, 2013
194665 FIX: Incorrect results from sysprocesses with SQL Server 7.0 ODBC driver when connected to SQL Server 6.5 Q194665 KB194665 October 10, 2013

SQL Server 7.0 articles, fixes and updates - October 2013