SQL Server 7.0 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 7.0 starts with letter B that have been released. The list is daily updated.

279888 BUG: Error When You Use Client Cursor to Add Record to SQL Server Table That Has Default Value in Datetime Field Q279888 KB279888 April 13, 2018
298723 BUG: SQL Mail may not be fully supported for use with virtual SQL Servers Q298723 KB298723 January 16, 2015
293111 BUG: Error "Login Failed" from Data View Window If Allow Saving Password Is Not Checked Q293111 KB293111 January 16, 2015
270061 BUG: Access Violation Occurs When You Debug Stored Procedure Q270061 KB270061 January 16, 2015
269883 BUG: SQL Server Optimizer Chooses Bad Plan with Self Joined Tables Q269883 KB269883 January 16, 2015
268808 BUG: Create Database Statement Does Not Allow Creation of Maximum Size Database File Q268808 KB268808 January 16, 2015
248602 BUG: ODBC Driver Incorrectly Shows Linked Data as #DELETED Q248602 KB248602 January 16, 2015
233161 BUG: Xp_logininfo Returns Error 8198 Q233161 KB233161 January 16, 2015
231880 BUG: Import Wizard Fails if Excel File is Open During Import/Export Q231880 KB231880 January 16, 2015
229747 BUG: Query with Joins, Aggregate, Concatenation May Cause AV Q229747 KB229747 January 16, 2015
225129 BUG: Error 18456 when trying to configure publishing using a remote distributor Q225129 KB225129 January 16, 2015
221981 BUG: Xp_sendmail Sends Text Data in 4 KB Chunks Q221981 KB221981 January 16, 2015
207718 BUG: User's Role Not Updated Instantly in Multiple Sessions Q207718 KB207718 January 16, 2015
153996 BUG: The error message provides an incorrect table name when you use an ambiguous update statement in SQL Server Q153996 KB153996 January 16, 2015
152393 BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions Q152393 KB152393 January 16, 2015
151545 BUG: xp_sendmail with @query leaves temporary files on server Q151545 KB151545 January 16, 2015
141664 BUG: Convert From Binary to Numeric Gives Error 8114 Q141664 KB141664 January 16, 2015
282827 BUG: Transaction Names Are Case Sensitive on a Non-Case-Sensitive SQL Server Q282827 KB282827 April 30, 2014
198520 BUG: You receive an "OLE DB Provider 'atlprov' reported an error" error message when you try to use an ATL wizard-generated OLE DB Provider in Visual C++ Q198520 KB198520 December 27, 2013
246326 BUG: Bulk Insert Task in a DTS Package Fails on an SQL Active/Passive Cluster Setup Q246326 KB246326 November 3, 2013
324191 BUG: Xp_sendmail Fails If @recipients Parameter Is More Than 256 Characters Q324191 KB324191 November 2, 2013
322818 BUG: Incorrect Identity Value with Self-Referencing FOREIGN KEY Constraint Q322818 KB322818 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
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
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
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
295121 BUG: DOC Error: Documentation Incorrectly States that DB_Owner role has Restore Database Permissions Q295121 KB295121 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
289290 BUG: DBCC SHRINKDATABASE Causes Memory Leak and Error 17803 When AUTO_SHRINK Is Set Q289290 KB289290 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
284141 BUG: Insert From Subquery Returns Error Message 213 "Insert Error.." Q284141 KB284141 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
281590 BUG: Profiler Truncates RPC Procedure Name At 30 Characters Q281590 KB281590 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
281093 BUG: Noncontiguous Colids in Syscolumns Causes Sp_addarticle to Fail with Error 50007 Q281093 KB281093 November 2, 2013
280458 BUG: SQL Server May Not Find Existing Appropriate Query Plan Causing Recompilation Q280458 KB280458 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
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
278324 BUG: Distribution Agent Fails During Initial Synchronization When You Use Stored Procedure Replication Q278324 KB278324 November 2, 2013
277842 BUG: SQL Server 7.0 Uninstall Does Not Remove Licensing Information Q277842 KB277842 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
275436 BUG: Distribution Agent Fails When Validating Publication with Stored Procedure Articles Q275436 KB275436 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
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
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
271258 BUG: Original db_datareader Role is Lost if dbuser is Assigned a New db_datawriter Role Q271258 KB271258 November 2, 2013
269884 BUG: Invalid Style Parameter in CONVERT Function May Cause Access Violation Q269884 KB269884 November 2, 2013
269486 BUG: Changing Max Worker Threads Requires You to Restart SQL Server Q269486 KB269486 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
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
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
264058 BUG: Access Violation with xp_cmdshell Returning Data into a Table with More Columns Than Returned Q264058 KB264058 November 2, 2013
263886 BUG: xp_trace_addnewqueue Timeout is in Seconds Q263886 KB263886 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
260355 BUG: Snapshot Job Adds Create Index Command for Transactional Publications Even if not Requested Q260355 KB260355 November 2, 2013
260276 BUG: Agent Profile Check Box "Change all existing Agents.." Does Not Change Existing Agents Q260276 KB260276 November 2, 2013
260235 BUG: Point-in-Time Recovery Adds Incorrect Seconds Value to Recovery Time Selected in SEM Q260235 KB260235 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
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
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
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
250604 BUG: FILLFACTOR on Published Table Makes Merge Replication to JET 4.0 Subscribers Fail with "Syntax error" Message Q250604 KB250604 November 2, 2013
248265 BUG: BCP Will Not Load Native File if First Two Bytes Are 0xFEFF Q248265 KB248265 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
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
243665 BUG: Using Multi Protocol Connections Elevate SQL Server Thread Counts Q243665 KB243665 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
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
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
236407 BUG: Active/Passive Cluster Setup Breaks Replication and DTS Q236407 KB236407 November 2, 2013
236003 BUG: DB-Library bcp_sendrow() Fails on SQL 7.0 Q236003 KB236003 November 2, 2013
233232 BUG: (DOC) Description of Sysaltfiles Table Incorrect Q233232 KB233232 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
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
224445 BUG: SQL Cluster Setup Wizard Fails When Path Contains Spaces Q224445 KB224445 November 2, 2013
222127 BUG DOC: Log Backup Mode Incorrectly Documented for Maintaining Log Backup Sequence Q222127 KB222127 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
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
203824 BUG: Incomplete Display of Some System Roles Q203824 KB203824 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
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
166200 BUG: Errors 2714 and 267 on INSERT INTO Global Temp Table Q166200 KB166200 November 1, 2013
158684 BUG: Unable to Reload Master DB After Upgrading SQL Server Q158684 KB158684 November 1, 2013
324122 BUG: BULK INSERT Fails with Error Message 7399 Q324122 KB324122 October 26, 2013
316203 BUG: INSERT of RESTORE HEADERONLY Results into Temp Table May Generate an Access Violation Q316203 KB316203 October 26, 2013
310822 BUG: Xp_sendmail with @Query Parameter on a Cluster Generates Error 17969 Q310822 KB310822 October 26, 2013
295939 BUG: sp_OAMethod May Cause Access Violation When @@servername Is NULL Q295939 KB295939 October 26, 2013
284938 BUG: Ghosted Record Cleanup Process May Go Into CPU Spin Due to an Invalid Check for Cleanup Type Q284938 KB284938 October 26, 2013
274762 BUG: DTSRUN Fails to Run Package Stored in Repository on Secondary Node of Cluster Q274762 KB274762 October 26, 2013
274030 BUG: Outer Joins with Many Tables May Cause 701 Error Message "..Insufficient System Memory ..." Q274030 KB274030 October 26, 2013
255097 BUG: Error 7356 from a Distributed Query Q255097 KB255097 October 26, 2013
254598 BUG: Index Cannot be Dropped if the Name Begins with "#" Character Q254598 KB254598 October 26, 2013
247751 BUG: Database Maintenance Plan Does Not Shrink the Database Q247751 KB247751 October 26, 2013
246199 BUG: Changed Locale Settings in Extended Stored Procedure May Cause Incorrect Results Q246199 KB246199 October 26, 2013
240356 BUG: SQLOLEDB Treats AutoTranslate, UseProcForPrepare and WSID as Read-Only Q240356 KB240356 October 26, 2013
234028 BUG: sp_articleview May Generate an Arithmetic Overflow Q234028 KB234028 October 26, 2013
229608 BUG: SQL 7.0 Desktop Edition Install on Windows 98 Causes "Assertion Failed File: ..\SRC\SQLSSPI.C Line: 119" Q229608 KB229608 October 26, 2013
229052 BUG: SQL Enterprise Manager Generates SQL-DMO Error for DBO Updating Permissions Q229052 KB229052 October 26, 2013
221513 BUG: DTS - Error Creating File Mapping View Q221513 KB221513 October 26, 2013
220842 BUG: Error 924 When Cross-Database Query Run from Context of Database in Single User Mode Q220842 KB220842 October 26, 2013
201760 BUG: Restore With STANDBY Option May Recover a Database Q201760 KB201760 October 26, 2013
197299 BUG: SELECT INTO with Fixed Memory May Cause Errors 802 and 17803 Q197299 KB197299 October 26, 2013
196629 BUG: DBCC MEMUSAGE Is Not Supported in SQL Server 7.0 Q196629 KB196629 October 26, 2013
301383 BUG: DTS May Return a Success Even When it Fails to Transfer Data Q301383 KB301383 October 24, 2013
301382 BUG: DTS May Transfer the Unnecessary Lead Byte of a Double-Byte Character Q301382 KB301382 October 24, 2013
300959 BUG: Duplicate Rows Inserted by BCP into a Table That Has a Unique Nonclustered Index Q300959 KB300959 October 24, 2013
294180 BUG: ADO: Append Cannot Be Used with OLE DB Provider For SQL Server if the Name of the Table Contains Spaces Q294180 KB294180 October 23, 2013
248046 BUG: SQL Debugging with SQL Server 7.0 Fails on Third Session in Visual InterDev Q248046 KB248046 October 22, 2013
245253 BUG: DTS Packages Stored in the Repository Are Not Listed Q245253 KB245253 October 22, 2013
244537 BUG: DTS: Table Transfers Incorrectly If Using Char or Varchar Larger Than 4000 Characters Q244537 KB244537 October 22, 2013
240678 BUG: DOC Error: DNR and Compilation Section Incorrectly States Stored Procedures Do Not Execute Q240678 KB240678 October 22, 2013
281809 BUG: Error Message 823 or Retail Assert Encountered During Restore of SQL Server Log Backup Q281809 KB281809 October 21, 2013
273789 BUG: DTS Truncates ActiveX Scripts Q273789 KB273789 October 21, 2013
271564 BUG: DTS Designer Might Send an Attention Signal Before SQL Task Completes Q271564 KB271564 October 21, 2013
271144 BUG: DTS Execute SQL Task Fails to Complete When Constraints are Violated Q271144 KB271144 October 21, 2013
236334 BUG: Multi-Protocol Connection Fails with SQL 6.5 and Integrated Security Using 7.00.623 Netlib Q236334 KB236334 October 21, 2013
234906 BUG: Source Control Times Out When You Add Stored Procedures Q234906 KB234906 October 21, 2013
233374 BUG: Error 7356 When Using SQL 7.0 to Select From a SQL 6.5 View Q233374 KB233374 October 21, 2013
260320 BUG: DTS Transfer May Fail with "Incorrect syntax..." Error Message Q260320 KB260320 October 20, 2013
223031 BUG: Optimizer Picks Table Scan for IF EXISTS Subquery with BETWEEN and Local Variable Q223031 KB223031 October 20, 2013
222183 BUG: DTS Import/Export Wizard Does Not Display Scheduling Q222183 KB222183 October 20, 2013
207446 BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns Q207446 KB207446 October 11, 2013
201001 BUG: Table Designer "Table and Index Properties" Button Fails Q201001 KB201001 October 11, 2013
199280 BUG: DTS Query Builder Problem with Inline Comment Q199280 KB199280 October 11, 2013
199240 BUG: DTS Fails When Importing Table with a Timestamp Column Q199240 KB199240 October 11, 2013
199232 BUG: Right Align Numerics Has No Effect on the Grid Result Q199232 KB199232 October 11, 2013
199223 BUG: Immediate Updating Subscriber Builds Trigger Incorrectly Q199223 KB199223 October 11, 2013
199213 BUG: Web Assistant: Can Only Save File with .sql Extension Q199213 KB199213 October 11, 2013
199105 BUG: ROUND Function with NULL Length Returns TDS Error Q199105 KB199105 October 11, 2013
199054 BUG: Double Precision Synonym Mapped to REAL Instead of FLOAT Q199054 KB199054 October 11, 2013
198168 BUG: Problems Might Occur When You Change Account Information for SQL Server Cluster Q198168 KB198168 October 11, 2013
198106 BUG: "Do You Want to Delete This Index" Message When Creating Index Q198106 KB198106 October 11, 2013
198105 BUG: Errors When Creating a View Using the WITH CHECK OPTION in SQL Enterprise Manager Q198105 KB198105 October 11, 2013
198032 BUG: Adding Steps to Database Maintenance Job Results in Error in SQL Enterprise Manager Q198032 KB198032 October 11, 2013
198030 BUG: Query Against Sysprocesses May Fail with Message 1105 Q198030 KB198030 October 11, 2013
197798 BUG: Table Designer Gives an Error with Quotes in a Column Name Q197798 KB197798 October 11, 2013
197797 BUG: Table Designer Error with Single Quote in a Table Name Q197797 KB197797 October 11, 2013
197581 BUG: QA: No Execution Plan for DECLARE CURSOR & SELECT...FOR BROWSE Q197581 KB197581 October 11, 2013
197562 BUG: Heterogeneous Query Showplan May Not Display Site Name Q197562 KB197562 October 11, 2013
197462 BUG: Slow Performance Using Cursor Positioned Update If No PK Q197462 KB197462 October 11, 2013
197390 BUG: SetupAdmin Member Not Allowed to Add Linked Server in SEM Q197390 KB197390 October 11, 2013
197389 BUG: MSG 15417 Trying to Change Compatibility Level of Master DB Q197389 KB197389 October 11, 2013
197352 BUG: Mmc.exe Application Error Closing Script Generation Dialog Box Q197352 KB197352 October 11, 2013
197246 BUG: (local) Disappears When Using DTS Transfer SQL Server Object Q197246 KB197246 October 11, 2013
197043 BUG: BULK INSERT Fails While Inserting into an IMAGE Column Q197043 KB197043 October 11, 2013
196789 BUG: CREATE TABLE in Stored Procedure with the Name "sp_" May Fail Q196789 KB196789 October 11, 2013
281902 BUG: Unattended Client Installation on Windows 9x Computer Incorrectly Requests Deskecli.bat File Q281902 KB281902 September 17, 2011
294160 BUG: Update of Newly Inserted Row Causes DB_E_ERRORSOCCURRED Q294160 KB294160 November 30, 2007
113136 BUG: EXAMPLE8.C in Prog. Ref. Does Not Match Sample Program Q113136 KB113136 November 30, 2007
278667 BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers Q278667 KB278667 November 2, 2007
273833 BUG: Restore of a Large Database on Windows 98 May Fail with 3257 Error Message Q273833 KB273833 November 2, 2007
317821 BUG: Parallel query may stop responding or fail with 8650 error message Q317821 KB317821 July 26, 2007
824421 BUG: You receive an error message that contains a decimal representation of the SQL Server version number Q824421 KB824421 May 16, 2007
290820 BUG: SQL Desktop Edition: Shared memory fails to connect after you install MDAC 2.6 Q290820 KB290820 April 25, 2007
267550 BUG: "Assertion Failed" When You Connect to a SQL Server Through TCP/IP Q267550 KB267550 February 12, 2007
811480 BUG: You Receive Error Message: "There Is Not Enough Space on Drive" When You Extract SQL Server 2000 Service Pack 1 Q811480 KB811480 January 10, 2007
231403 BUG: BOL incorrectly states that a member of db_owner role can issue SETUSER command Q231403 KB231403 July 31, 2006
323602 BUG: The SQL Server VDI Backup and Restore Operations Are Not Successful and the CoCreateInstance Error Occurs Q323602 KB323602 December 1, 2005
199881 BUG: Cannot Add Tables or See Database Diagrams Q199881 KB199881 August 19, 2005
811476 BUG: Rollback fails with errors 3314 and 9001 if you enlist multiple connections in the same transaction Q811476 KB811476 April 25, 2005
198141 BUG: DTS: Two or More Columns with the Same Name Cannot Transfer Q198141 KB198141 March 14, 2005
197392 BUG: Error 16929, "Cursor Is Read Only" for Cursor w/OpenQuery() Q197392 KB197392 March 14, 2005
196935 BUG: Cannot Convert Between TEXT and NTEXT by Using UPDATETEXT Q196935 KB196935 March 14, 2005
196903 BUG: Full Text Search Fails with Unique Index on Multiple Columns Q196903 KB196903 March 14, 2005
164171 BUG: dbprocerrhandle Does Not Get Fired For Error 10029 Q164171 KB164171 February 22, 2005
115333 BUG: Recreating a Table Causes sysdepends to Become Invalid Q115333 KB115333 February 22, 2005
173848 BUG: Sp_OA Procedures May Produce "Bad Variable Type" or "Type Mismatch" Error Q173848 KB173848 February 14, 2005
89938 BUG: ISQL Problems with PRINT in Stored Procedures Q89938 KB89938 February 14, 2005
242454 BUG: NULLIF or COALESCE with Multiple Expression Parameter Generates Access Violation Q242454 KB242454 July 15, 2004
272145 BUG: SQL-DMO Treats Shutdown Message from SQL Server as Error Condition After Shutdown Method Runs Q272145 KB272145 July 13, 2004
305387 BUG: UpdateBatch Generates SQL Statement That Cannot Reuse SQL Server Query Plans Q305387 KB305387 June 28, 2004
230236 BUG: Scm.exe command line arguments not documented in SQL 7.0 Books Online Q230236 KB230236 June 28, 2004
317089 BUG: Assertion Occurs When You Try to Run a Query That Uses a Parallel Plan Q317089 KB317089 June 25, 2004
304091 BUG: Replication Transactional Pull Subscriptions Fail with "Error 14262:The specified @job_id could not be found" Error Message Q304091 KB304091 June 25, 2004
295445 BUG: Deadlock Between Merge Replication and Article Updates Q295445 KB295445 June 25, 2004
277882 BUG: Cannot Use Cut, Copy, and Paste to Transfer Uniqueidentifier Column Values Q277882 KB277882 June 25, 2004
330088 BUG: SQLServer:Databases Performance Counters Limited to First 99 Databases in Windows System Monitor Q330088 KB330088 April 6, 2004
247750 BUG: Table Names Enclosed in Double Quotes When Transferred from SQL Server to Oracle Q247750 KB247750 February 24, 2004
231988 BUG: 7.0 Upgrade Loops When 6.5 Parameters Are Reversed Q231988 KB231988 February 24, 2004
201021 BUG: DOC: DB_OWNER Roles Cannot Administer All Jobs Q201021 KB201021 February 24, 2004
196918 BUG: Comments in Views Removed When Using View Designer Q196918 KB196918 February 23, 2004
196916 BUG: Statistics Are Printed Twice with Statistics Time On Q196916 KB196916 February 23, 2004
834670 BUG: Subscriptions are incorrectly marked as inactive even if the subscriptions are synchronized within the maximum transaction retention period in SQL Server 7.0 Q834670 KB834670 February 13, 2004
247070 BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout Q247070 KB247070 December 5, 2003
240394 BUG: Using ISequentialStream to Access Binary Data May Hang an OLE DB Consumer Application Q240394 KB240394 December 5, 2003
239725 BUG: SQL Server Error "Specified Column Precision 38 Is Greater Than the Maximum Precision of 28. (2750)" When Running Parameterized Query Q239725 KB239725 December 5, 2003
313408 BUG: The Xp_logevent Stored Procedure Truncates Messages to 256 Characters Q313408 KB313408 December 3, 2003
298758 BUG: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities Q298758 KB298758 November 21, 2003
201041 BUG: Stored Procedure Remains After Deleting Web Wizard File Q201041 KB201041 November 21, 2003
279514 BUG: ExecuteWithResultsAndMessages2 Does Not Return Results Q279514 KB279514 November 17, 2003
254759 BUG: ListAvailableServers Method of the SQLDMO.Application Object Causes Error 0x800A000E Q254759 KB254759 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
295739 BUG: DTS Designer May Stop Responding When You Use Microsoft Jet 4.0 OLE DB Provider Q295739 KB295739 November 14, 2003
264901 BUG: Error 16917 When CURSOR_CLOSE_ON_COMMIT Is Set ON Q264901 KB264901 November 14, 2003
230393 BUG: SNMP Agent Message Causes Event ID 322 Q230393 KB230393 November 14, 2003
216848 BUG: MDAC: SQL Server Driver May Return Error "Login Failed" Q216848 KB216848 November 14, 2003
304310 BUG: SQLOLEDB Provider Ignores or Removes Trailing Spaces from Password on the Connection Open Method Q304310 KB304310 November 5, 2003
170652 BUG: Login/Logout Causes 'Max User Connections Connected' Error Q170652 KB170652 November 5, 2003
295533 BUG: Opening an Existing DTS Package with OLAP Tasks Causes Error After Analysis Manager Is Installed Q295533 KB295533 November 3, 2003
230406 BUG: DTS: Preview Shows Column Headers as Data When Invoked Multiple Times Q230406 KB230406 November 3, 2003
221480 BUG: DTS: Default Scheduling Information Displayed Q221480 KB221480 November 3, 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
293177 BUG: Hypothetical Clustered Index From Index Tuning Wizard May Cause Recompile Loop Q293177 KB293177 October 31, 2003
275255 BUG: Incorrect Column Mapping: Destination Shows TIMESTAMP From Nullable BINARY Source Q275255 KB275255 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
238673 BUG: Package Execution Can Fail if Target Table Has an Identity Q238673 KB238673 October 31, 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
251119 BUG: Last Row of Fixed Length File Fails to Import When File Does Not End with Row Delimiter Q251119 KB251119 October 30, 2003
300192 BUG: DTS Import/Export Wizard or TransferObjectsTask Fails to Maintain Filegroup Settings for Transferred Objects Q300192 KB300192 October 29, 2003
262340 BUG: LIKE with ESCAPE May Result in Different Query Access Plan Q262340 KB262340 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
239092 BUG: BOL Incorrectly States That SQL Server Doesn't Support TOP Queries Q239092 KB239092 October 28, 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
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
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
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
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
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
262258 BUG: Alert May Fail to Send E-mail Notification with xp_logevent or RAISERROR Q262258 KB262258 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
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
247879 BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation Q247879 KB247879 October 17, 2003
245556 BUG: Running SQLDIAG.EXE Produces an Internal Error in the Application Event Log - EventID 998 Q245556 KB245556 October 17, 2003
243754 BUG: Other Users Can See Your Registered SQL Servers in SQL Enterprise Manager Q243754 KB243754 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
231889 BUG: DOCERR: BOL States T-SQL Outer Joins in FROM Clause Support to be Dropped Q231889 KB231889 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
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
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
307930 BUG: Distribution Agent Parameters Listed After -QuotedIdentifier Are Ignored Q307930 KB307930 October 16, 2003
306608 BUG: Distribution Agent May Fail with Incorrect Syntax when Table Name Contains Hyphens Q306608 KB306608 October 16, 2003
295949 BUG: Source File with Several ESQLC Statements May Cause Access Violation in the Precompiler Q295949 KB295949 October 16, 2003
289287 BUG: BOL Incorrectly States the Precedence of Bitwise Operators Q289287 KB289287 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
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
279857 BUG: Error 3910, "Transaction Context in Use by Another Session" Q279857 KB279857 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
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
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
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
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
201909 BUG: Locking Behavior in Transactions Is Incorrect Q201909 KB201909 October 16, 2003
258234 BUG: Query Analyzer May Not Display All Results with Some Error Sequences Q258234 KB258234 October 9, 2003
263695 BUG: UPDATE Statement with SELECT DISTINCT Subquery with Parallelism Enabled May Cause Access Violation Q263695 KB263695 October 3, 2003
304365 BUG: Slow Performance with SQLOLEDB Inserting BLOB Data into SQL Server Using Stored Procedure Q304365 KB304365 September 17, 2003
329906 BUG: Parallel Query Takes Longer to Execute on Multiple Processors Than on Single Processor Q329906 KB329906 May 22, 2003
203195 BUG: Wildcard (%) Is Not Recognized in the CONTAINS Clause for a Full-Text Search Q203195 KB203195 May 22, 2003
235566 BUG: Unexpected Cursor Behavior with Set NoCount Statement and SQLOLEDB Q235566 KB235566 May 8, 2003
292808 BUG: Backup Filegroup Error Message 3029 Subject to Logical Recovery after Creating a Clustered Index on Two or More Filegroups Q292808 KB292808 October 16, 2002
278448 BUG: sp_OASetProperty Truncates Varchar Types to 255 Characters Q278448 KB278448 October 16, 2002
268520 BUG: Out of Memory Error Message Occurs When You Query an ORACLE Linked Server that has a Numeric Column Q268520 KB268520 October 16, 2002
255041 BUG: DTS Designer Does Not Show Columns in Build Query if Database Name is Non ANSI Q255041 KB255041 October 16, 2002
250623 BUG: Distribution Agent Fails with "Column name or number of supplied values does not match table definition" Error Q250623 KB250623 October 16, 2002
242500 BUG: Sqlmaint Does Not Report Error on BACKUP LOG When Truncate Log on Checkpoint is Set Q242500 KB242500 October 16, 2002
234521 BUG: Inserting Data into Temporary Table's Identity Column in Stored Procedure Fails Q234521 KB234521 October 16, 2002
230405 BUG: DTS Stops Responding with Multiple Blank Column Headers in Text Source File Q230405 KB230405 October 16, 2002
201044 BUG: Error 208: Create Trigger Statement Fails in SQL Enterprise Manager Q201044 KB201044 October 16, 2002
257658 BUG: BatchCollisionCount is Incorrect After You Perform a BatchUpdate to SQL Server 7.0 Database Q257658 KB257658 October 15, 2002
199216 BUG: Cannot Restore Database When Model Database Is in Use Q199216 KB199216 October 15, 2002
196908 BUG: BCP: CONTROL+C or CONTROL+Break May Not Stop BCP Out Q196908 KB196908 October 15, 2002
196770 BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602 Q196770 KB196770 October 15, 2002
196769 BUG: Error 7124 Documents Incorrect Size for ntext Data Columns Q196769 KB196769 October 15, 2002
196768 BUG: Table Designer Tool Does Not Allow Apostrophe in Column Name Q196768 KB196768 October 15, 2002
268600 BUG: When You Open Table with a Large Number of Columns SEM Appears to Hang or Reports Unknown Error Q268600 KB268600 September 4, 2002
239753 BUG: 1205 - Deadlock Situation Not Detected by SQL Server Q239753 KB239753 September 4, 2002
241897 BUG: SQLOLEDB IRowset->GetNextRows() Causes Access Violation after Fetching 131,000 Rows Q241897 KB241897 August 23, 2001
293786 BUG: GPF in Data Access Objects After You Install SQL Server Client Q293786 KB293786 May 3, 2001

SQL Server 7.0 articles, fixes and updates - letter B