kbupdate.info ›
Daily Updated!
SQL Server 7.0 articles, fixes and updates - letter F
Daily Updated!
chronological list: 2021 | 2020 | 2019 | 2018 | 2017 | 2015 | 2014 | 2013/12 11 10 9 8 7 3 ... 1999
alphabetical list: A B C D E F G H I K M N O P R S T U V W Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 7.0 starts with letter F that have been released. The list is daily updated.
- 266008 FIX: Ad Hoc Access Denied Post SP2 with the Use of OPENROWSET Q266008 KB266008 April 19, 2018
- 294875 FIX: SQLTables() Function Returns No Data for SQL Server Database Names That Contain Underscore Q294875 KB294875 January 11, 2015
- 830262 FIX: Unconditional Update May Not Hold Key Locks on New Key Values Q830262 KB830262 February 27, 2014
- 815125 FIX: Possible Cluster Failover Issues with Pre-Service Pack 4 Version of SQL Server 7.0 Q815125 KB815125 February 27, 2014
- 229875 FIX: Unable to Perform Automated Installation of SQL 7.0 Using File Images Q229875 KB229875 November 3, 2013
- 225501 FIX: SQL-DMO Operations on SQL Server 7.0 Uses More Memory Q225501 KB225501 November 3, 2013
- 891116 FIX: The SET ANSI_PADDING ON option may not work as expected when you run a query that contains a CASE statement in SQL Server 7.0 Q891116 KB891116 November 2, 2013
- 828090 FIX: Error 1203 Is Reported in the SQL Server Error Log When You Run the xp_sendmail Stored Procedure Q828090 KB828090 November 2, 2013
- 823878 FIX: Heap Allocations Are Slower for Computers That Have More Than Four Processors Q823878 KB823878 November 2, 2013
- 813492 FIX: Create Index Fails on SQL Server 7.0 When Trace Flag 1118 is Enabled Q813492 KB813492 November 2, 2013
- 326896 FIX: Rollback of Bound Transaction May Cause Assertion Errors Q326896 KB326896 November 2, 2013
- 323118 FIX: Unexpected Close of a SQL Server Connection May Lead to an Access Violation Q323118 KB323118 November 2, 2013
- 319699 FIX: @@IDENTITY Does Not Process a New Value When You Use INSERT EXEC Q319699 KB319699 November 2, 2013
- 319212 FIX: Commit Causes an Assertion and the SQL Server Program Stops Responding or Closes Q319212 KB319212 November 2, 2013
- 294445 FIX: Error Message 2731 Occurs When You Create a Table with a Column Length of Zero Q294445 KB294445 November 2, 2013
- 286787 FIX: Incorrect Results From Full-Text Search on Several Columns Q286787 KB286787 November 2, 2013
- 286257 FIX: DBCC CHECKTABLE May Fail if Table has a Text/Image Column and Long Clustering Key Q286257 KB286257 November 2, 2013
- 286171 FIX: Parallel Query Results Cause an Access Violation in CQList::Append Q286171 KB286171 November 2, 2013
- 284237 FIX: SELECT Statement with Two LIKE Clauses Where the Table Has a CHECK Constraint Causes AV Q284237 KB284237 November 2, 2013
- 283899 FIX: Adding Several Constraints in a Single ALTER TABLE Statement May Get Assertion Followed by Error 3624 Q283899 KB283899 November 2, 2013
- 281137 FIX: Script Generation Using SQL-DMO Results in Database Name That Is Too Long Q281137 KB281137 November 2, 2013
- 281129 FIX: Update of Table with Large varchar Columns May Cause Access Violation Q281129 KB281129 November 2, 2013
- 280808 FIX: SQL Server 7.0 pull subscriber applies obsolete SQL Server 2000 Merge Agent snapshot Q280808 KB280808 November 2, 2013
- 280361 FIX: "Generate SQL Script" in Enterprise Manager May Not Script Out the Correct Permissions Q280361 KB280361 November 2, 2013
- 279823 FIX: Restore of a Database Gives Error 4038 Due to Malformed Media Set Q279823 KB279823 November 2, 2013
- 279793 FIX: Error Message 602 During Recovery of a Database Q279793 KB279793 November 2, 2013
- 279511 FIX: DBCC SHRINKFILE with Empty Option May Not Move Heap and Text Pages Q279511 KB279511 November 2, 2013
- 278671 FIX: Slow Query Performance When Non-SA Executes Query That Causes Trigger to Access the INSERTED or DELETED Tables Q278671 KB278671 November 2, 2013
- 278536 FIX: SQL 7.0 Setup Does Not Install Licensing on Terminal Server Q278536 KB278536 November 2, 2013
- 278022 FIX: Bulk Insert May Give Extra Characters When Converting Text from Multi-byte to Single-byte Codepage Q278022 KB278022 November 2, 2013
- 277809 FIX: A Non-Sysadmin May Execute sp_procoption Stored Procedure Q277809 KB277809 November 2, 2013
- 277738 FIX: Aggregations in Parallel Query May Generate Incorrect Results Q277738 KB277738 November 2, 2013
- 276048 FIX: Access Violation Occurs in COledbError::RaiseRestartPositionError When You Run a Full Text Query Q276048 KB276048 November 2, 2013
- 275721 FIX: Execution of Stored Procedure with Local Temp Table and Indexes May Fail or Return Incorrect Results Q275721 KB275721 November 2, 2013
- 275624 FIX: Identity Value Recovery May Fail After a Nonlogged Bulk Load Q275624 KB275624 November 2, 2013
- 275622 FIX: Datetime Column Defaults Load Incorrectly During BULK INSERT Q275622 KB275622 November 2, 2013
- 274995 FIX: Plan Reuse Gives Incorrect Query Results Q274995 KB274995 November 2, 2013
- 268868 FIX: Query Analyzer Uses the Wrong Color Coding for Commands Q268868 KB268868 November 2, 2013
- 266766 FIX: Temporary Stored Procedures in SA Owned Databases May Bypass Permission Checks When You Run Stored Procedures Q266766 KB266766 November 2, 2013
- 264880 FIX: Passwords May Be Retrieved from Enterprise Manager and from a DTS Package with No Owner Password Q264880 KB264880 November 2, 2013
- 264229 FIX: SELECT Statement Assigns Incorrect Values to NUMERIC or DECIMAL Variables When Used Multiple Times Q264229 KB264229 November 2, 2013
- 264041 FIX: DBCC CHECKALLOC May Inaccurately Report Errors 8968 and 8998 Q264041 KB264041 November 2, 2013
- 260742 FIX: DBCC DBREINDEX might cause system table referential integrity problems (2513 error) Q260742 KB260742 November 2, 2013
- 260722 FIX: Plaintext Stored Procedures Appear as Encrypted Text in SQL Server Profiler Trace File Q260722 KB260722 November 2, 2013
- 260700 FIX: Optimizer Selects Table Scan Instead of Index Covering the ORDER BY Clause for a Single Table Select Q260700 KB260700 November 2, 2013
- 260254 FIX: Rollback of Transactions Named as Empty String Cause Access Violations Q260254 KB260254 November 2, 2013
- 259956 FIX: Text Field Data Truncated When Double Byte Character Spans Page Break Q259956 KB259956 November 2, 2013
- 258226 FIX: DBCS Space Is Not Treated Correctly Q258226 KB258226 November 2, 2013
- 257515 FIX: DMO ExecuteWithResults Fails with Decimal Data Q257515 KB257515 November 2, 2013
- 255712 FIX: UPDATE May Fail to Update All the Qualifying Rows on Multi-Proc Computers Q255712 KB255712 November 2, 2013
- 254806 FIX: QUERY Statement Causes 512 Error When You Access a View Q254806 KB254806 November 2, 2013
- 253738 FIX: SQL Server Components that Access the Registry in a Cluster Environment May Cause a Memory Leak Q253738 KB253738 November 2, 2013
- 252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table Q252905 KB252905 November 2, 2013
- 251187 FIX: Logreader Fails When It Processes an Update with the Trace Flag 8202 Set ON Q251187 KB251187 November 2, 2013
- 250506 FIX: Concurrent Execution of Stored Procedure That Recompiles May Fail To Execute All Statements Q250506 KB250506 November 2, 2013
- 249119 FIX: SQL Server May Stop Without Any Information by BULK INSERT Q249119 KB249119 November 2, 2013
- 248618 FIX: SQL Server Returns Incorrect Value for a Bit Field When You Use a Static Cursor On Joined Tables Q248618 KB248618 November 2, 2013
- 248441 FIX: Incorrect Results with Self Insert and Subquery Q248441 KB248441 November 2, 2013
- 247749 FIX: Column Level Permissions Is Not Scripted When Generated Using Enterprise Manager When Table Level Permissions Exist for That Role or User Q247749 KB247749 November 2, 2013
- 247191 FIX: SQL Server 7.0 Slower than SQL Server 6.5 on Join with View Containing CASE and Subquery Q247191 KB247191 November 2, 2013
- 243741 FIX: Replication Initialize Method Causes Handle Leak on Failure Q243741 KB243741 November 2, 2013
- 243504 FIX: Replication Snapshot Agent May Fail with Access Violation Error When A Long Filter Clause is Used Q243504 KB243504 November 2, 2013
- 240036 FIX: Distribution Agent Ignores Error on Pre-Creation Command Q240036 KB240036 November 2, 2013
- 240035 FIX: Logreader Failure with TEXT/IMAGE Data Inserted Through BCP Q240035 KB240035 November 2, 2013
- 239717 FIX: SQLDMO - Setting BULKCOPY.SuspendIndexing = True May Fail Q239717 KB239717 November 2, 2013
- 236045 FIX: Upgrade Wizard GUI Allows Adding of New File Groups to Model and TempDB Databases Q236045 KB236045 November 2, 2013
- 233522 FIX: DBCC DBREINDEX on a Table Without any Indexes Creates Error Q233522 KB233522 November 2, 2013
- 233027 FIX: Cannot Properly Add IPX/SPX Address to Server Network Utility Q233027 KB233027 November 2, 2013
- 229003 FIX: Error 21770 When Trying to Manage Permissions For User-Owned Stored Procedures in SEM Q229003 KB229003 November 2, 2013
- 224998 FIX: Incorrect Locking with a Dynamic Cursor FETCH LAST Operation and a Serializable Transaction Q224998 KB224998 November 2, 2013
- 224805 FIX: Index Tuning Wizard Recommends That Indexes for System Tables Be Dropped Q224805 KB224805 November 2, 2013
- 224329 FIX: Merge Initial Sync With Dynamic Filters Takes Long Time to Synchronize Q224329 KB224329 November 2, 2013
- 199763 FIX: Client Apps Stop Responding When Running Server-Side Cursors Against Stored Procedures Q199763 KB199763 November 2, 2013
- 196771 FIX: @@language Value Can Be Truncated After Changing Value Q196771 KB196771 November 2, 2013
- 311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128 Q311000 KB311000 November 1, 2013
- 220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special Characters Q220156 KB220156 November 1, 2013
- 201857 FIX: BCP Format File Field Length Does Not Behave as Documented Q201857 KB201857 November 1, 2013
- 201834 FIX: BULK INSERT Fails when FIRSTROW is Greater Than 1 for Text That Contains Data Q201834 KB201834 November 1, 2013
- 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
- 816759 FIX: SqlClient Throws "Timeout Expired" with Extended Stored Procedure Q816759 KB816759 October 26, 2013
- 814693 FIX: SQL Server 7.0 Scheduler May Periodically Stop Responding During Large Sort Operation Q814693 KB814693 October 26, 2013
- 811953 FIX: SQL Server Thread Goes into an Infinite Loop When it Runs Sp_MSdbuseraccess Q811953 KB811953 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
- 313247 FIX: Existing Users Lose Connectivity If Error Message 17836 Occurs Q313247 KB313247 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
- 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
- 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
- 252865 FIX: Replay of Prepared Cursor Statements May Generate Error 16902 Q252865 KB252865 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
- 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
- 246607 FIX: ODS Function Srv_describe May Fail on Certain Type Conversions Q246607 KB246607 October 26, 2013
- 246323 FIX: Check Constraint Is Not Enforced if Marked "Not for Replication" Q246323 KB246323 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
- 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
- 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
- 233525 FIX: Mmc.exe Remains in the Task List After Closing the Console Window Q233525 KB233525 October 26, 2013
- 232522 FIX: Error 16943 When Dropping Pull Subscription with 'ALL' as Parameter Value Q232522 KB232522 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
- 196790 FIX: BULK INSERT with BATCHSIZE Disregards LASTROW Parameter Q196790 KB196790 October 26, 2013
- 195757 Frequently asked questions - SQL Server 7.0 - Replication Q195757 KB195757 October 26, 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 274353 FIX: Query Analyzer: Empty Row is Returned with COMPUTE on SMALLINT Data Q274353 KB274353 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 236068 FIX: Null Parameter for DTS Lookup Causes MMC to Exit Q236068 KB236068 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
- 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
- 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
- 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
- 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
- 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
- 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
- 260087 FIX: Large Error Numbers May Cause Heap Corruption in SQLServerAgent Service Q260087 KB260087 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
- 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
- 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
- 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
- 223257 FIX: RPC Using SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT May Cause AV Q223257 KB223257 October 20, 2013
- 221243 FIX: Users Added Through Windows NT Groups Not Able to View List of Tables Q221243 KB221243 October 20, 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
- 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
- 208927 FIX: Transfer Manager Leaves Open Connection in Source DB Q208927 KB208927 October 11, 2013
- 207451 FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed Q207451 KB207451 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
- 201533 FIX: Enterprise Manager Displays 'SQL Server Standard' for Desktop Edition Q201533 KB201533 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
- 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
- 198265 FIX: Failed Sp_prepare Incorrectly Closes Transaction Q198265 KB198265 October 11, 2013
- 198163 FIX: FT Wizard Fails with Windows NT Authentication and Not Sysadmin Q198163 KB198163 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
- 197385 FIX: DTSRun: Package Reports False Success with User Password Q197385 KB197385 October 11, 2013
- 196919 FIX: Descending Index Scans May Block with High Transaction Isolation Q196919 KB196919 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
- 311231 Frequently asked questions - SQL Server - SQL Mail Q311231 KB311231 September 12, 2013
- 246815 FIX: Sqlmaint.exe is Not Included in MSDE 1.0 Installation Q246815 KB246815 January 24, 2013
- 234673 FIX: ITransactionResourceAsync::TMDown not Delivered to Resource Manager Q234673 KB234673 June 11, 2012
- 230145 FIX: Mtxoci.dll Logging Support Enabled Q230145 KB230145 June 6, 2012
- 835581 FIX: An "Error 17883" error message may be logged, and SQL Server 2000 or SQL Server 7.0 may stop responding when you run an application that creates COM objects by using the sp_OACreate function Q835581 KB835581 October 9, 2011
- 219416 FIX: Duplicate Hash Keys Erroneously Generated for Two Distinct Index Key Values Q219416 KB219416 September 17, 2011
- 309450 FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE Q309450 KB309450 November 30, 2007
- 283860 FIX: "Cannot Open Database Requested" Error Connecting to Remote SQL Server Q283860 KB283860 November 30, 2007
- 279113 FILE: Use Xpvmlog to Dump the Layout of Virtual Memory in SQL Server Q279113 KB279113 November 30, 2007
- 820788 FIX: Delayed domain authentication may cause SQL Server to stop responding Q820788 KB820788 November 27, 2007
- 831801 FIX: SQLStatistics function returns incorrect sort order sequence Q831801 KB831801 November 5, 2007
- 317989 FIX: Sqlakw32.dll May Corrupt SQL Statements Q317989 KB317989 November 2, 2007
- 319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers Q319507 KB319507 October 29, 2007
- 297105 FIX: Potential English Query Security Issue Q297105 KB297105 October 26, 2007
- 239473 FIX: 70rebind.exe for Windows 2000 and MDAC upgrades on clustered SQL Server 7.0 servers Q239473 KB239473 October 26, 2007
- 280380 FIX: Buffer Overflow Exploit Possible with Extended Stored Procedures Q280380 KB280380 September 5, 2007
- 257657 FIX: Edit/Update Fails for SQL 7.0 for Column of Type Text When CursorDriver Is Set to rdUseODBC Q257657 KB257657 August 7, 2007
- 274314 FIX: SQL Server 7.0 SP2 Unattended Client Setup Results in "MMC Snap-In Failed to Initialize" Error Message Q274314 KB274314 July 18, 2007
- 325338 FIX: OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When You Call the Cancel() Method Q325338 KB325338 February 22, 2007
- 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 Q829015 KB829015 February 21, 2007
- 300519 FIX: Problems occur when connecting to SQL Server from ADO application Q300519 KB300519 February 15, 2007
- 279760 FIX: MDAC 2.6 SQLOLEDB Provider Running on Windows 2000 Returns No Error Text Description Q279760 KB279760 February 12, 2007
- 305385 Frequently asked questions about the Microsoft Network Security Hotfix Checker (HFNetChk) functionality that is integrated into the Microsoft Baseline Security Analyzer (MBSA) Q305385 KB305385 January 31, 2007
- 274354 FIX: FAST_FORWARD Cursors Perform Slower Q274354 KB274354 August 7, 2006
- 247069 FIX: Using ICommandPrepare->Prepare() May Cause ICommand->Execute() not to Report Errors Q247069 KB247069 August 7, 2006
- 276234 FIX: SQLMaint.exe Sets Database Status Incorrectly Q276234 KB276234 July 19, 2006
- 259141 FIX: SP2 Regression: 8624 Error Might Occur When You Modify a Table with a Complex Query Q259141 KB259141 July 19, 2006
- 241356 FIX: "Invalid Pointer" Error When Creating Calculated Member in a Local Cube Q241356 KB241356 July 19, 2006
- 235332 FIX: SQLOLEDB: IRowset::SetData() Returns DB_E_ERRORSOCCURRED with Identity Column Q235332 KB235332 May 5, 2006
- 230301 FIX: French BOL Table of Contents Missing Four Topics Q230301 KB230301 May 5, 2006
- 312935 FIX: SQL Server fails to bind TCP/IP port at startup Q312935 KB312935 April 7, 2006
- 284440 FIX: UPDATE with CASE Statement That Uses NEWID() Function Causes Errors 8951, 8952, 8955 and 8956 Q284440 KB284440 March 14, 2006
- 283036 FIX: Setting Retention Period of a Merge Publication Can Drop Subscriptions Q283036 KB283036 March 14, 2006
- 283034 FIX: Merge Replication Fails After a Call to sp_MSgetrowmetadata Q283034 KB283034 March 14, 2006
- 281617 FIX: SQLMAINT Backup to Tape with Verify Only Checks the First File Q281617 KB281617 March 14, 2006
- 281295 FIX: Merge Replication Synchronization May Be Slow Q281295 KB281295 March 14, 2006
- 281185 FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349 Q281185 KB281185 March 14, 2006
- 278509 FIX: Distribution Agent Ignores Quoted Identifier Option on Initial Sync to Oracle Subscribers Q278509 KB278509 March 14, 2006
- 278360 FIX: NT User and Domain Name May Not Be Recorded by SQL Profiler for a Standard Security Connection Q278360 KB278360 March 14, 2006
- 277737 FIX: Merge Replication Reports Misleading Conflict When Using Horizontal Filtering Q277737 KB277737 March 14, 2006
- 277640 FIX: Denial of Service Attack with NULL Bytes in RPC Request Q277640 KB277640 March 14, 2006
- 276529 FIX: SP2 Regression - Update Queries with Hash Joins Do Not Update Any Rows Q276529 KB276529 March 14, 2006
- 276039 FIX: Duplicate Hash Keys Generated for Two Distinct Index Key Values on Non-Unique Clustered Index Q276039 KB276039 March 14, 2006
- 275690 FIX: SQL Server Agent Startup May be Delayed by Four Seconds Q275690 KB275690 March 14, 2006
- 275614 FIX: Bulk Insert Does Not Insert Next Row When a Truncate Error Occurs Q275614 KB275614 March 14, 2006
- 275593 FIX: DELETE Results in 8908 Error Message When You Use a Parallel Plan Q275593 KB275593 March 14, 2006
- 275483 FIX: Insert Error (Msg 213 ) with NO_BROWSETABLE and INSERT EXEC Q275483 KB275483 March 14, 2006
- 275304 FIX: Access Violation with Queries that Involve Hash Join on Large Data Sets Q275304 KB275304 March 14, 2006
- 275145 FIX: Only One SQL Server Performance Condition Alert Is Treated As Active Q275145 KB275145 March 14, 2006
- 274716 FIX: Error "The System Cannot Find the File Specified" When You Open a DTS Package Q274716 KB274716 March 14, 2006
- 274706 FIX: Regression: Compilation of Many UNIONs Takes Excessively Long Time Q274706 KB274706 March 14, 2006
- 274483 FIX: Unable to choose article resolver when you use SQL Server 2000 distributor and SQL Server 7.0 publisher Q274483 KB274483 March 14, 2006
- 274467 FIX: Queries with TOP N PERCENT in Subquery May Fail with Error Message 8623 Q274467 KB274467 March 14, 2006
- 274310 FIX: Error 823 or 8966 Reported by SQL Server with Insufficient System Resources Q274310 KB274310 March 14, 2006
- 271760 FIX: Incorrect Aggregates After "Incremental Update" of Cube from DTS Q271760 KB271760 March 14, 2006
- 269282 FIX: Error Message 602 Occurs When You Query a Temporary Table That Has a Non-Clustered Index Q269282 KB269282 March 14, 2006
- 268413 FIX: SP2 Regression: DTS Transfer Fails with Access Violation if Destination Server is Unnamed Q268413 KB268413 March 14, 2006
- 268275 FIX: Transactional ActiveX Pull Subscribers May Expire Even If They Synchronize Within Retention Period Q268275 KB268275 March 14, 2006
- 268153 FIX: Distributed Query with NO_BROWSETABLE Against Timestamp Column Can Cause Access Violation Q268153 KB268153 March 14, 2006
- 268081 FIX: Error Message 1511 Occurs When You Restore a Database or Transaction Log Dump Q268081 KB268081 March 14, 2006
- 266372 FIX: OPTION (MAXDOP 1) Hint May Not Turn Off Parallel Query Q266372 KB266372 March 14, 2006
- 266368 FIX: Updates That Use LEFT OUTER JOIN May Not Complete if Parallelism Is Used Q266368 KB266368 March 14, 2006
- 264687 FIX: ADO Applications Report a Syntax Error When Column Names Contain Spaces Q264687 KB264687 March 14, 2006
- 264646 FIX: Snapshot Agent Fails with 4408 Error Message If a Merge Publication Contains a Large Number of Join Filters Q264646 KB264646 March 14, 2006
- 264005 FIX: Error Message 8623 Occurs If You Use INSERT-SELECT with NOT IN or NOT EXISTS Keywords in Subquery of the WHERE Clause Q264005 KB264005 March 14, 2006
- 263955 FIX: Merge Agent Fails with "Setting Sentgen Too High" Error Message Q263955 KB263955 March 14, 2006
- 262462 FIX: Conversion Errors Occur in Prepared Statements That Use UNIONs Q262462 KB262462 March 14, 2006
- 261216 FIX: Snapshot Agent for a Merge Publication Might Fail with Error Message 4408 or 50007 Q261216 KB261216 March 14, 2006
- 261133 FIX: DTS "Send Mail" Fills Up Mailbox and Outlook Cannot See or Delete E-Mail Messages Q261133 KB261133 March 14, 2006
- 259775 FIX: ISNULL with ANSI_WARNINGS OFF Drops Connection On Divide By Zero Q259775 KB259775 March 14, 2006
- 259551 FIX: Database Remains in Single User Mode with the Database Maintenance Plan Option "Repair Any Minor Problems" Q259551 KB259551 March 14, 2006
- 258974 FIX: Query Analyzer Might Not Save All Rows in the Result Set to a File When You Use the "Results in Grid" Option Q258974 KB258974 March 14, 2006
- 258198 FIX: Error Message 8630 Occurs When Updates are Performed to a Table with Compound Keys Q258198 KB258198 March 14, 2006
- 257425 FIX: DTS Object Transfer Does Not Transfer BLOB Data Greater Than 64 KB Q257425 KB257425 March 14, 2006
- 257424 FIX: Problem Upgrading Japanese Database Servers to Windows 2000 After Installing Service Pack 2 Q257424 KB257424 March 14, 2006
- 256307 FIX: Error Message 547: "Update statement conflicted with TABLE.." Q256307 KB256307 March 14, 2006
- 255688 FIX: Static Filtered Merge Publications Take Long Time to Synchronize Q255688 KB255688 March 14, 2006
- 254253 FIX: DBCC ShrinkDatabase or ShrinkFile Commands May Cause Errors 5042 and 3140 Q254253 KB254253 March 14, 2006
- 253810 FIX: Merge Agent Fails with a "The remote procedure call failed and did not execute" Error Q253810 KB253810 March 14, 2006
- 253230 FIX: SEM: Appended Backup Database with Verify Always Checks Only FILE Number = 1 Q253230 KB253230 March 14, 2006
- 249294 FIX: Password Fails to Meet Password Policy Requirements Q249294 KB249294 March 14, 2006
- 249210 FIX: Cancellation of DTS OLAP Processing Task May Result in Processing Errors Later Q249210 KB249210 March 14, 2006
- 248442 FIX: Error 515 with Concatenated NULLs in WHERE Clause and ORDER BY Q248442 KB248442 March 14, 2006
- 247641 FIX: Trusted TCP/IP Socket Connection May Fail with Error Message 18452 Q247641 KB247641 March 14, 2006
- 246612 FIX: Malformed RPC TDS Packet Causes Various AVs Q246612 KB246612 March 14, 2006
- 246201 FIX: Subquery with ORDER BY may Return Results in Wrong Order Q246201 KB246201 March 14, 2006
- 244962 FIX: Calling a Stored Procedure with Text/Image Parameters using ADO May Cause an Access Violation Q244962 KB244962 March 14, 2006
- 243093 FIX: Using an IP Address for OLAP Data Source Connection Property Causes Error Q243093 KB243093 March 14, 2006
- 243027 FIX: Numeric Column in Oracle Causes Error 7354 Q243027 KB243027 March 14, 2006
- 241717 FIX: Update Statement Conflicts with Foreign Key Constraint Q241717 KB241717 March 14, 2006
- 240833 FIX: Full-Text Search Support for TOP via CONTAINSTABLE and FREETEXTTABLE Clauses Q240833 KB240833 March 14, 2006
- 239883 FIX: SYBASE CT-Library Clients Cannot Connect to Microsoft SQL Server 7.0 Q239883 KB239883 March 14, 2006
- 238355 FIX: SQLOLEDB Resends Prepared Commands with Client Cursors Q238355 KB238355 March 14, 2006
- 236868 FIX: DMO Transfer Methods Does Not Perform Code Page Conversion Q236868 KB236868 March 14, 2006
- 235693 FIX: Select Query with GROUP BY and Outer Join Causes Handled Access Violation Q235693 KB235693 March 14, 2006
- 235281 FIX: Negative 0 (zero) Causes ODBC SQL Server Driver Error Q235281 KB235281 March 14, 2006
- 234915 FIX: Upgrade to SQL Server Fails When MSDE Installed from MOD Q234915 KB234915 March 14, 2006
- 233553 FIX: Non-Clustered Fillfactor Reset When Clustered Index Created Q233553 KB233553 March 14, 2006
- 233491 FIX: Cannot Link OLAP Servers in SQL Server Enterprise Linked Server Q233491 KB233491 March 14, 2006
- 233202 FIX: Configuration Fails Pasting Distributor Database Name with a Leading Space Q233202 KB233202 March 14, 2006
- 230268 FIX: ANSI Join with DATEDIFF in the SELECT List May Cause Error 8624 Q230268 KB230268 March 14, 2006
- 229480 FIX: Disabled Importing File in DTS Import CMD Dialog Box Q229480 KB229480 March 14, 2006
- 229086 FIX: Logreader Reports Timeout Error on Sp_repldone or Sp_replcmds Q229086 KB229086 March 14, 2006
- 229075 FIX: Transfer Objects Fails if SP Preceded by Multi-line Comment Q229075 KB229075 March 14, 2006
- 229007 FIX: SpaceAvailableInMB Property Returns Used Space Instead of Available Space Q229007 KB229007 March 14, 2006
- 228933 FIX: 'Unspecified Error' Message Returned Placing a NULL in a Non-NULL Column Q228933 KB228933 March 14, 2006
- 228473 FIX: Adding Merge Subscription Fails with Error 8115 Q228473 KB228473 March 14, 2006
- 225084 FIX: IE 5.0 Hinders SQL Server 7.0 Wizards and Tabbed Dialogs on Windows 95 or 98 Computers Q225084 KB225084 March 14, 2006
- 221558 FIX: Executing Sp_replcounters with INSERT..EXEC May Cause Server to Stop Responding Q221558 KB221558 March 14, 2006
- 217036 FIX: Logreader Tasks Not Upgraded from SQL Server 6.5 to 7.0 Q217036 KB217036 March 14, 2006
- 217019 FIX: RAISERROR Does Not Work with SQLOLEDB Provider Q217019 KB217019 March 14, 2006
- 199688 FIX: @@IDENTITY Returns NULL If Trigger Inserts into Table Without IDENTITY Column Q199688 KB199688 March 14, 2006
- 311111 FIX: The remote procedure call (RPC) client cannot connect to a server that is running SQL Server and is configured to use "Windows only" authentication Q311111 KB311111 December 1, 2005
- 819949 FIX: You Receive Unexpected Results with Data Modification Language Operations of Both Parent and Child Tables with Declarative Referential Integrity Q819949 KB819949 October 25, 2005
- 819773 FIX: You may notice a 17803 error and an access violation when you run a query on an instance of SQL Server 7.0 Q819773 KB819773 October 25, 2005
- 300181 FIX: DTS Error Message Repeated Multiple Times When You Import from a Text File Q300181 KB300181 October 19, 2005
- 324146 FIX: SQL Server 7.0 sp_OASetProperty Method Does Not Accept More Than 255 Characters Q324146 KB324146 October 18, 2005
- 321823 FIX: Provider Option Supports Remoting of Enhanced LIKE Predicates Q321823 KB321823 October 18, 2005
- 319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED Q319851 KB319851 October 18, 2005
- 324469 FIX: Error message 9004 may occur when you restore a log that does not contain any transactions Q324469 KB324469 October 12, 2005
- 329878 FIX: Cannot Connect to Port '1433' Using Sockets After You Apply SQL Server 7.0 Service Pack 4 Q329878 KB329878 October 11, 2005
- 329499 FIX: Replication Removed from Database After Restore WITH RECOVERY Q329499 KB329499 October 11, 2005
- 325720 FIX: An access violation occurs when a cursor is defined on a query that has nested subqueries Q325720 KB325720 October 11, 2005
- 319246 FIX: Error Dialog Box During SQL Server Database Backup Q319246 KB319246 October 11, 2005
- 315559 FIX: ESQL/C Precompiler May Cause Access Violation When It Processes a Complex ESQL Project Q315559 KB315559 October 11, 2005
- 290817 FIX: Error 8624 may occur with subquery that contains aggregate or computed columns Q290817 KB290817 October 7, 2005
- 257670 FIX: OLE DB Provider for SQL Server May Cause Incorrect Code Conversion of Some Characters Q257670 KB257670 October 7, 2005
- 239458 FIX: Replication: Problems Mapping Characters to DB2 OLEDB Subscribers Q239458 KB239458 October 5, 2005
- 232707 FIX: Query with Complex View Hierarchy May Be Slow to Compile Q232707 KB232707 October 5, 2005
- 328569 FIX: Ad Hoc Access Incorrectly Permitted If DisallowAdhocAccess Registry Key Is Missing Q328569 KB328569 September 27, 2005
- 317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source Q317979 KB317979 September 27, 2005
- 313661 FIX: Error Message: "Timeout expired" Occurs When You Connect to SQL Server Over TCP/IP and the Kerberos MaxTokenSize is Greater Than 0xFFFF Q313661 KB313661 September 26, 2005
- 310572 FIX: Cursor Type and Column Updatability May Change with Some Sort Orders Q310572 KB310572 September 26, 2005
- 308881 FIX: AV on DECLARE CURSOR with Correlated Subquery and KEYSET or DYNAMIC Cursor Type Q308881 KB308881 September 26, 2005
- 308114 FIX: Query with Multiple Predicates and a Star Join May Cause an Access Violation Q308114 KB308114 September 26, 2005
- 307540 FIX: SQLPutData May Result in Leak of Buffer Pool Memory Q307540 KB307540 September 26, 2005
- 306096 FIX: Infinite Loop Occurs in ESQL Application That Uses Keyset Cursor Q306096 KB306096 September 26, 2005
- 300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow Q300420 KB300420 September 26, 2005
- 297035 FIX: Correlation Error Using Parameters.Refresh with SQLOLEDB Q297035 KB297035 September 26, 2005
- 281633 FIX: SQLOLEDB Provider incorrectly leaves transaction open Q281633 KB281633 September 26, 2005
- 279180 FIX: Bcp.exe with Long Query String Can Result in Assertion Failure Q279180 KB279180 September 26, 2005
- 273813 FIX: "Incorrect Syntax near the Keyword 'by' " Error Message with Column Names of "C", "CA" or "CAS" Q273813 KB273813 September 26, 2005
- 262519 FIX: SQLSetCursorName Fails When "Use ANSI Quoted Identifiers" Is Cleared Q262519 KB262519 September 26, 2005
- 247527 FIX: DTS May Truncate Characters When You Export a Table Column of Character Data Type to a Text File Q247527 KB247527 June 23, 2005
- 308822 FIX: Cardinality estimates may be incorrect for a table created and populated in the same transaction Q308822 KB308822 November 29, 2004
- 249730 FIX: A SQL Server 7.0 Transact-SQL scheduled task may run slower in SQL Server 7.0 and SQL Server 2000 Q249730 KB249730 November 17, 2004
- 299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have Q299717 KB299717 August 9, 2004
- 308267 FIX: DTS Copy Objects Task (DMO) breaks transaction log backup chain by switching recovery mode to Simple during transfer Q308267 KB308267 July 27, 2004
- 294809 FIX: Full-Text Search Queries with CONTAINS Clause Search Across Columns Q294809 KB294809 July 16, 2004
- 290629 FIX: Update Query That Uses Star Joins May Cause Access Violation Q290629 KB290629 July 16, 2004
- 274266 FIX: Data Modification Query with a Distinct Subquery on a View May Cause Error 3624 Q274266 KB274266 July 15, 2004
- 276499 FIX: SP2 Regression: Running a Stored Procedure with Index on Local Temp Table Causes AV Q276499 KB276499 July 14, 2004
- 319691 FIX: Merge Subscriptions May Reinitialize Unexpectedly If Incremental Schema Change Fails Q319691 KB319691 June 30, 2004
- 308627 FIX: DBCC SHRINKDATABASE or DBCC SHRINKFILE May Expand Database with Text or Image Data Q308627 KB308627 June 29, 2004
- 308016 FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000 Q308016 KB308016 June 29, 2004
- 307541 FIX: Error 1203 and Failed Assertion Occurs When You Run a Query with a Parallel Plan Q307541 KB307541 June 29, 2004
- 302664 FIX: Query with SET NO_BROWSETABLE Option Set ON May Generate Access Violation Q302664 KB302664 June 28, 2004
- 174479 FIX: Lazywriter Access Violation During DUMP Activity Q174479 KB174479 February 20, 2004
- 170507 FIX: READTEXT May Fail w/ Msg 7134 If Hard Coding Text Pointer Q170507 KB170507 February 20, 2004
- 308801 FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them Q308801 KB308801 October 31, 2003
- 307533 FIX: Distribution Agent May Encounter Error 8115 in the Sp_MSadd_distribution_history Stored Procedure Q307533 KB307533 October 31, 2003
- 306853 FIX: SQL Server Enterprise Manager Restore Database Wizard Restores Database to Different Location or Name Q306853 KB306853 October 31, 2003
- 301060 FIX: Import of Text File Results in Error "Column Delimiter not found" Q301060 KB301060 October 31, 2003
- 298832 FIX: Uppercase Characters are not Sorted Before Their Corresponding Lowercase Characters When You Use the Nocasepref Sort Order Q298832 KB298832 October 31, 2003
- 297271 FIX: Point in Time Recovery May Recover Database if the Transaction Log That is Applied Does Not Contain Any Transactions Q297271 KB297271 October 31, 2003
- 296456 FIX: Full Text Query May Return 0 Rows When Valid Results are Present Q296456 KB296456 October 31, 2003
- 296045 FIX: Merge Snapshot Agent Fails with Error 50007: "Too many table names in the query. The maximum allowable is 256." Q296045 KB296045 October 31, 2003
- 293758 FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2 Q293758 KB293758 October 31, 2003
- 290915 FIX: CREATE for Existing Object with IDENTITY Column Causes Duplicate IDENTITY Values Q290915 KB290915 October 31, 2003
- 290646 FIX: SQLColAttribute Returns Incorrect Table Attributes When Table Name Contains a Period Q290646 KB290646 October 31, 2003
- 286788 FIX: Server Side Cursor May Return Incorrect Results Q286788 KB286788 October 31, 2003
- 286737 FIX: FetchBufferSize Greater than Certain Number Fails to Transfer all Rows and Does Not Return an Error Q286737 KB286737 October 31, 2003
- 281287 FIX: Msg 8964 on Index with IGNORE_DUP_KEY and Row Has a Text Column Q281287 KB281287 October 31, 2003
- 280744 FIX: Update Query Returns Error 1903 if Temporary Composite Index Over 900 Bytes Q280744 KB280744 October 31, 2003
- 278978 FIX: SELECT May Not Return All Rows if It Contains a Large Number of Values in an IN Clause on a NUMERIC Column Q278978 KB278978 October 31, 2003
- 275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221 Q275901 KB275901 October 31, 2003
- 275618 FIX: Cannot Set SQLServerAgent Password to More Than 16 Characters in Enterprise Manager Q275618 KB275618 October 31, 2003
- 271945 FIX: SQL Agent Appends Garbled Characters to Output File Q271945 KB271945 October 31, 2003
- 267953 FIX: Interleaving Prepare And Adhoc Execute of Query May Cause Recompile Loop Q267953 KB267953 October 31, 2003
- 260182 FIX: Unable to Restore to a Point in Time in First Transaction Log Backup Q260182 KB260182 October 31, 2003
- 259304 FIX: DTS Fails to Import Last Row If There is No Last Row Terminator Q259304 KB259304 October 31, 2003
- 319701 FIX: SQL Enterprise Manager RESTORE Msdb Leaves Database in Loading State and Does Not Apply Differential or Log Backups Q319701 KB319701 October 30, 2003
- 319698 FIX: Transform Data Task Might Stop Responding (hang) While Importing Data From Text File Q319698 KB319698 October 30, 2003
- 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 Q319697 KB319697 October 30, 2003
- 319690 FIX: Sqldiag.exe Cannot Generate the Winmsd Report on Windows 2000 for the Sqldiag.txt File Q319690 KB319690 October 30, 2003
- 308758 FIX: SQL Agent Mail May Cause E-mail to Be Written to Root Directory of Source Mailbox Q308758 KB308758 October 30, 2003
- 308745 FIX: SET NOEXEC OFF May Not Execute If Included in Same Batch as SET NOEXEC ON Q308745 KB308745 October 30, 2003
- 295378 FIX: SQLAgent Job with Recurring Schedule is Disabled Upon Completion of the Schedule for the Day Q295378 KB295378 October 30, 2003
- 294388 FIX: Reading Perflib Registry Values Terminates SQL Server Startup with Fatal Exception Q294388 KB294388 October 30, 2003
- 287401 FIX: Unable to Use GOTO in an Execute SQL Task of a DTS Package Q287401 KB287401 October 30, 2003
- 281843 FIX: SQLDMO GetProcessInputBuffer Returns Incorrect Result Q281843 KB281843 October 30, 2003
- 302828 FIX: DTS Fails to Transfer Rows When a Non-Sysadmin User Opens Packages from T-SQL with Xp_cmdshell Q302828 KB302828 October 29, 2003
- 301642 FIX: SQL Server Error Message 6002 Is Returned with an Incorrect Severity Q301642 KB301642 October 29, 2003
- 293636 FIX: Invoking SQL-DMO Methods By Using "By Reference" Parameters May Cause a Memory Leak Q293636 KB293636 October 29, 2003
- 288426 FIX: Alerts Triggered Incorrectly When Security Auditing is Enabled Q288426 KB288426 October 29, 2003
- 282243 FIX: Incorrect Results with Join of Column Converted to Binary Q282243 KB282243 October 29, 2003
- 308834 FIX: Incorrect Display of Error Log in Enterprise Manager Q308834 KB308834 October 28, 2003
- 295032 FIX: Job Step Fails if First INSERT of Batch Job Encounters a Msg 3604 Error Q295032 KB295032 October 28, 2003
- 285870 FIX: Update With Self Join May Update Incorrect Number Of Rows Q285870 KB285870 October 28, 2003
- 280747 FIX: UPDATE Statement on a Clustered Index Key Fails with Error 547 Q280747 KB280747 October 28, 2003
- 279015 FIX: SQL Server Does Not Run RESTOREVERIFYONLY When Scheduling a Back Up in SQL Enterprise Manager Q279015 KB279015 October 28, 2003
- 242522 FIX: CCommand::Open() Fails with SQL Server 7.0 and LARGE_INTEGER Q242522 KB242522 October 17, 2003
- 316976 FIX: Tuning Wizard May Fail When You Specify a Workload File for Non-dbo Owned Objects Q316976 KB316976 October 9, 2003
- 269412 FIX: Access Violation Occurs When You Call SQL Server Stored Procedure That Contains PRINT Statement Q269412 KB269412 October 3, 2003
- 218967 FIX: "CREATE INDEX" in Form Causes ASC or DESC to be Removed in an ORDER BY Clause Q218967 KB218967 September 18, 2003
- 276419 FIX: Cannot Run Unattended Install of SQL Server 7.0 on Windows 2000 with Strong Password Policy Q276419 KB276419 October 16, 2002
- 291561 FIX: Invalid Float Data May Lead to Floating Point Exception and Incorrect Stored Values Q291561 KB291561 October 15, 2002