SQL Server 7.0 articles, fixes and updates - October 2003

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

• 308801 FIX: DTSRUN Fails with Errors If the Arguments Have Multiple Space Characters Between Them Q308801 KB308801 October 31, 2003
• 308518 INF: Refresh of Current Activity in SEM May Cause "Error 1222: Lock Request time out period exceeded" Error Message Q308518 KB308518 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
• 299452 BUG: Copy Database Wizard Exits Without Error if any of the Source Databases are in Single User Mode Q299452 KB299452 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
• 295026 PRB: Errors When You Redistribute SQL Server 2000 DMO Clients in SQL Server 7.0 Environment Q295026 KB295026 October 31, 2003
• 293758 FIX: Nullability Changes Not Handled by SQL Server with Linked Server Queries to DB2 Q293758 KB293758 October 31, 2003
• 293320 PRB: DTS Transfer From SQL Server to Oracle Through OLE DB Provider Shows Ongoing Private Bytes Consumption Q293320 KB293320 October 31, 2003
• 293177 BUG: Hypothetical Clustered Index From Index Tuning Wizard May Cause Recompile Loop Q293177 KB293177 October 31, 2003
• 292588 PRB: Data Transformation Services May Fail to Import DBCS File Using Fixed Field Q292588 KB292588 October 31, 2003
• 292442 INF: How to Use the Windows Synchronize Manager with Pull Subscribers Q292442 KB292442 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
• 288745 PRB: DBCC CHECKDB Reports Error Message 2501 During Database Activity Q288745 KB288745 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
• 279660 INF: How to Query with Data Using SQL Mail and Exchange Server Q279660 KB279660 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
• 277535 INF: How to Install Localized SQL Server Error Messages Q277535 KB277535 October 31, 2003
• 275901 FIX: SQL RPC That Raises Error Will Mask @@ERROR with Msg 7221 Q275901 KB275901 October 31, 2003
• 275680 PRB: Bulk Operations into Tables Result in Rows Not Replicated in Merge Replication Q275680 KB275680 October 31, 2003
• 275618 FIX: Cannot Set SQLServerAgent Password to More Than 16 Characters in Enterprise Manager Q275618 KB275618 October 31, 2003
• 275312 INF: SQL Server Procedure to Change Object Owner Q275312 KB275312 October 31, 2003
• 275255 BUG: Incorrect Column Mapping: Destination Shows TIMESTAMP From Nullable BINARY Source Q275255 KB275255 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
• 266694 INF: ALTER TABLE with ADD COLUMN and DEFAULT May Take a Long Time on a Large Data Set Q266694 KB266694 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
• 256040 PRB: DTS Error "ValidateSchema Failed..." When You Run DTS Package If Tables Have Exact Same Structure Q256040 KB256040 October 31, 2003
• 255937 INF: How to Create and Attach a Removable SQL 7.0 Database Q255937 KB255937 October 31, 2003
• 254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Q254561 KB254561 October 31, 2003
• 252439 PRB: Use of Math Operations with DTS and Numeric Data Types Q252439 KB252439 October 31, 2003
• 249901 PRB: DTS Diagram Changes When DTS Package is Opened and Saved Outside the Package Designer Q249901 KB249901 October 31, 2003
• 241761 BUG: DTS Transfer Does Not Report Error When Input File Is Missing Text Qualifier in Last Row Q241761 KB241761 October 31, 2003
• 238678 PRB: RebuildM Cannot Find Original Master Database Files for MSDE Installation Q238678 KB238678 October 31, 2003
• 238673 BUG: Package Execution Can Fail if Target Table Has an Identity Q238673 KB238673 October 31, 2003
• 216519 PRB: SQL Server 6.0 Does Not Work with SQLOLEDB Provider in a SQL Server 7.0 Distributed Query Q216519 KB216519 October 31, 2003
• 198024 INFO: Understanding ADO Transactions with MS SQL Server Q198024 KB198024 October 31, 2003
• 327056 PRB: SQL Server Enterprise Manager Inserts Extra Spaces in a View's Column Names Q327056 KB327056 October 30, 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
• 318819 PRB: A DTS Package Raises Exceptions or Stops Responding When You Run It as a Scheduled Job Q318819 KB318819 October 30, 2003
• 315994 BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used Q315994 KB315994 October 30, 2003
• 312089 BUG: DTS Separates the Columns of Text at Invalid Trail Byte of DBCS Q312089 KB312089 October 30, 2003
• 308843 PRB: Non-Unique Clustered Index on a Published Table Causes Incorrect Data to Replicate to Subscribers Q308843 KB308843 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
• 306230 INF: How to Check the ANSI Settings Under Parsing Time Q306230 KB306230 October 30, 2003
• 301076 PRB: Unable to Connect to SQL Server Through ODBC When Password Contains a Semi-colon Q301076 KB301076 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
• 274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete Q274188 KB274188 October 30, 2003
• 251119 BUG: Last Row of Fixed Length File Fails to Import When File Does Not End with Row Delimiter Q251119 KB251119 October 30, 2003
• 247825 PRB: DTS Copy Table Uses Table Schema of Existing Table Q247825 KB247825 October 30, 2003
• 242543 INF: DTS Row Level Restartability After an Unexpected Failure Q242543 KB242543 October 30, 2003
• 44519 INF: Error Handling in Transact-SQL Blocks and Stored Procedures Q44519 KB44519 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
• 300192 BUG: DTS Import/Export Wizard or TransferObjectsTask Fails to Maintain Filegroup Settings for Transferred Objects Q300192 KB300192 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
• 275685 INF: Importing Performance Monitor Logs into SQL Server Q275685 KB275685 October 29, 2003
• 262340 BUG: LIKE with ESCAPE May Result in Different Query Access Plan Q262340 KB262340 October 29, 2003
• 255067 PRB: Owner of a Table Cannot Access It Directly If Made Sysadmin After Creation Q255067 KB255067 October 29, 2003
• 244124 BUG: Creating a View in Enterprise Manager Using a Domain Account May Fail Q244124 KB244124 October 29, 2003
• 218995 BUG: Error "Invalid Object Name" on Linked Server Table Through OLEDB Q218995 KB218995 October 29, 2003
• 216808 PRB: Use BUILTIN\Group to Grant Access to Predefined Windows NT Groups Q216808 KB216808 October 29, 2003
• 200794 PRB: Sp_addlinkedserver Does Not Validate the OLE DB Provider Q200794 KB200794 October 29, 2003
• 309392 PRB: BobMgr::GetBuf() Errors May Be Registered in the SQL Server Error Log Q309392 KB309392 October 28, 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
• 260895 PRB: Error -2147217900 When You Run Distributed Queries in SQL from MTS Q260895 KB260895 October 28, 2003
• 239092 BUG: BOL Incorrectly States That SQL Server Doesn't Support TOP Queries Q239092 KB239092 October 28, 2003
• 238146 PRB: Constraint Violation Is Not Detected If Update with the Same Data Q238146 KB238146 October 28, 2003
• 221465 INF: Using the WITH MOVE Option with the RESTORE Statement Q221465 KB221465 October 28, 2003
• 824423 PRB: Restore Operation May Fail When You Try to Restore a SQL Server 2000 Database in SQL Server 7.0 Q824423 KB824423 October 23, 2003
• 811899 PRB: Error 4928 Occurs When You Try to Rename a Non-Replicated Column Q811899 KB811899 October 17, 2003
• 325334 INF: SQL Server and Striped Backups Q325334 KB325334 October 17, 2003
• 324711 PRB: You Cannot See the Edit Insertion Point in SQL Server Enterprise Manager When You Edit a Table Row Q324711 KB324711 October 17, 2003
• 324192 PRB: SQL Server Maintenance Wizard Does Not Allow Scheduled Filegroup or Differential Backups Q324192 KB324192 October 17, 2003
• 323607 PRB: Unable to View the Properties for a Database Maintenance Plan Q323607 KB323607 October 17, 2003
• 323161 INF: Avoid Using Device Names as Database Names Q323161 KB323161 October 17, 2003
• 321670 PRB: Backup Size Displayed Incorrectly in SQL Server Enterprise Manager When the Backup Size is Greater Than 2,147,483,647 Bytes (2 GB) Q321670 KB321670 October 17, 2003
• 315689 INF: SQL Query Analyzer Color Code Information Q315689 KB315689 October 17, 2003
• 314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO Counters Q314648 KB314648 October 17, 2003
• 313969 PRB: The Error "Cannot Open .pst File" Occurs When You Use a POP3 Server Profile with SQL Mail Q313969 KB313969 October 17, 2003
• 306366 PRB: Errors 3437, 3414, and "Could Not Connect to DTC" Occur When You Start SQL Server Q306366 KB306366 October 17, 2003
• 303712 BUG: Use of the sp_rename Stored Procedure to Change the Case of a Column Name Fails Q303712 KB303712 October 17, 2003
• 303515 BUG: BCP May Fail to Import All Rows When You Use a Multi-character Row Delimiter Q303515 KB303515 October 17, 2003
• 303459 INF: How to Improve the Performance of Full-Text Search Queries for Large Database Tables Q303459 KB303459 October 17, 2003
• 303445 PRB: ObjectID Filter in SQL Profiler Triggers Only with Specific Events Q303445 KB303445 October 17, 2003
• 300701 BUG: BCP into Temporary Table Fails with Error 229 "INSERT Permission Denied" Q300701 KB300701 October 17, 2003
• 295742 BUG: UPDATE Statement Using a SELECT with Aggregates and JOIN May Generate Internal Error Q295742 KB295742 October 17, 2003
• 295371 PRB: Filegroup Log Restore May Fail with Error Message 4305 Q295371 KB295371 October 17, 2003
• 293867 BUG: SQL Server ODBC Driver 3.7 Bug with BatchUpdate and RDO Q293867 KB293867 October 17, 2003
• 288527 BUG: SQL Server Enterprise Manager Design View May Change the T-SQL Syntax of a View Q288527 KB288527 October 17, 2003
• 286290 BUG: Entity Defaults Are Ignored When Clarification Question Is Asked Q286290 KB286290 October 17, 2003
• 285635 BUG: SQL Scheduled Job Skips Every Other Day with Weekly Schedule Q285635 KB285635 October 17, 2003
• 285114 BUG: When You Use a Full Text Query Clause Greater Than 8K an Error Message Occurs That Does Not Indicate Overflow of Size Limit Q285114 KB285114 October 17, 2003
• 281347 BUG: Can't Append Columns to Tables with Large Number of Columns in SEM Table Designer Q281347 KB281347 October 17, 2003
• 281346 BUG: Fetch From a Dynamic Cursor Causes an Access Violation Q281346 KB281346 October 17, 2003
• 280759 PRB: SQL 7.0 VDI Backup May Fail When SQL Server 2000 Is Installed on the Same Computer Q280759 KB280759 October 17, 2003
• 279108 PRB: OSQL Utility Cannot Run Under Hindi Locale/Indic Language Setting on Window 2000 Q279108 KB279108 October 17, 2003
• 278897 BUG: Existing Maintenance Plan Fails to Download to New Target Server Q278897 KB278897 October 17, 2003
• 277848 BUG: Error Message "Table Corrupt Object ID 0, index ID 0, page ID.." Occurs When You Run DBCC DBREINDEX in SQL Server Q277848 KB277848 October 17, 2003
• 275696 BUG: DCR: Enterprise Manager May Allow You to Select Backups that No Longer Exist Q275696 KB275696 October 17, 2003
• 275025 BUG: Cannot Design Table in SQL Server Enterprise Manager if Database Compatibility is Set to 60 Q275025 KB275025 October 17, 2003
• 274643 BUG: Estimated Execution Plan Steps Can Show Costs Greater Than 100% Q274643 KB274643 October 17, 2003
• 274165 BUG: Select Query Against a View That Contains Left Outer Joins May Return Incorrect Results Q274165 KB274165 October 17, 2003
• 273593 BUG: SEM Help Displays Incorrect Size Information for Unicode Columns Q273593 KB273593 October 17, 2003
• 270716 INF: You Cannot Use xp_loginconfig to Set Configuration Values Q270716 KB270716 October 17, 2003
• 270671 PRB: Full Text Search Menus Are Not Enabled for Local Windows NT Accounts Q270671 KB270671 October 17, 2003
• 269558 PRB: SQL Server Upgrade Wizard Generates a Warning for Stored Procedures Created with '.object_name' or '..object_name' Q269558 KB269558 October 17, 2003
• 269426 PRB: Use of FULL OUTER JOIN with TEXT Column Through a Linked Server Returns Error Message 8626 Q269426 KB269426 October 17, 2003
• 266224 BUG: Only One Double-Quoted String Allowed in xp_cmdshell String Q266224 KB266224 October 17, 2003
• 266124 BUG: BackOffice Setup Erroneously Reports that Full-Text Search is Installed Q266124 KB266124 October 17, 2003
• 264593 PRB: RESTORE WITH STANDBY Does Not Catch Invalid or ReadOnly File Name Until After the Load Q264593 KB264593 October 17, 2003
• 264163 BUG: Upgrade of Logins with Default Language Francais Cause Error 15033 Q264163 KB264163 October 17, 2003
• 263887 BUG: Upgrade of an Empty Table Resets Identity Value to Seed Q263887 KB263887 October 17, 2003
• 262951 PRB: System Stored Procedures Return Underlying SQL Code or Unexpected Results Q262951 KB262951 October 17, 2003
• 262258 BUG: Alert May Fail to Send E-mail Notification with xp_logevent or RAISERROR Q262258 KB262258 October 17, 2003
• 260652 PRB: Nested Loop Join That Uses A "BOOKMARK LOOKUP ...WITH PREFETCH" May Hold Locks Longer Q260652 KB260652 October 17, 2003
• 259710 PRB: SQL Server Agent Fails to Start on Windows 9x When You Change the sa Password Q259710 KB259710 October 17, 2003
• 259466 BUG: SELECT Statement with a Correlated Subquery on a View with a Substring Causes an Access Violation on a Multi-Proc Computer Q259466 KB259466 October 17, 2003
• 258806 BUG: Maintenance Job History Does Not Show Correct Durations When a Job Takes Longer Than an Hour Q258806 KB258806 October 17, 2003
• 257856 INF: SQL Server Agent Automatically Sets "Trunc. Log on Chkpt" for MSDB Q257856 KB257856 October 17, 2003
• 254492 PRB: Views Fail to Upgrade Q254492 KB254492 October 17, 2003
• 253274 BUG: xp_sqltrace Cannot Be Used as a Startup Procedure Q253274 KB253274 October 17, 2003
• 252733 BUG: Optimizer Chooses Table Scan Instead of Index Seek Q252733 KB252733 October 17, 2003
• 252519 BUG: Transfer Manager Fails When Application Role Defined Q252519 KB252519 October 17, 2003
• 249887 BUG: BCP/BULK INSERT Into a View May Cause Defaults Defined in Base-table to be Ignored Q249887 KB249887 October 17, 2003
• 249032 BUG: Error Message 8644 Returned When Inserting into a Table with a Trigger Q249032 KB249032 October 17, 2003
• 248391 PRB: Error 1314 Raised By xp_cmdshell When Executed as Non-SA User Q248391 KB248391 October 17, 2003
• 247879 BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation Q247879 KB247879 October 17, 2003
• 247193 INF: Database Property Sheet Displayed Incorrectly Q247193 KB247193 October 17, 2003
• 246181 INF: SQL 6.5 Database Upgrade with a Space in the Path to Master.dat Fails Q246181 KB246181 October 17, 2003
• 245556 BUG: Running SQLDIAG.EXE Produces an Internal Error in the Application Event Log - EventID 998 Q245556 KB245556 October 17, 2003
• 244513 PRB: Scheduled SQL Server Backups Display "BackupTapeFile::WriteFileMark: WriteTapemark failure" Error Q244513 KB244513 October 17, 2003
• 243811 INF: Sqldiag.exe Can be Included in an MSDE Custom Setup Q243811 KB243811 October 17, 2003
• 243754 BUG: Other Users Can See Your Registered SQL Servers in SQL Enterprise Manager Q243754 KB243754 October 17, 2003
• 243382 PRB: Select @@Version Not Working on Dynamic Cursors Q243382 KB243382 October 17, 2003
• 243023 PRB: Error 8104 Occurs with Non-Admin Owner Using Set IDENTITY_INSERT Q243023 KB243023 October 17, 2003
• 242522 FIX: CCommand::Open() Fails with SQL Server 7.0 and LARGE_INTEGER Q242522 KB242522 October 17, 2003
• 242260 INFO: Cannot Use OSP Data Providers with SQL DTS Q242260 KB242260 October 17, 2003
• 240839 PRB: Pressing ESC When Modifying SP in SEM Erases Changes Without Prompting Q240839 KB240839 October 17, 2003
• 238676 PRB: Removing Shared DLL in SQL Uninstall Makes VB Add-ins Unloadable Q238676 KB238676 October 17, 2003
• 236989 BUG: Uninstalling SQL 6.5 After Upgrade to 7.0 May Remove 7.0 Data Files Q236989 KB236989 October 17, 2003
• 234890 BUG: 7.0 ISQL.EXE Returns Different Results than 6.5 ISQL.EXE Q234890 KB234890 October 17, 2003
• 234181 INF: Logins Aliased to Databases Users Cannot Be Viewed from SQL Enterprise Manager Q234181 KB234181 October 17, 2003
• 232991 PRB: SQLExtendedFetch with SQL_FETCH_RELATIVE Fails to Return all Records after a Delete and Rollback using Keyset Cursors Q232991 KB232991 October 17, 2003
• 232196 INF: Log Space Used Appears to Grow After Restoring from Backup Q232196 KB232196 October 17, 2003
• 232195 INF: Proper Use of the COLUMNS_UPDATED() Function Q232195 KB232195 October 17, 2003
• 231889 BUG: DOCERR: BOL States T-SQL Outer Joins in FROM Clause Support to be Dropped Q231889 KB231889 October 17, 2003
• 231830 INF: Insertion of Strings Containing Trailing Spaces Q231830 KB231830 October 17, 2003
• 226488 BUG: Database Owner is Not Associated w/ User Id DBO Q226488 KB226488 October 17, 2003
• 223423 BUG: Optimizer Uses Scan with Multiple OR Clauses on Composite Index Q223423 KB223423 October 17, 2003
• 221832 INF: How to Enable Logging for SQL Server Cluster Wizard Q221832 KB221832 October 17, 2003
• 220598 PRB: SQL Distributed Query with MSIDXS Provider Needs Additional Quotes Q220598 KB220598 October 17, 2003
• 217034 PRB: Two Digit Year Display of Date Fields in SQL Enterprise Manager (SEM) Q217034 KB217034 October 17, 2003
• 214602 INF: sp_dbcmptlevel 'master' is not Allowed Q214602 KB214602 October 17, 2003
• 207396 INF: Cannot See Actual Data Values for Columns in Enterprise Manager Q207396 KB207396 October 17, 2003
• 201905 BUG: Distributed SQL Update, Jet Provider may not Return Errors Q201905 KB201905 October 17, 2003
• 201890 BUG: SEM: Title of a New Object Does Not Reflect the New Object Name After Save Q201890 KB201890 October 17, 2003
• 201846 BUG: Reference to Deferred Object in Stored Procedure Will Not Show in Sp_depends Q201846 KB201846 October 17, 2003
• 201042 BUG: Stored Procedure Remains After Execution by Sp_makewebtask Q201042 KB201042 October 17, 2003
• 200117 INF: Not Possible to Remove Optional Components of SQL Server Q200117 KB200117 October 17, 2003
• 198851 INF: User Cannot Bind Rule to UDDT Created By Different User Q198851 KB198851 October 17, 2003
• 814579 PRB: You Receive Error Message: "The log file for database 'Database Name' is full" While Restoring a SQL Server 7.0 Database Backup on SQL Server 2000 Q814579 KB814579 October 16, 2003
• 813199 PRB: SQL Server Books Online Incorrectly States the Type of Result Set for @@CPU_BUSY, @@IO_BUSY and @@IDLE Functions Is Milliseconds Instead of Ticks Q813199 KB813199 October 16, 2003
• 811483 PRB: You Receive a Warning Message When You Create a Recursive Stored Procedure Q811483 KB811483 October 16, 2003
• 325187 PRB: Consecutively Declaring Nested Cursors Immediately Returns a FETCH_STATUS Value of -1 Q325187 KB325187 October 16, 2003
• 323596 PRB: You Can Only Use the Sp_grantlogin Stored Procedure with Windows NT Group Names That Are Less Than or Equal to 63 Characters Q323596 KB323596 October 16, 2003
• 323586 PRB: A SELECT INTO Query May Return the Internal Query Processor Error 8630 Q323586 KB323586 October 16, 2003
• 323323 BUG: Certain Field Terminators May Cause the BCP Utility or a BULK INSERT Statement to Import DBCS Data Incorrectly Q323323 KB323323 October 16, 2003
• 322877 INF: SAP Retail - Benchmark (White Paper) Q322877 KB322877 October 16, 2003
• 322746 PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found Q322746 KB322746 October 16, 2003
• 320773 PRB: Changes to a Table That Is Part of an "Immediate Updating" Subscription Generates an Error Message Q320773 KB320773 October 16, 2003
• 320208 PRB: Distributed Queries That Are Wrapped in a Stored Procedure with Input Parameters May Experience Performance Degradation Q320208 KB320208 October 16, 2003
• 317832 PRB: Subscriptions in System Databases Not Supported Q317832 KB317832 October 16, 2003
• 312983 INF: Lotus Notes GUID Format Different Than SQL Server GUID Q312983 KB312983 October 16, 2003
• 307930 BUG: Distribution Agent Parameters Listed After -QuotedIdentifier Are Ignored Q307930 KB307930 October 16, 2003
• 306628 INF: Inconsistent Behavior with Object Ownership with db_owner Created Objects Q306628 KB306628 October 16, 2003
• 306608 BUG: Distribution Agent May Fail with Incorrect Syntax when Table Name Contains Hyphens Q306608 KB306608 October 16, 2003
• 301299 PRB: Security Context of Dynamic SQL Statements Inside a Stored Procedure Q301299 KB301299 October 16, 2003
• 298674 PRB: Subquery Resolves Names of Column to Outer Tables Q298674 KB298674 October 16, 2003
• 297861 PRB: Poor Performance on a Heap Q297861 KB297861 October 16, 2003
• 296792 PRB: Expired Subscription Cleanup Agent Fails if the First Published Database is Deleted Q296792 KB296792 October 16, 2003
• 296559 PRB: ALTER COLUMN Sets TrimTrailingBlanks Property to NO Q296559 KB296559 October 16, 2003
• 295949 BUG: Source File with Several ESQLC Statements May Cause Access Violation in the Precompiler Q295949 KB295949 October 16, 2003
• 295305 PRB: Creating Temp Table Inside IF and ELSE Conditions Gives Error 2714 Q295305 KB295305 October 16, 2003
• 294942 PRB: SET CONCAT_NULL_YIELDS_NULL May Cause Stored Procedures to Recompile Q294942 KB294942 October 16, 2003
• 291263 PRB: Custom Stored Procedure Resolvers Don't Fire When Conflict Involves UPDATE and DELETE Q291263 KB291263 October 16, 2003
• 289287 BUG: BOL Incorrectly States the Precedence of Bitwise Operators Q289287 KB289287 October 16, 2003
• 287515 PRB: Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location Q287515 KB287515 October 16, 2003
• 284997 PRB: Information About Use of LIKE Operator to Convert String to Datetime Query Q284997 KB284997 October 16, 2003
• 284443 BUG: Destroying OLE Automation Object May Leave Orphaned SQL Processes Q284443 KB284443 October 16, 2003
• 281680 BUG: FORMATMESSAGE Works with the Same User-Defined Messages as RAISERROR Q281680 KB281680 October 16, 2003
• 281676 PRB: Converting Datetime to Another Datatype May Result in Inaccurate Value Q281676 KB281676 October 16, 2003
• 281341 PRB: Loss of Precision May Occur When You Use SUM or AVG Functions In a Formula with Division Q281341 KB281341 October 16, 2003
• 280834 PRB: Query Analyzer Returns Error Message When You Select NEWID() After You Reduce the Maximum Characters Per Column Q280834 KB280834 October 16, 2003
• 280684 PRB: Merge Replication Fails with "Process could not enumerate changes" Error Message When Assigning a Blank Value to an Image Column Q280684 KB280684 October 16, 2003
• 280468 BUG: SELECT with GROUP BY ALL Clause in a Nested Correlated Subquery Causes 8624 Error Message or Access Violation Q280468 KB280468 October 16, 2003
• 280406 PRB: Dynamic Cursor Infinite Loop When a Non-Unique Clustered Index Key Is Updated to an Equal or Larger Value Q280406 KB280406 October 16, 2003
• 280295 PRB: sp_attach_db and CREATE DATABASE FOR ATTACH Do Not Remove Replication Tables Q280295 KB280295 October 16, 2003
• 279857 BUG: Error 3910, "Transaction Context in Use by Another Session" Q279857 KB279857 October 16, 2003
• 278984 PRB: Error 7321 Occurs When You Run a Query That Uses Four-Part Names Against DB2 on an AS/400 Computer Q278984 KB278984 October 16, 2003
• 278612 PRB: Installing SQL Server 7.0 Fails If SQL Server 2000 Is Already Installed Q278612 KB278612 October 16, 2003
• 277703 BUG: Cannot Specify Length of User-Defined Data Type When Based on Float Q277703 KB277703 October 16, 2003
• 276195 BUG: Some String Functions Do Not Work as Expected on Binary Data Q276195 KB276195 October 16, 2003
• 275583 PRB: SELECT...FOR XML AUTO Results Are Separated into Lines of 2033 Chars with ODBC Q275583 KB275583 October 16, 2003
• 275307 BUG: Installation of SQL Server 2000 Desktop Engine Fails on Computers That Already Have SQL Server 7.0 Tools Installed Q275307 KB275307 October 16, 2003
• 274747 PRB: Registered Remote SQL Servers May Be Lost from SQL Server 2000 Enterprise Manager Q274747 KB274747 October 16, 2003
• 274729 BUG: Internal Error with SELECT Statement Containing Correlated Subquery and GROUP BY Q274729 KB274729 October 16, 2003
• 272496 BUG: DCR: SQL Server Books Online Incorrectly States That IS_NULLABLE Returns YES or NO Q272496 KB272496 October 16, 2003
• 271827 BUG: DOC Error: Cannot Use Variables as SEED Parameter to the IDENTITY() Function Q271827 KB271827 October 16, 2003
• 271669 INF: Distributed Queries are not Run as Parallel Query Steps Q271669 KB271669 October 16, 2003
• 268593 PRB: Querying a DATETIME Value Without Quotes Gives Unexpected Results Q268593 KB268593 October 16, 2003
• 264194 BUG: DB Maintenance Plan Cannot Be Modified to Include/Exclude Integrity Checks Before Backups Q264194 KB264194 October 16, 2003
• 260252 BUG: Merge Replication to Jet 4.0 Subscribers Performs Initial Synchronization when You Select the Manual Synchronization Option Q260252 KB260252 October 16, 2003
• 260246 BUG: Merge Replication to Jet 4.0 Subscriber Does Not Allow You to Set the ROWGUIDCOL Column as a Primary Key Column Q260246 KB260246 October 16, 2003
• 257345 BUG: SQL Server Books Online States That the Single User Mode Prevents All Locks Q257345 KB257345 October 16, 2003
• 257334 BUG: SQL Server Books Online States that TRUNCATE TABLE Is Nonlogged Q257334 KB257334 October 16, 2003
• 246330 BUG: Large Number of Agents on a Replication Distribution Server May Cause Heavy Deadlocking in TEMPDB Q246330 KB246330 October 16, 2003
• 241511 PRB: REPL: Msgs. 20515, 21054, or 20512 with Immediate-Updating Subscribers Q241511 KB241511 October 16, 2003
• 234736 BUG: SQLDMO - Query Analyzer May Fail to Connect if SQL Server Is Started as Part of Connection Attempt Q234736 KB234736 October 16, 2003
• 231848 BUG: Object Scripting Tool Places a TEXTIMAGE_ON Clause When no Text, Ntext, or Image Column is Present Q231848 KB231848 October 16, 2003
• 216575 INF: xp_enum_oledb_providers Enumerates the OLE DB Providers Q216575 KB216575 October 16, 2003
• 201909 BUG: Locking Behavior in Transactions Is Incorrect Q201909 KB201909 October 16, 2003
• 277002 PRB: Distributed Query Against Oracle 8.x Fails Q277002 KB277002 October 15, 2003
• 322988 PRB: sp_grantlogin "NT AUTHORITY\SYSTEM" Fails on Microsoft Windows NT 4.0 Q322988 KB322988 October 9, 2003
• 321852 DOC: Loopback_detection Option is Not Clearly Explained in SQL Server Books Online Q321852 KB321852 October 9, 2003
• 316976 FIX: Tuning Wizard May Fail When You Specify a Workload File for Non-dbo Owned Objects Q316976 KB316976 October 9, 2003
• 313986 INF: SQL Server 7.0 Service Pack 4 Readme.htm Additions Q313986 KB313986 October 9, 2003
• 258234 BUG: Query Analyzer May Not Display All Results with Some Error Sequences Q258234 KB258234 October 9, 2003
• 269412 FIX: Access Violation Occurs When You Call SQL Server Stored Procedure That Contains PRINT Statement Q269412 KB269412 October 3, 2003
• 263695 BUG: UPDATE Statement with SELECT DISTINCT Subquery with Parallelism Enabled May Cause Access Violation Q263695 KB263695 October 3, 2003