SQL Server 7.0 articles, fixes and updates - March 2006

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 March 2006. The list is daily updated.

• 233337 INF: How to Determine When an Unattended SQL Server 7.0/MSDE 1.0 Setup is Complete Q233337 KB233337 March 31, 2006
• 233312 Customizing SQL/MSDE unattended installation files Q233312 KB233312 March 30, 2006
• 270126 How to manage client connectivity to both SQL Server 2000 virtual servers after an Active/Active cluster 7.0 upgrade Q270126 KB270126 March 15, 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
• 234224 Error Clicking Back Button After Testing New DSN in ODBC Control Panel Q234224 KB234224 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