SQL Server 2000 articles, fixes and updates

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

825728 BUG: SQL Server Books Online Incorrectly States That the Age Field of a Query Plan Is Incremented by Compilation Cost Factor Q825728 KB825728 November 26, 2003
240025 INF: Rollback Transaction in Triggers at Subscriber Can Break Transactional Integrity Q240025 KB240025 November 26, 2003
298758 BUG: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities Q298758 KB298758 November 21, 2003
220960 How to Include Other MMCs in SQL Enterprise Manager MMC Q220960 KB220960 November 21, 2003
203312 PRB: Cannot Register Server if Password Exceeds 60 Characters Q203312 KB203312 November 21, 2003
201041 BUG: Stored Procedure Remains After Deleting Web Wizard File Q201041 KB201041 November 21, 2003
200796 PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name Q200796 KB200796 November 21, 2003
296437 BUG: Database Restore May Result in DBO Mismatch if DBO Has Been Changed More Than Once Q296437 KB296437 November 19, 2003
315505 HOW TO: Use the SQL Distributed Management Objects Model to Programmatically Transfer SQL Server Stored Procedures Q315505 KB315505 November 17, 2003
308932 FIX: Enterprise Manager May Show Incorrect Number of Configured CPUs Q308932 KB308932 November 17, 2003
289278 PRB: Setting DBPROP_REMOVEDELETED Property to VARIANT_FALSE Fails to Open Fast-Forward Cursor Q289278 KB289278 November 17, 2003
279514 BUG: ExecuteWithResultsAndMessages2 Does Not Return Results Q279514 KB279514 November 17, 2003
244498 BUG: Dbcursoropen() Causes Access Violation When Selecting More than 254 Columns Q244498 KB244498 November 17, 2003
237973 BUG: Aggregate of an Expression May Return the Incorrect Scale Q237973 KB237973 November 17, 2003
327520 PRB: User Principal Names Are Not Supported by SQL Server 7.0 or SQL Server 2000 Q327520 KB327520 November 14, 2003
321456 PRB: SQL 6.5 Upgrade Results in Errors 4850 and 4851 Q321456 KB321456 November 14, 2003
319048 PRB: Cannot Use Data Transformation Services Event Handlers in Visual Basic with Execute Package Task Q319048 KB319048 November 14, 2003
303104 PRB: Unable to Save DTS Package to SQL Server When You Use Windows NT 4.0 French Localized Version Q303104 KB303104 November 14, 2003
295739 BUG: DTS Designer May Stop Responding When You Use Microsoft Jet 4.0 OLE DB Provider Q295739 KB295739 November 14, 2003
295002 FIX: SQL Server 2000 Setup Does Not Install Jet Drivers Help File Q295002 KB295002 November 14, 2003
281345 PRB: Dialog Box Opens During Backup Process Prompting You To Insert Disk in Drive A Q281345 KB281345 November 14, 2003
281126 PRB: System Tables Missing Primary Key Information After Upgrade from SQL Server 6.x to SQL Server 7.0 or SQL Server 2000 Q281126 KB281126 November 14, 2003
274472 PRB: BCP 'in' May Cause Exception When Input File Last Column Is Datatype DATETIME Q274472 KB274472 November 14, 2003
268877 INF: Registering SQL Server Wizard Gives a Misleading Error Message Q268877 KB268877 November 14, 2003
268784 INF: SQL Enterprise Manager Rounds Database Size Q268784 KB268784 November 14, 2003
264901 BUG: Error 16917 When CURSOR_CLOSE_ON_COMMIT Is Set ON Q264901 KB264901 November 14, 2003
259372 PRB: Some Arguments in sp_sproc_columns and sp_columns Support Wildcard Pattern Matching Q259372 KB259372 November 14, 2003
257434 INF: Network Library in Existing DSN Replaced by Network Library in New DSN to the Same SQL Server Name Q257434 KB257434 November 14, 2003
248158 PRB: Select From Database on CD-ROM May Return Error 601 Q248158 KB248158 November 14, 2003
243198 PRB: Renaming Stored Procedure, View or Trigger does not update SYSCOMMENTS table Q243198 KB243198 November 14, 2003
230393 BUG: SNMP Agent Message Causes Event ID 322 Q230393 KB230393 November 14, 2003
174817 INF: Microsoft SQL Server DB-Library Has Limited Extensibility Q174817 KB174817 November 14, 2003
290415 FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very Slow Q290415 KB290415 November 13, 2003
271624 INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage Q271624 KB271624 November 12, 2003
253673 PRB: Recordset Based on SQL Server View Updates Base Tables Q253673 KB253673 November 7, 2003
295373 FIX: Creating Indexes in Parallel May Fail with Deadlock on Sysindexes Q295373 KB295373 November 6, 2003
295113 FIX: Corrupted TDS Packets Cause Access Violation in SQL Server Q295113 KB295113 November 6, 2003
295055 FIX: sp_OAMethod Does Not Convert Numeric Datatype Correctly Q295055 KB295055 November 6, 2003
295051 FIX: Changing SQL Server Account to Non-Admin for Full-Text Search Makes Existing Catalogs Unusable Q295051 KB295051 November 6, 2003
295039 FIX: Assertion Raised When DELETE Is Performed on a Table Joined with a View Q295039 KB295039 November 6, 2003
295037 FIX: MERGE UNION Is Not Used with Large Number of UNION Clauses Q295037 KB295037 November 6, 2003
294944 FIX: DTSWIZ.exe Closes When Exporting to a Text File if the File Name Contains 255 Characters Q294944 KB294944 November 6, 2003
294902 FIX : Rollback to Savepoint Causes Assertion and Errors Q294902 KB294902 November 6, 2003
294874 FIX: Combination of Multiple EXIST, OR, and Subquery Clauses May Give a Sub-Optimal Plan Q294874 KB294874 November 6, 2003
294860 FIX: Modification Queries May Take Too Long to Compile if Halloween Protection is Required for Multiple Tables Q294860 KB294860 November 6, 2003
294839 FIX: No Error Message Generated by Query Analyzer When You Try to Open a Database with a Name Greater Than 128 Characters Q294839 KB294839 November 6, 2003
294787 FIX: Update Plan with User Defined Function May Fail to Find a Plan Q294787 KB294787 November 6, 2003
294459 FIX: Can't Use Four-Part Name to Query Oracle Table If Name Contains Lowercase Characters Q294459 KB294459 November 6, 2003
294415 FIX: Resource Does Not Failover Immediately if an Error is Encountered by the Resource DLL Q294415 KB294415 November 6, 2003
294412 BUG: SQLAgent T-SQL Job Does Not Respect SET NOCOUNT ON When Sending Output to File Q294412 KB294412 November 6, 2003
294338 FIX: xp_enumgroups Generates an Access Violation when Passed a Large Parameter Q294338 KB294338 November 6, 2003
294311 FIX: Trigger Does Not Return Expected Duplicate Key Insert Error to Client Q294311 KB294311 November 6, 2003
293849 FIX: Statistics Maintenance Creates Significant Bottleneck on SQL Servers that Use 16 or More CPUs Q293849 KB293849 November 6, 2003
293784 FIX: Unable to Drop a Catalog When Disk is Full Q293784 KB293784 November 6, 2003
293632 FIX: EventSubClass Column Incorrect for Deadlock Chain Events Q293632 KB293632 November 6, 2003
293489 FIX: Merge Replication with Dynamic Filters May Cause MMC to Fail Q293489 KB293489 November 6, 2003
293464 FIX: Merge Replication Does Not Log Conflicts after Successively Adding and Dropping Columns Q293464 KB293464 November 6, 2003
293345 FIX: ANSI Script from Profiler Cannot be Opened in Query Analyzer Q293345 KB293345 November 6, 2003
293329 FIX: Attaching Database Files Saved In Different Disk Folders Through SQL Enterprise Manager Q293329 KB293329 November 6, 2003
293292 FIX: DBCC CHECKDB May Produce an Access Violation When Database Is in Use Q293292 KB293292 November 6, 2003
293223 FIX: Problems Saving DTS Packages to Visual Basic Files Using the DTS User Interface Q293223 KB293223 November 6, 2003
293166 FIX: Parallel Modification Operation May Spin Trying to Release Locks Q293166 KB293166 November 6, 2003
292755 FIX: Full-Text Queries May Return "Unspecified Error" Error Message Q292755 KB292755 November 6, 2003
292753 FIX: Some Object Browser Folders Cannot Be Scripted Q292753 KB292753 November 6, 2003
292737 FIX: Drag and Drop Object Type Node to the Editor in Query Analyzer Returns Error Message Q292737 KB292737 November 6, 2003
292456 FIX: GetColumnInfo Returns Incorrect Column Information Q292456 KB292456 November 6, 2003
292455 FIX: OSQL Does Not Display Column Names for Query Q292455 KB292455 November 6, 2003
292454 FIX: Update Queries with OpenXML Table Aliases Cause Access Violation Q292454 KB292454 November 6, 2003
291851 FIX: Merge Replication Stored Procedures May Be Scripted Incorrectly When an Article is in Two Publications Q291851 KB291851 November 6, 2003
291780 FIX: DTS Transfer Objects May Fail if Dependent Objects Are Not in Alphabetical Order Q291780 KB291780 November 6, 2003
291277 FIX: ServerNet II Library Does Not Display if Giganet Driver is Not Available Q291277 KB291277 November 6, 2003
291275 FIX: sp_replsetoriginator May Generate Access Violation in Bidirectional Transactional Replication Q291275 KB291275 November 6, 2003
291273 FIX: SQLMail Incorrectly Uses Default Mail Profile Q291273 KB291273 November 6, 2003
291223 FIX: sql_variant Data Replicates Incorrectly After Conflict Is Resolved in a Queued Updating Subscriber Scenario Q291223 KB291223 November 6, 2003
291001 INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of Update Custom Procedures in SQL Server 2000 Transactional Replication Q291001 KB291001 November 6, 2003
290921 FIX: UPPER and LOWER Functions Return Metadata Length as if DBCS Were Used Q290921 KB290921 November 6, 2003
290918 FIX: Incorrect Behavior of LIKE [-] When Using an Index Q290918 KB290918 November 6, 2003
290917 FIX: Incorrect Identity Values After Failed Unique Index Creation Q290917 KB290917 November 6, 2003
290814 FIX: xp_readmail Leaks Memory if Message Contains Attachment Q290814 KB290814 November 6, 2003
290642 FIX: Exists with Full Outer Join May Generate Access Violation Q290642 KB290642 November 6, 2003
290592 FIX: Full-Text Rows Missing After Crawl Due to Full Disk Q290592 KB290592 November 6, 2003
290413 FIX: DB-Library sp_cursor Fails with Error Message 16933 if Bracketed Identifiers are Passed with the Tablename Parameter Q290413 KB290413 November 6, 2003
290353 FIX: Updating View Based on Partitioned View May Result in Assertion Q290353 KB290353 November 6, 2003
290085 FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation When Given Too Large a Parameter Q290085 KB290085 November 6, 2003
290083 FIX: FOR XML EXPLICIT: Conflict Attribute in xmltext Is Not Overwritten if xmltext Contains DBCS Q290083 KB290083 November 6, 2003
290082 FIX: Failed Server-Side Retail Assertion in Merge Replication with SQL Server CE Clients Q290082 KB290082 November 6, 2003
290080 FIX: Assert Occurs When You Try to Alter a Database and Trace Flag 902 is Enabled Q290080 KB290080 November 6, 2003
290058 FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010f Q290058 KB290058 November 6, 2003
289880 FIX: SQL Server Assertion Failure Occurs if Recovery Model of TempDB is not SIMPLE Q289880 KB289880 November 6, 2003
289878 FIX: Locking on File Header Pages Is Reported Incorrectly Q289878 KB289878 November 6, 2003
289851 FIX: Creating a New Unique Named Pipe Alias Displays the Default Pipe Value Instead of the Entered Value Q289851 KB289851 November 6, 2003
289691 FIX: Sysprocesses Is Incorrectly Showing Rollback Status Even Though the Transaction Is Not Rolling Back Q289691 KB289691 November 6, 2003
289667 FIX: Executing Isqlw.exe with -i -o Parameters May Insert Text Into the Input SQL Script Q289667 KB289667 November 6, 2003
289551 FIX: Generate SQL Script in Enterprise Manager Generates Scripts in Wrong Sequence if the Table has User-Defined Function as Computed Column Q289551 KB289551 November 6, 2003
289475 BUG: SQLAgent Incorrectly Uses TLSAlloc for Transact-SQL Jobs Causing all TLS Slots to be Exhausted Q289475 KB289475 November 6, 2003
289472 FIX: SQLAgent Exception Occurs when the System Maintains 613, 2661 or 4709 Jobs Q289472 KB289472 November 6, 2003
289149 FIX: A Query That Uses Hash Match Teams May Fail with 8630 Error Message Q289149 KB289149 November 6, 2003
288996 FIX: System View Sysopentapes Can Be Dropped Q288996 KB288996 November 6, 2003
288957 FIX: Multiple Calls To a User Defined Function Within an Aggregate Function May Return Incorrect Results Q288957 KB288957 November 6, 2003
288340 FIX: Errors in Transform Failure Function Are Logged When They Should Be Ignored Q288340 KB288340 November 6, 2003
288188 FIX: DTS Package Reports Success When FTP Task Doesn't Transfer All Files Q288188 KB288188 November 6, 2003
288174 FIX: Modifying a Table with DRI Cascade That Is Involved in an Indexed View May Cause Msg 8624 Q288174 KB288174 November 6, 2003
287713 FIX: Problems with DTS UI Help Topics Q287713 KB287713 November 6, 2003
287606 FIX: Enterprise Manager Reports Table Sizes That Are Inconsistent as Compared to sp_spaceused Q287606 KB287606 November 6, 2003
283790 INF: How to Create a SQL Server 2000 Trace Q283790 KB283790 November 6, 2003
279296 FIX: Using ALTER TABLE to Change Column Type Can Result in Unexpected NULL Values on INSERT Q279296 KB279296 November 6, 2003
274773 FIX: If You Change Windows Security to Windows/SQL Security the SA Password is Blank Q274773 KB274773 November 6, 2003
274224 FIX: Using SQL Server 2000 Merge Modules May Result in Confusing Message Q274224 KB274224 November 6, 2003
273572 BUG: Rebuildm.exe Utility Stops Responding When Source Directory is on a CD Q273572 KB273572 November 6, 2003
268251 INF: How to Identify Multiple Instances of SQL 2000 When You Use Performance Monitor Q268251 KB268251 November 6, 2003
263076 PRB: SQL Server 2000 Install May Fail Due to 'mfc42u.dll' Q263076 KB263076 November 6, 2003
328694 FIX: Disconnect and Disconnect All Actions in Query Analyzer Do Not Close All Connections to SQL Server Q328694 KB328694 November 5, 2003
322910 INF: Managed Range Identities in Merge Replication Q322910 KB322910 November 5, 2003
322853 FIX: SQL Server Grants Unnecessary Permissions or an Encryption Function Contains Unchecked Buffers Q322853 KB322853 November 5, 2003
321332 FIX: Full-Text Searches for Data That is Enclosed in Parenthesis() Inside HTML Tags is Not Being Returned Q321332 KB321332 November 5, 2003
321093 FIX: SEEK Uses Only First Column of Compound Index Which Results in a Sub-Optimal Plan Q321093 KB321093 November 5, 2003
320506 FIX: Parameters Not Pushed to Subqueries May Cause Suboptimal Plan Q320506 KB320506 November 5, 2003
308865 FIX: Logreader Fails with "...Could Not Execute Sp_replcmds.." Error Message Q308865 KB308865 November 5, 2003
301579 FIX: "Unspecified error" Raised When Working with DTS Packages on Localized SQL Server 2000 Q301579 KB301579 November 5, 2003
300272 FIX: Transfer of a View that Contains a UDF by Using DTS Export Data Fails with Error 208 Q300272 KB300272 November 5, 2003
300145 FIX: Merge Replication Conflict Viewer Resolves Data Conflicts Incorrectly Q300145 KB300145 November 5, 2003
300056 FIX: Merge Metadata Cleanup May Cause Subscriber Transaction Log to Grow Quickly Q300056 KB300056 November 5, 2003
300037 FIX: Error 229 "EXECUTE permission denied on object xp_mapdown_bitmap" on Merge Published Table Q300037 KB300037 November 5, 2003
299914 FIX: Executing MAX or MIN Aggregate Functions on Column with Hypothetical Clustered Index May Result in CPU SPIN Q299914 KB299914 November 5, 2003
299865 FIX: DMO BulkCopy Fails to Copy Data When Column Names Contain the Space Character Q299865 KB299865 November 5, 2003
299857 FIX: Trigger May Not Fire if Query Plan Uses CONSTANT SCAN Operator Q299857 KB299857 November 5, 2003
299787 FIX: Skewed Replication Statistics in Output File When Running Agent Continuously Q299787 KB299787 November 5, 2003
299649 FIX: Merge Replication Agent Fails with Error Message: "Unable to replicate a view or function" Q299649 KB299649 November 5, 2003
299620 FIX: Cannot Use a Profile Name Longer Than 32 Characters with SQL Mail Q299620 KB299620 November 5, 2003
299602 FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS Correctly Q299602 KB299602 November 5, 2003
299544 FIX: Correlated Subquery Containing UNION ALL May Cause Access Violation Q299544 KB299544 November 5, 2003
299543 FIX: ActiveX Transformation Function Not Triggered If LastRow Option in DTS Transform Data Task Is Less Than or Equal to Actual Number of Source Table Rows Q299543 KB299543 November 5, 2003
299470 FIX: SELECT with Distinct and Self Loop Join May Cause 1203 Error Message Q299470 KB299470 November 5, 2003
299466 FIX: Running Stack Dumper Causes Memory Leak of Virtual Bytes Q299466 KB299466 November 5, 2003
299462 FIX: Dump of Internal Structures while Users Connect or Disconnect May Cause Access Violation Q299462 KB299462 November 5, 2003
299448 FIX: Subquery That References Table with No Statistics and Returns Empty Result Set May Cause AV Q299448 KB299448 November 5, 2003
299382 BUG: Zeros Incorrectly Removed from the Binary Column in SQL Profiler Q299382 KB299382 November 5, 2003
299366 FIX: Calling Remote Stored Procedure Inside Local Stored Procedure While Passing Text Parameter Causes AV Q299366 KB299366 November 5, 2003
299361 FIX: Timestamp Column Truncated When Replicating with Sybase Using Merant OLEDB Provider Q299361 KB299361 November 5, 2003
299323 FIX : DBCC CHECKTABLE May Fail if Corruption Exists in Indexes Q299323 KB299323 November 5, 2003
299285 FIX: Query with Complex Correlated Subquery May Cause Unexpected Results in Aggregate Functions Q299285 KB299285 November 5, 2003
298951 FIX: Snapshot Agent for Merge Publication May Fail with 107 Error Q298951 KB298951 November 5, 2003
298835 FIX: Delete From Partition View that Contains Text or Image Data May Cause Error Q298835 KB298835 November 5, 2003
298830 FIX: Error Message: "Cannot Start 'Config XML support in IIS for SQL Server'" Q298830 KB298830 November 5, 2003
298803 FIX: Coalesce with Subquery May Generate an Access Violation Q298803 KB298803 November 5, 2003
298689 FIX: Analysis Manager Cube Browser May Fail While You Browse Cube Data Q298689 KB298689 November 5, 2003
295668 FIX: Transaction Replication to DB2 Subscribers Incorrectly Map Tinyint Data Type if You Use DTS to Transform Published Data Q295668 KB295668 November 5, 2003
295644 FIX: Transaction Log Restores May Fail with 3456 Error Q295644 KB295644 November 5, 2003
295627 FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98 Q295627 KB295627 November 5, 2003
295551 FIX: Text Pasted in Query Analyzer Result Window Is Not Visible Q295551 KB295551 November 5, 2003
295466 FIX: Affinity Mask Option in sp_configure Does Not Support 32 Processors Q295466 KB295466 November 5, 2003
295461 FIX: Profiler Fails To Start New Trace When User Environment Variable Has Been Changed Q295461 KB295461 November 5, 2003
295459 FIX: sp_helptext Fails with Invalid Length Parameter Error Q295459 KB295459 November 5, 2003
295325 FIX: Replication in Turkish Collation Fails with Error Message: "Error 21112: '-PollingInterval' is not a valid parameter for the Log Reader Agent" Q295325 KB295325 November 5, 2003
295193 FIX: Merge Module Sqlsvr.msm Fails Validation with ICE03 Q295193 KB295193 November 5, 2003
295120 FIX: OK Button for Changing the Recovery Model or the Compatibility Level in SQL Enterprise Manager is Disabled Q295120 KB295120 November 5, 2003
295048 FIX: Cannot Script Full-Text Indexes for Tables with No Primary Keys Even if Another Unique Index Exists Q295048 KB295048 November 5, 2003
295047 FIX: Full-Text Indexes Are Scripted Before Table Indexes Causing DB Creation Script Failure Q295047 KB295047 November 5, 2003
295046 FIX: OLE Automation Fails When Calling ADODB.Connection Methods Q295046 KB295046 November 5, 2003
295045 FIX: SELECT DISTINCT Returns Incorrect Results in SQL_Latin1_General_Pref_Cp1_CI_AS Collation Q295045 KB295045 November 5, 2003
295023 FIX : "SET ROWCOUNT" May Cause Data to be Unreadable Q295023 KB295023 November 5, 2003
295006 FIX : OSQL Utility Returns Incorrect Error Message Q295006 KB295006 November 5, 2003
294985 FIX: SQL Server Agent Proxy Account Not Cleaned Up When Instance Is Uninstalled Q294985 KB294985 November 5, 2003
294956 FIX: Enterprise Manager May Cause Access Violation When You Edit a DTS Package with Long User Name Q294956 KB294956 November 5, 2003
294872 FIX: Update on a Table with INT and BIT Columns May Zero Out INT Columns Q294872 KB294872 November 5, 2003
294828 FIX: Passing a Large Command Line String to Query Analyzer Results in Assertion Failed Q294828 KB294828 November 5, 2003
294783 FIX: Addition of a Column to an Incrementally Added Article Prior to Snapshot Generation Fails Q294783 KB294783 November 5, 2003
293761 FIX: Dynamic Filtered Tables Do Not Replicate Data From Joined Tables to SQL Server CE Subscribers Q293761 KB293761 November 5, 2003
293484 FIX: Incorrect Record is Deleted or Updated When a Clustered Index is in Descending Order Q293484 KB293484 November 5, 2003
293430 FIX: SEM New SQL Server Registration Using Long Server Name Fails with Access Violation Q293430 KB293430 November 5, 2003
293328 FIX: Update Query Does Not Execute Correctly Q293328 KB293328 November 5, 2003
293155 FIX: BCP with Format File and -R Parameter Ignores Regional Settings Q293155 KB293155 November 5, 2003
292761 FIX: xp_startmail Error Message Does Not Indicate Problem Q292761 KB292761 November 5, 2003
291276 FIX: Startup Stored Procedures Don't Execute with AWE Support Enabled Q291276 KB291276 November 5, 2003
291274 FIX: Correlated Subquery on Partitioned Views with Text Operations May Cause Access Violation Q291274 KB291274 November 5, 2003
290916 FIX: fn_virtualfilestats Skips the Last File Q290916 KB290916 November 5, 2003
290739 FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000 Q290739 KB290739 November 5, 2003
290210 FIX: Removal of Full-Text Index May Incorrectly Remove Rows From sysdepends System Table Q290210 KB290210 November 5, 2003
290077 FIX: DTS Scheduled Job Does Not Complete After First Run Q290077 KB290077 November 5, 2003
289893 FIX: Current Row's Time if Empty Is Replaced by Previous Row's Time in Bulk Copy Q289893 KB289893 November 5, 2003
288330 FIX: FTP Task in DTS Deletes File from the Destination Folder After the Package Completes Execution Q288330 KB288330 November 5, 2003
283786 INF: How to Monitor SQL Server 2000 Traces Q283786 KB283786 November 5, 2003
283784 INF: How to View SQL Server 2000 Activity Data Q283784 KB283784 November 5, 2003
283725 INF: How to View SQL Server 2000 Blocking Data Q283725 KB283725 November 5, 2003
281671 INF: Stored Procedure to Create a SQL Server 2000 Blackbox Trace Q281671 KB281671 November 5, 2003
281293 FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client Q281293 KB281293 November 5, 2003
276329 FIX: Complex Distinct or Group By Query Can Return Unexpected Results with Parallel Execution Plan Q276329 KB276329 November 5, 2003
270667 BUG: SQL Server 2000 SPX Named Instance Uses the Same Port as the Default Instance Q270667 KB270667 November 5, 2003
252225 PRB: An Error Message Occurs With a Distributed Query That Has A Named Instance Q252225 KB252225 November 5, 2003
180779 INF: Proper Use for DB-Library Err Handler Return Code INT_EXIT Q180779 KB180779 November 5, 2003
318000 FIX: Various Problems When You Call Transactional COM+ Components from ASP.NET Q318000 KB318000 November 4, 2003
304372 BUG: SQLOLEDB May Fail with Parameterized Queries Q304372 KB304372 November 3, 2003
286213 PRB: Second Parameterized Command Fails with Server Cursor Q286213 KB286213 November 3, 2003
236789 PRB: Full-Text Catalog May Be Lost After Restoring Suspect Database Using WITH REPLACE Q236789 KB236789 November 3, 2003
230406 BUG: DTS: Preview Shows Column Headers as Data When Invoked Multiple Times Q230406 KB230406 November 3, 2003
222657 INF: Storing a Directory Tree and Maintaining a Full Path Using Recursive Triggers Q222657 KB222657 November 3, 2003
221480 BUG: DTS: Default Scheduling Information Displayed Q221480 KB221480 November 3, 2003
220918 HOWTO: Using SQL DMO to Print Date in Regional Format Q220918 KB220918 November 3, 2003
220169 PRB: Keyset Cursor Based Off a Join Not Showing New Records Q220169 KB220169 November 3, 2003
218172 PRB: Cannot Change SA Password in Enterprise Manager Q218172 KB218172 November 3, 2003

SQL Server 2000 articles, fixes and updates - November 2003