SQL Server 7.0 articles, fixes and updates - November 2013

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 November 2013. The list is daily updated.

• 318268 INF: SQL Server 7.0 Security Update for Service Pack 3 Q318268 KB318268 November 3, 2013
• 246326 BUG: Bulk Insert Task in a DTS Package Fails on an SQL Active/Passive Cluster Setup Q246326 KB246326 November 3, 2013
• 232574 INF: Readme.txt for SQL Server 7.0 Service Pack 1 Q232574 KB232574 November 3, 2013
• 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
• 830233 New Connection Events Are Not Recorded in SQL Server Traces Q830233 KB830233 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
• 821534 Some Complex Queries Run Slower After You Apply SQL Server 7.0 SP4 Q821534 KB821534 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
• 324191 BUG: Xp_sendmail Fails If @recipients Parameter Is More Than 256 Characters Q324191 KB324191 November 2, 2013
• 323139 INF: Installing Microsoft SQL Server 7.0 (White Paper) Q323139 KB323139 November 2, 2013
• 323138 Converting SQL Server 6x databases to Microsoft SQL Server 7.0 (White Paper) Q323138 KB323138 November 2, 2013
• 323136 INF: Microsoft SQL Server 7.0 Preparedness Review (White Paper) Q323136 KB323136 November 2, 2013
• 323118 FIX: Unexpected Close of a SQL Server Connection May Lead to an Access Violation Q323118 KB323118 November 2, 2013
• 323047 INF: Using COM Interfaces to Expand DTS Functionality (White Paper) Q323047 KB323047 November 2, 2013
• 323043 INF: Storage Engine Capacity Planning Tips (White Paper) Q323043 KB323043 November 2, 2013
• 323022 PRB: The Transaction Log File Shrinks Unexpectedly After Each Transaction Log Backup Q323022 KB323022 November 2, 2013
• 322903 INF: SQL Server 7.0 Storage Engine (White Paper) Q322903 KB322903 November 2, 2013
• 322899 INF: SQL Server 7.0 Security (White Paper) Q322899 KB322899 November 2, 2013
• 322883 SQL Server 7.0 Performance Tuning Guide (white paper) Q322883 KB322883 November 2, 2013
• 322881 INF: SQL Server 7.0 Features Guide (White Paper) Q322881 KB322881 November 2, 2013
• 322873 INF: SAP R/3 Performance Tuning Guide for Microsoft SQL Server 7.0 (White Paper) Q322873 KB322873 November 2, 2013
• 322870 INF: Replication for SQL Server 7.0 (White Paper) Q322870 KB322870 November 2, 2013
• 322818 BUG: Incorrect Identity Value with Self-Referencing FOREIGN KEY Constraint Q322818 KB322818 November 2, 2013
• 322714 INF: Migrating Your Microsoft Access Database to SQL Server 7.0 (White Paper) Q322714 KB322714 November 2, 2013
• 322702 INF: Leveraging the Power of DTS (White Paper) Q322702 KB322702 November 2, 2013
• 322698 INF: Index Tuning Wizard for SQL Server 7.0 (White Paper) Q322698 KB322698 November 2, 2013
• 322697 INF: Implementing Large Decision Support Databases on SQL Server 7.0 (White Paper) Q322697 KB322697 November 2, 2013
• 322619 INF: How to Install SQL Server 7.0 Enterprise Edition on Microsoft Cluster Server: Step-by-Step Instructions (White Paper) Q322619 KB322619 November 2, 2013
• 322602 INF: Developing with Microsoft English Query in SQL Server 7.0 (White Paper) Q322602 KB322602 November 2, 2013
• 322109 INF: How to Turn On Tracking of CPU Data for the Sysprocesses CPU Column Q322109 KB322109 November 2, 2013
• 320656 PRB: A Distributed Query May Fail If You Use the Xp_sendmail Stored Procedure with the @query Parameter on a Linked Server Q320656 KB320656 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
• 319126 BUG: Running a Stored Procedure by Using a Remote Procedure Call May Cause an Exception in the int_sendreturnparam Function Q319126 KB319126 November 2, 2013
• 317350 BUG: Conflict Tables Not Created When Publisher Is In a Workgroup Q317350 KB317350 November 2, 2013
• 315875 BUG: SQL Server Enterprise Manager Creates a Nonclustered Index for a PRIMARY KEY Constraint Q315875 KB315875 November 2, 2013
• 315007 PRB: Error Message: "The snap in that has been selected has failed to initialize" Occurs When You Open SQL Enterprise Manager Q315007 KB315007 November 2, 2013
• 311186 BUG: SQL Server Books Online Incorrectly Lists Updsts Switch for Sqlmaint Utility Q311186 KB311186 November 2, 2013
• 309255 BUG: AutoClose Database Option May Cause a Stack Dump and Cause SQL Server to Shut Down Q309255 KB309255 November 2, 2013
• 308355 BUG: Previously Replicated Stored Procedure Causes Access Violation Q308355 KB308355 November 2, 2013
• 308270 PRB: Server Level Post Handlers Cannot Remove Themselves with srv_post_handle Q308270 KB308270 November 2, 2013
• 306529 PRB: Migrating a Stand-alone SQL Server to a Clustered SQL Server in an Active Directory Environment Q306529 KB306529 November 2, 2013
• 306223 PRB: DBCC DBREINDEX May Set the STATBLOB Column that Corresponds to All Column Statistics of the Sysindexes Table to NULL Q306223 KB306223 November 2, 2013
• 302423 BUG: Execution of RAISERROR(@@ERROR) Causes Access Violation Q302423 KB302423 November 2, 2013
• 300964 BUG: Memory Tab in SEM Displays Memory Settings Incorrectly on a Server that has More than 4 GB of RAM Q300964 KB300964 November 2, 2013
• 300164 INF: How to Set Up an Identity Column on both the Publisher and the Subscriber with Transactional Replication Q300164 KB300164 November 2, 2013
• 298967 PRB: Unable to Load Transaction Log Backup on Secondary Server While Using Log Shipping Tool Q298967 KB298967 November 2, 2013
• 298801 PRB: Transaction Log Restores Stop Responding with "Minimum Query Memory Is Not Available" Message in Error Log Q298801 KB298801 November 2, 2013
• 297469 BUG: TOP 100 PERCENT in View Runs Slower On Service Pack 3 Q297469 KB297469 November 2, 2013
• 297468 BUG: Invalid Value Specified for STOPAT Parameter During Restore Q297468 KB297468 November 2, 2013
• 296637 BUG: Raiserror with %i Type Displays Incorrect Integer Value Q296637 KB296637 November 2, 2013
• 295724 PRB: Nonlogged BCP Operation Can Be Logged on Tables with Indexes and Existing Data Q295724 KB295724 November 2, 2013
• 295670 PRB: SQL Server Agent Reports Event ID:106 If You Install SQL Server on a Windows 2000 Domain Controller Q295670 KB295670 November 2, 2013
• 295121 BUG: DOC Error: Documentation Incorrectly States that DB_Owner role has Restore Database Permissions Q295121 KB295121 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
• 290992 BUG: ALTER COLUMN on Column With Auto-Stats Returns Error Message 1903 Q290992 KB290992 November 2, 2013
• 290536 BUG: View Designer Fails to Display Data if Statement is Long Q290536 KB290536 November 2, 2013
• 290054 BUG: Replication Distribution Agent Job Fails on Case-Sensitive Servers with Error 21056 Q290054 KB290054 November 2, 2013
• 289742 INF: How to Create a SQL Server 7.0 Trace Q289742 KB289742 November 2, 2013
• 289497 PRB: DBCS data problems occur after an upgrade to SQL Server 7.0 Q289497 KB289497 November 2, 2013
• 289290 BUG: DBCC SHRINKDATABASE Causes Memory Leak and Error 17803 When AUTO_SHRINK Is Set Q289290 KB289290 November 2, 2013
• 289279 INF: How to Monitor SQL Server 7.0 Traces Q289279 KB289279 November 2, 2013
• 289277 INF: How to View SQL Server 7.0 Performance Data Q289277 KB289277 November 2, 2013
• 289276 INF: How to View SQL Server 7.0 Blocking Data Q289276 KB289276 November 2, 2013
• 289274 INF: How to View SQL Server 7.0 Activity Data Q289274 KB289274 November 2, 2013
• 288319 PRB: Suboptimal Query Plan Executed When Same Join Predicate Appears on Both Sides of an OR Clause Q288319 KB288319 November 2, 2013
• 288232 BUG: Assignment to @variable Through SET Statement May Fail with Error Message 107 When You Use SELECT with Correlated Subquery Q288232 KB288232 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
• 286191 INF: Job to Monitor SQL Server 7.0 Performance and Activity Q286191 KB286191 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
• 284141 BUG: Insert From Subquery Returns Error Message 213 "Insert Error.." Q284141 KB284141 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
• 282976 PRB: SQL Server 7.0 Service Pack 2 Installation Fails with -115 Error Q282976 KB282976 November 2, 2013
• 282831 BUG: Access Violation Occurs on DECLARE CURSOR with Correlated Subquery and KEYSET or DYNAMIC Cursor Type Q282831 KB282831 November 2, 2013
• 282412 BUG: Generate SQL Scripts Operation in Enterprise Manager Doesn't Show Correct Owner Q282412 KB282412 November 2, 2013
• 281912 PRB: sp_detach_db Message Incorrectly Implies That it Drops Database Q281912 KB281912 November 2, 2013
• 281665 PRB: Scheduled Tape Backup Waits Indefinitely if No Tape is in Drive Q281665 KB281665 November 2, 2013
• 281590 BUG: Profiler Truncates RPC Procedure Name At 30 Characters Q281590 KB281590 November 2, 2013
• 281342 PRB: Inefficient Plan for BIT in Join Condition in WHERE Clause Q281342 KB281342 November 2, 2013
• 281339 PRB: Xp_sendmail Truncates Column Output to 256 Characters Q281339 KB281339 November 2, 2013
• 281203 BUG: Unable to Change Password in SEM when Server is Registered with Non-SA SQL Server Login Q281203 KB281203 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
• 281093 BUG: Noncontiguous Colids in Syscolumns Causes Sp_addarticle to Fail with Error 50007 Q281093 KB281093 November 2, 2013
• 280808 FIX: SQL Server 7.0 pull subscriber applies obsolete SQL Server 2000 Merge Agent snapshot Q280808 KB280808 November 2, 2013
• 280458 BUG: SQL Server May Not Find Existing Appropriate Query Plan Causing Recompilation Q280458 KB280458 November 2, 2013
• 280361 FIX: "Generate SQL Script" in Enterprise Manager May Not Script Out the Correct Permissions Q280361 KB280361 November 2, 2013
• 280074 BUG: Messages Logged in the Application Log of Windows 2000 Capture SQL Server 7.0 Performance Counters Q280074 KB280074 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
• 279407 BUG: Selecting All Columns from a View Containing an ORDER BY Statement May Result in an Access Violation Q279407 KB279407 November 2, 2013
• 278894 BUG: Merge Replication Snapshot Agent Fails with Error Message 1913 Q278894 KB278894 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
• 278656 PRB: Like Predicate Optimization is Limited to 7 Character Positions Q278656 KB278656 November 2, 2013
• 278536 FIX: SQL 7.0 Setup Does Not Install Licensing on Terminal Server Q278536 KB278536 November 2, 2013
• 278324 BUG: Distribution Agent Fails During Initial Synchronization When You Use Stored Procedure Replication Q278324 KB278324 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
• 277842 BUG: SQL Server 7.0 Uninstall Does Not Remove Licensing Information Q277842 KB277842 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
• 276447 BUG: Access Violation Occurs When a Variable is Used in FREETEXTTABLE Function as Search String Inside a Cursor Definition Q276447 KB276447 November 2, 2013
• 276374 BUG: Query Analyzer May Allow an Invalid Seed Number During Table Creation Q276374 KB276374 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
• 275436 BUG: Distribution Agent Fails When Validating Publication with Stored Procedure Articles Q275436 KB275436 November 2, 2013
• 274995 FIX: Plan Reuse Gives Incorrect Query Results Q274995 KB274995 November 2, 2013
• 274589 BUG: SELECT with GROUP BY and WITH CUBE Returns Incorrect Results When You Use a Derived Table Q274589 KB274589 November 2, 2013
• 274588 BUG: SELECT with GROUP BY and WITH ROLLUP Results in Access Violation Q274588 KB274588 November 2, 2013
• 273933 INF: How to Use the SQL Server 7.0 TraceReader Objects Q273933 KB273933 November 2, 2013
• 273880 BUG: Processor Tab in SQL Server Enterprise Manager Displays Wrong Number of Processors Configured for Parallel Execution of Queries Q273880 KB273880 November 2, 2013
• 273878 BUG: xa.h Include File is not Found When You Compile Code with the SQL Server 7.0 Development Tools Q273878 KB273878 November 2, 2013
• 273557 BUG: Floating point underflow exceptions may occur with data below the minimum float exponent Q273557 KB273557 November 2, 2013
• 272453 Cannot use SQL Server 7.0 tools after you remove SQL Server 2000 Q272453 KB272453 November 2, 2013
• 272319 BUG: ALTER TABLE NOCHECK CONSTRAINT Excluded When Scripting Database Q272319 KB272319 November 2, 2013
• 272292 BUG: Error 7399 When You Bulk Insert into Table with Column Default on a NUMERIC or DECIMAL Column Q272292 KB272292 November 2, 2013
• 272115 PRB: Stored Procedure Still Marked for Replication May Cause Stack Dumps Q272115 KB272115 November 2, 2013
• 271525 PRB: Misleading Error Message with an IN Clause On Text Data Type Q271525 KB271525 November 2, 2013
• 271258 BUG: Original db_datareader Role is Lost if dbuser is Assigned a New db_datawriter Role Q271258 KB271258 November 2, 2013
• 271171 PRB: Backup Wizard May Not Display the "Verify Backup" Option Correctly Q271171 KB271171 November 2, 2013
• 270839 PRB: SQL Server 7.0 Setup Fails on MSCS with Cannot Grant Logon as a Service Right Q270839 KB270839 November 2, 2013
• 270664 PRB: Database Marked Read Only Does Not Allow You to Change User Permissions Simultaneously Q270664 KB270664 November 2, 2013
• 269884 BUG: Invalid Style Parameter in CONVERT Function May Cause Access Violation Q269884 KB269884 November 2, 2013
• 269694 PRB: Keyset Cursor to Access a Remoted Table Through a Linked Server May Cause Error 16953 Q269694 KB269694 November 2, 2013
• 269603 INF: SQL Server 7.0 Setup Fails With Exception Error Q269603 KB269603 November 2, 2013
• 269486 BUG: Changing Max Worker Threads Requires You to Restart SQL Server Q269486 KB269486 November 2, 2013
• 269418 PRB: SQL Server 7.0 MSDTC Administrative Console Unavailable on Windows 2000 from Program Menu Q269418 KB269418 November 2, 2013
• 268868 FIX: Query Analyzer Uses the Wrong Color Coding for Commands Q268868 KB268868 November 2, 2013
• 268858 PRB: SQL Server 7.0 Enterprise Manager Does not Provide Object and User Permissions Dialog Boxes Like SQL Server 6.5 Q268858 KB268858 November 2, 2013
• 268846 BUG: A SELECT Statement With a Number of SUM(CASE()) Expressions and UNIONs May Cause Stack Overflow Q268846 KB268846 November 2, 2013
• 268594 PRB: Inconsistency in Behavior Between CREATE STATISTICS and UPDATE STATISTICS Q268594 KB268594 November 2, 2013
• 268243 PRB: Column SS_DATA_TYPE From sp_columns is The Same As syscolumns.type And Not syscolumns.xtype Q268243 KB268243 November 2, 2013
• 268232 INF: How to Add or Modify SQL Server Licenses Q268232 KB268232 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
• 266617 BUG: Combination of Top, an Inequality, and a Join Result in Incorrect Choice of a Table Spool Plan Q266617 KB266617 November 2, 2013
• 266332 BUG: SQL Server Books Online Incorrectly States That SET ROWCOUNT is Applied Before ORDER BY Q266332 KB266332 November 2, 2013
• 265741 BUG: SQL Server Query Analyzer Displays Incorrect Error Number When Connected to a Paused SQL Server Q265741 KB265741 November 2, 2013
• 265544 BUG: sp_OAmethod is Unable to Retrieve Output Passed Through OLE Object Functions with 18 or More Parameters Q265544 KB265544 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
• 264689 BUG: Parallel Process May Not Appear Blocked in the sp_who System Stored Procedure Q264689 KB264689 November 2, 2013
• 264682 BUG: INSERT .. EXEC sp_OAMethod Fails if 255 or More Characters are Returned Q264682 KB264682 November 2, 2013
• 264229 FIX: SELECT Statement Assigns Incorrect Values to NUMERIC or DECIMAL Variables When Used Multiple Times Q264229 KB264229 November 2, 2013
• 264160 PRB: Column Level CHECK Constraint Required Before Implementing a Partitioned View Q264160 KB264160 November 2, 2013
• 264058 BUG: Access Violation with xp_cmdshell Returning Data into a Table with More Columns Than Returned Q264058 KB264058 November 2, 2013
• 264041 FIX: DBCC CHECKALLOC May Inaccurately Report Errors 8968 and 8998 Q264041 KB264041 November 2, 2013
• 263886 BUG: xp_trace_addnewqueue Timeout is in Seconds Q263886 KB263886 November 2, 2013
• 263864 PRB: SQL Server 7.0 Failover Cluster Wizard Fails to Remove Resources After Removing the Virtual Server Q263864 KB263864 November 2, 2013
• 263574 BUG: Design View Displays Views with More Than 4002 Characters Incorrectly Q263574 KB263574 November 2, 2013
• 262607 BUG: SQL Server Enterprise Manager Does Not Create New Table in Default Filegroup Q262607 KB262607 November 2, 2013
• 262541 BUG: Query Against Linked Server Might Cause Access Violation When the Name of One Unique Index is a Part of Another Unique Clustered Index Q262541 KB262541 November 2, 2013
• 262033 BUG: Documentation Error in SQL Server 7.0 Books Online for OPEN OBJECTS Default Value Q262033 KB262033 November 2, 2013
• 261846 BUG: Filter Plan Chosen Instead of Selective Clustered Index Seek for LIKE or IN That Contains Predicates Q261846 KB261846 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
• 260388 PRB: SQL Server 7.0 Setup Fails at Configuration Phase Because of Insufficient Permissions Q260388 KB260388 November 2, 2013
• 260355 BUG: Snapshot Job Adds Create Index Command for Transactional Publications Even if not Requested Q260355 KB260355 November 2, 2013
• 260344 SQL Server 7.0 upgrade might fail if SQL Server 6.5 databases have more than 32,000 tables Q260344 KB260344 November 2, 2013
• 260276 BUG: Agent Profile Check Box "Change all existing Agents.." Does Not Change Existing Agents Q260276 KB260276 November 2, 2013
• 260254 FIX: Rollback of Transactions Named as Empty String Cause Access Violations Q260254 KB260254 November 2, 2013
• 260235 BUG: Point-in-Time Recovery Adds Incorrect Seconds Value to Recovery Time Selected in SEM Q260235 KB260235 November 2, 2013
• 259956 FIX: Text Field Data Truncated When Double Byte Character Spans Page Break Q259956 KB259956 November 2, 2013
• 258442 BUG: Sp_refreshview Does Not Pick Up Changes When a Column is Dropped in the Base Table Q258442 KB258442 November 2, 2013
• 258298 BUG: WRITETEXT & UPDATETEXT Statements Fail When Run Against Snapshot Replication Tables Q258298 KB258298 November 2, 2013
• 258238 BUG: Simultaneous DTC Operations May Cause SPID to Stop Responding Q258238 KB258238 November 2, 2013
• 258226 FIX: DBCS Space Is Not Treated Correctly Q258226 KB258226 November 2, 2013
• 257857 BUG: Transaction Log Backup Possible After the Addition or Removal of Database Files Q257857 KB257857 November 2, 2013
• 257855 BUG: Transaction Log Backup Possible After Automatic Rebuild of LDF Q257855 KB257855 November 2, 2013
• 257609 BUG: Incorrect Example D for sp_addlogin in SQL Server Books Online Q257609 KB257609 November 2, 2013
• 257564 BUG: Parallel Query Generates Access Violation from Derived Table Populated from NULL Parameters Q257564 KB257564 November 2, 2013
• 257515 FIX: DMO ExecuteWithResults Fails with Decimal Data Q257515 KB257515 November 2, 2013
• 256973 INF: Error Message: 3132 "The RAID set for database ... missing member number" Q256973 KB256973 November 2, 2013
• 255786 BUG: Performance Monitor May not Show Correct Number of User Connections Q255786 KB255786 November 2, 2013
• 255749 BUG: xp_cmdshell Does Not Display Last Line of Command Output Q255749 KB255749 November 2, 2013
• 255712 FIX: UPDATE May Fail to Update All the Qualifying Rows on Multi-Proc Computers Q255712 KB255712 November 2, 2013
• 255254 INF: How to Use Check65.exe to Check for Problems Before You Upgrade to SQL Server 7.0 Q255254 KB255254 November 2, 2013
• 254806 FIX: QUERY Statement Causes 512 Error When You Access a View Q254806 KB254806 November 2, 2013
• 254341 PRB: Legacy DB-Library Application May Fail to Connect After You Install SQL Server Client Tools Q254341 KB254341 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
• 253107 BUG: SQL Server Properties, Security Tab Missing the "Nonadministrators use SQLAgentCmdExec account when executing commands via xp_cmdshell" Option Q253107 KB253107 November 2, 2013
• 252905 FIX: Slow Compile Time on Complex Joins with Unfiltered Table Q252905 KB252905 November 2, 2013
• 252660 INF: SQL Server 7.0 Clients Can Send Encrypted Password Strings Q252660 KB252660 November 2, 2013
• 251277 PRB: Poor Cardinality Estimation for Inequality Expressions in Joins Q251277 KB251277 November 2, 2013
• 251187 FIX: Logreader Fails When It Processes an Update with the Trace Flag 8202 Set ON Q251187 KB251187 November 2, 2013
• 250910 PRB: Error Does Not Occur When Setting IDENTITY_INSERT ON For More Than One Table Q250910 KB250910 November 2, 2013
• 250604 BUG: FILLFACTOR on Published Table Makes Merge Replication to JET 4.0 Subscribers Fail with "Syntax error" Message Q250604 KB250604 November 2, 2013
• 250506 FIX: Concurrent Execution of Stored Procedure That Recompiles May Fail To Execute All Statements Q250506 KB250506 November 2, 2013
• 249802 PRB: Error Message Occurs When You Install SQL Server 7.0 Service Packs in a Cluster Environment Q249802 KB249802 November 2, 2013
• 249671 Passwords unusable after SQL Server 6.5 to 7.0 upgrade with different sort order Q249671 KB249671 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
• 248407 PRB: Utilizing xp_cmdshell with Non-Sysadmin Accounts in a Clustered Environment Q248407 KB248407 November 2, 2013
• 248265 BUG: BCP Will Not Load Native File if First Two Bytes Are 0xFEFF Q248265 KB248265 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
• 247692 BUG: Backups Over Network Using INIT Take Longer to Complete When Dumping to Devices Already Containing Backups Q247692 KB247692 November 2, 2013
• 247490 BUG: Enterprise Manager May Incorrectly Calculate Index Size Q247490 KB247490 November 2, 2013
• 247365 BUG: Dynamic Cursor With NOLOCK Hint, DELETE Activity, Causes Assertions in Error Log Q247365 KB247365 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
• 247110 PRB: Replication Must be Removed Before Applying Service Pack Q247110 KB247110 November 2, 2013
• 246332 BUG: Slow Synchronization on Newly Added Subscriptions to Statically Filtered Publications Q246332 KB246332 November 2, 2013
• 246321 BUG: Merge Subscriptions with NOSYNC Option May Experience Inconsistent Data on Publisher and Subscriber Q246321 KB246321 November 2, 2013
• 245803 BUG: Memory Leak with Xp_sendmail Using Attachments Q245803 KB245803 November 2, 2013
• 244391 BUG: SQL 7.0 Create Statistics or WHERE Clause on Float Returns EXCEPTION_FLT_INVALID_OPERATION Q244391 KB244391 November 2, 2013
• 244340 BUG: No Output from BCP when Using Format File to Reorder Columns Q244340 KB244340 November 2, 2013
• 243741 FIX: Replication Initialize Method Causes Handle Leak on Failure Q243741 KB243741 November 2, 2013
• 243665 BUG: Using Multi Protocol Connections Elevate SQL Server Thread Counts Q243665 KB243665 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
• 241935 BUG: REPL: Reference Constraints Are Not Getting Applied to Filtered Subscriptions Q241935 KB241935 November 2, 2013
• 241636 BUG: BOL Incorrectly Documents Permissions to System Stored Procedures Q241636 KB241636 November 2, 2013
• 241363 BUG: Error 924 When Cursor is Executed in DB in Single-User Mode Q241363 KB241363 November 2, 2013
• 241113 PRB: A Full-Text Search Query on TEXT or NTEXT Column Does Not Return Valid Results Q241113 KB241113 November 2, 2013
• 240235 BUG: "Implementing Nonpartitioned, Bi-directional, Transactional Replication" Sample in Books Online Contains Errors Q240235 KB240235 November 2, 2013
• 240213 BUG: SBS 4.5 Installations of SQL Server 7.0 do not Install All Replication DLLs Q240213 KB240213 November 2, 2013
• 240193 PRB: Upgrading Replication Settings May Fail When Inserting Rows into Msdistribution_agents Q240193 KB240193 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
• 239667 BUG: Design Table in SEM Does Not Preserve NFR Property for IDENTITY Q239667 KB239667 November 2, 2013
• 239115 BUG: DOC: SQL Books Online Documentation Error for CHECKCATALOG Q239115 KB239115 November 2, 2013
• 239074 BUG: Sp_processmail Returns Datatype Error Message Q239074 KB239074 November 2, 2013
• 238745 BUG: SQL BOL Incorrectly States That CHECKCATALOG Deletes Object Q238745 KB238745 November 2, 2013
• 238481 BUG: Enterprise Manager: Error Message "Too many columns defined in the rowset" Q238481 KB238481 November 2, 2013
• 237674 INF: bcp_exec API Requires User Error Handler When Processing 1000 or More Records Q237674 KB237674 November 2, 2013
• 237487 PRB: Service Pack Setup Requires Default Named-Pipe Name Q237487 KB237487 November 2, 2013
• 236885 PRB: Using SQL 6.5 and 7.0 Enterprise Manager to Read from a Remote Server Q236885 KB236885 November 2, 2013
• 236825 PRB: #deleted seen when SQL Server 7.0 tables or SQL Server 6.5 tables that are linked to Access 97 or Access 2000 are opened Q236825 KB236825 November 2, 2013
• 236563 INF: INSCAT.sql Comment About Updating spt_server_info Can be Ignored Q236563 KB236563 November 2, 2013
• 236407 BUG: Active/Passive Cluster Setup Breaks Replication and DTS Q236407 KB236407 November 2, 2013
• 236045 FIX: Upgrade Wizard GUI Allows Adding of New File Groups to Model and TempDB Databases Q236045 KB236045 November 2, 2013
• 236003 BUG: DB-Library bcp_sendrow() Fails on SQL 7.0 Q236003 KB236003 November 2, 2013
• 235893 INF: How To Find a Specific Task/Step Inside a DTS Package Q235893 KB235893 November 2, 2013
• 234060 PRB: Cannot Install SQL Server 7.0 Enterprise Edition After Upgrade to Windows NT 4.0 Enterprise Edition Q234060 KB234060 November 2, 2013
• 233522 FIX: DBCC DBREINDEX on a Table Without any Indexes Creates Error Q233522 KB233522 November 2, 2013
• 233232 BUG: (DOC) Description of Sysaltfiles Table Incorrect Q233232 KB233232 November 2, 2013
• 233027 FIX: Cannot Properly Add IPX/SPX Address to Server Network Utility Q233027 KB233027 November 2, 2013
• 231735 INF: SQL 7.0 Remote Unattended Install Q231735 KB231735 November 2, 2013
• 230700 BUG: Access Violation Backing Up Tran Log After Error 5042 Q230700 KB230700 November 2, 2013
• 230555 BUG: Query with CUBE and Duplicate Column in GROUP BY Clause Generates AV Q230555 KB230555 November 2, 2013
• 230375 BUG: Sort Objects by Create Date Shows Incorrect Order Q230375 KB230375 November 2, 2013
• 230103 BUG: Cannot Have More than Eight Full Text Joins and Operations Q230103 KB230103 November 2, 2013
• 230036 BUG: Heavy Full Text Query Activity Results in Unexpected Timeout Errors Q230036 KB230036 November 2, 2013
• 229726 BUG: A Foreign Key Table with Data in Tempdb Creates Error 1105 Q229726 KB229726 November 2, 2013
• 229695 BUG: SQL 7.0 Desktop Edition Install on a Windows 95 or Windows 98 Fails w/ "SNAPSHOT illegal operation" Q229695 KB229695 November 2, 2013
• 229562 BUG: Cannot Modify Grouped Stored Procedures in Enterprise Manager Q229562 KB229562 November 2, 2013
• 229385 BUG: DOC: Primary Filegroup Cannot be Read-Only Q229385 KB229385 November 2, 2013
• 229003 FIX: Error 21770 When Trying to Manage Permissions For User-Owned Stored Procedures in SEM Q229003 KB229003 November 2, 2013
• 226191 BUG: Concurrent Async Keyset Cursors May Cause Server to Stop Responding Q226191 KB226191 November 2, 2013
• 226121 BUG: SQLServerAgent May Not Respond to CTRL+C Correctly in Console Mode Q226121 KB226121 November 2, 2013
• 225492 BUG: ERR 107 Occurs when Alias Name of Derived Table not Found in UPDATE/DELETE Statement Q225492 KB225492 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
• 224445 BUG: SQL Cluster Setup Wizard Fails When Path Contains Spaces Q224445 KB224445 November 2, 2013
• 224329 FIX: Merge Initial Sync With Dynamic Filters Takes Long Time to Synchronize Q224329 KB224329 November 2, 2013
• 222127 BUG DOC: Log Backup Mode Incorrectly Documented for Maintaining Log Backup Sequence Q222127 KB222127 November 2, 2013
• 222106 PRB: Cannot install Enterprise Edition on Windows NT Server Q222106 KB222106 November 2, 2013
• 218029 SQL Server 7.0 Setup Stops if Directory Name Contains Cyrillic Character Q218029 KB218029 November 2, 2013
• 200921 PRB: OpenQuery with ATL Provider Fails When Set Up with SQL Enterprise Manager Q200921 KB200921 November 2, 2013
• 199763 FIX: Client Apps Stop Responding When Running Server-Side Cursors Against Stored Procedures Q199763 KB199763 November 2, 2013
• 199279 BUG: SEM: Saving Scripting File Behaves Differently on Alpha Q199279 KB199279 November 2, 2013
• 199000 BUG: Client Network Utility Allows Invalid IPX Port Address Format Q199000 KB199000 November 2, 2013
• 196771 FIX: @@language Value Can Be Truncated After Changing Value Q196771 KB196771 November 2, 2013
• 46168 INF: Effect of SET ROWCOUNT on SELECT with ORDER BY Q46168 KB46168 November 2, 2013
• 311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128 Q311000 KB311000 November 1, 2013
• 220922 INF: Server Configurations Transferred During 7.0 Upgrade Q220922 KB220922 November 1, 2013
• 220156 FIX: SQL Cluster Install Fails When SVS Name Contains Special Characters Q220156 KB220156 November 1, 2013
• 218603 BUG: Transient 605 Error When Doing a BCP Operation on Heap Q218603 KB218603 November 1, 2013
• 217032 BUG: DOC: Variable Arguments not Refreshed After Cursor is Declared Q217032 KB217032 November 1, 2013
• 214799 INF: SQLProfiler From Command Line Parameters to Temp File Usage Q214799 KB214799 November 1, 2013
• 203824 BUG: Incomplete Display of Some System Roles Q203824 KB203824 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
• 201831 BUG: Misleading Message 4613 When Trying to REVOKE Permission Q201831 KB201831 November 1, 2013
• 201545 BUG: Stored Procedure Names Starting with 'go' Cause Syntax Errors Q201545 KB201545 November 1, 2013
• 199230 PRB: SQLServerAgent Service Does Not Start After Unclustering Q199230 KB199230 November 1, 2013
• 199214 BUG: Bcp_exec Causes AV If Bcp_columns Is Less Than Table Columns Q199214 KB199214 November 1, 2013
• 199104 BUG: Exiting the Upgrade Wizard During Validation Causes Errors Q199104 KB199104 November 1, 2013
• 174688 BUG: Update to a View with a Column Name Alias Fails Using a Server Side Cursor Q174688 KB174688 November 1, 2013
• 166270 INF: How to Increase SQL Server Multi-Protocol Connections Q166270 KB166270 November 1, 2013
• 166200 BUG: Errors 2714 and 267 on INSERT INTO Global Temp Table Q166200 KB166200 November 1, 2013
• 163036 INF: How to Monitor Free Space in a User Database with PerfMon Q163036 KB163036 November 1, 2013
• 158684 BUG: Unable to Reload Master DB After Upgrading SQL Server Q158684 KB158684 November 1, 2013
• 156096 INF: Tips for Debugging Stored Procedures from VC++ Q156096 KB156096 November 1, 2013
• 153676 PRB: SQLMail Always Saves Sent Mail with Exchange Client Q153676 KB153676 November 1, 2013
• 141666 PRB: GO as 1st Word on Line Treated as Batch Terminator Q141666 KB141666 November 1, 2013
• 134660 INFO: Retrieving IDENTITY Value for Referential Integrity Q134660 KB134660 November 1, 2013
• 42624 PRB: Error Creating Stored Procedure Q42624 KB42624 November 1, 2013