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 P that have been released. The list is daily updated.

200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries Q200043 KB200043 January 25, 2021
830232 PSSDIAG data collection utility Q830232 KB830232 March 9, 2020
253500 PRB: "Client Unable to Establish Connection" Error Message When Connecting from ASP to SQL Server Q253500 KB253500 April 20, 2018
307002 PRB: ASP/ODBC/SQL Server Error 0x80040E4D "Login Failed for User '(Null)'" Q307002 KB307002 April 19, 2018
236605 PRB: DTS Wizard may not detect Excel column type for mixed data in SQL Server Q236605 KB236605 April 13, 2018
308266 PRB: Non-convergence when SQL Server processes child and parent generations in separate generation batches Q308266 KB308266 July 7, 2017
328306 Potential causes of the "SQL Server does not exist or access denied" error message Q328306 KB328306 April 27, 2017
281649 PRB: SQL Server Debugging with Visual Studio Service Pack 5 Requires a Non-System Account Q281649 KB281649 January 16, 2015
271727 PRB: Immediate Updating Subscriber Option Involving Different SQL Server Versions Q271727 KB271727 January 16, 2015
271601 PRB: REPLACE Sets First String to NULL if Third String is NULL Q271601 KB271601 January 16, 2015
203787 PRB: Error Msg 1007: The Number Is Out of Range / Err 8115: Arithmetic Overflow Q203787 KB203787 January 16, 2015
168257 PRB: Stored Procedure Scripts Not Generated in Dependency Order Q168257 KB168257 January 16, 2015
198428 PRB: ODBC Prepared Statement Errors with Temporary Tables Q198428 KB198428 January 11, 2015
256174 PRB: One or More Properties Cannot be Set on Query for OLE DB Provider SQLOLEDB Q256174 KB256174 January 10, 2015
196292 PRB: Installing DA SDK Causes SQL Distributed Queries to Fail Q196292 KB196292 January 6, 2015
237604 PRB: SQL Server Agent does not start and displays error 18456 Q237604 KB237604 June 22, 2014
814398 PRB: Error 7399 When You Run a Linked Server Query That Uses the OLE DB Provider for Microsoft Jet Q814398 KB814398 June 20, 2014
822034 PRB: "SQLDMO Has Not Been Registered" Error Message If You Remove SQL Server Desktop Engine Q822034 KB822034 February 27, 2014
323022 PRB: The Transaction Log File Shrinks Unexpectedly After Each Transaction Log Backup Q323022 KB323022 November 2, 2013
320656 PRB: A Distributed Query May Fail If You Use the Xp_sendmail Stored Procedure with the @query Parameter on a Linked Server Q320656 KB320656 November 2, 2013
315007 PRB: Error Message: "The snap in that has been selected has failed to initialize" Occurs When You Open SQL Enterprise Manager Q315007 KB315007 November 2, 2013
308270 PRB: Server Level Post Handlers Cannot Remove Themselves with srv_post_handle Q308270 KB308270 November 2, 2013
306529 PRB: Migrating a Stand-alone SQL Server to a Clustered SQL Server in an Active Directory Environment Q306529 KB306529 November 2, 2013
306223 PRB: DBCC DBREINDEX May Set the STATBLOB Column that Corresponds to All Column Statistics of the Sysindexes Table to NULL Q306223 KB306223 November 2, 2013
298967 PRB: Unable to Load Transaction Log Backup on Secondary Server While Using Log Shipping Tool Q298967 KB298967 November 2, 2013
298801 PRB: Transaction Log Restores Stop Responding with "Minimum Query Memory Is Not Available" Message in Error Log Q298801 KB298801 November 2, 2013
295724 PRB: Nonlogged BCP Operation Can Be Logged on Tables with Indexes and Existing Data Q295724 KB295724 November 2, 2013
295670 PRB: SQL Server Agent Reports Event ID:106 If You Install SQL Server on a Windows 2000 Domain Controller Q295670 KB295670 November 2, 2013
289497 PRB: DBCS data problems occur after an upgrade to SQL Server 7.0 Q289497 KB289497 November 2, 2013
288319 PRB: Suboptimal Query Plan Executed When Same Join Predicate Appears on Both Sides of an OR Clause Q288319 KB288319 November 2, 2013
282976 PRB: SQL Server 7.0 Service Pack 2 Installation Fails with -115 Error Q282976 KB282976 November 2, 2013
281912 PRB: sp_detach_db Message Incorrectly Implies That it Drops Database Q281912 KB281912 November 2, 2013
281665 PRB: Scheduled Tape Backup Waits Indefinitely if No Tape is in Drive Q281665 KB281665 November 2, 2013
281342 PRB: Inefficient Plan for BIT in Join Condition in WHERE Clause Q281342 KB281342 November 2, 2013
281339 PRB: Xp_sendmail Truncates Column Output to 256 Characters Q281339 KB281339 November 2, 2013
278656 PRB: Like Predicate Optimization is Limited to 7 Character Positions Q278656 KB278656 November 2, 2013
272115 PRB: Stored Procedure Still Marked for Replication May Cause Stack Dumps Q272115 KB272115 November 2, 2013
271525 PRB: Misleading Error Message with an IN Clause On Text Data Type Q271525 KB271525 November 2, 2013
271171 PRB: Backup Wizard May Not Display the "Verify Backup" Option Correctly Q271171 KB271171 November 2, 2013
270839 PRB: SQL Server 7.0 Setup Fails on MSCS with Cannot Grant Logon as a Service Right Q270839 KB270839 November 2, 2013
270664 PRB: Database Marked Read Only Does Not Allow You to Change User Permissions Simultaneously Q270664 KB270664 November 2, 2013
269694 PRB: Keyset Cursor to Access a Remoted Table Through a Linked Server May Cause Error 16953 Q269694 KB269694 November 2, 2013
269418 PRB: SQL Server 7.0 MSDTC Administrative Console Unavailable on Windows 2000 from Program Menu Q269418 KB269418 November 2, 2013
268858 PRB: SQL Server 7.0 Enterprise Manager Does not Provide Object and User Permissions Dialog Boxes Like SQL Server 6.5 Q268858 KB268858 November 2, 2013
268594 PRB: Inconsistency in Behavior Between CREATE STATISTICS and UPDATE STATISTICS Q268594 KB268594 November 2, 2013
268243 PRB: Column SS_DATA_TYPE From sp_columns is The Same As syscolumns.type And Not syscolumns.xtype Q268243 KB268243 November 2, 2013
264160 PRB: Column Level CHECK Constraint Required Before Implementing a Partitioned View Q264160 KB264160 November 2, 2013
263864 PRB: SQL Server 7.0 Failover Cluster Wizard Fails to Remove Resources After Removing the Virtual Server Q263864 KB263864 November 2, 2013
260388 PRB: SQL Server 7.0 Setup Fails at Configuration Phase Because of Insufficient Permissions Q260388 KB260388 November 2, 2013
254341 PRB: Legacy DB-Library Application May Fail to Connect After You Install SQL Server Client Tools Q254341 KB254341 November 2, 2013
251277 PRB: Poor Cardinality Estimation for Inequality Expressions in Joins Q251277 KB251277 November 2, 2013
250910 PRB: Error Does Not Occur When Setting IDENTITY_INSERT ON For More Than One Table Q250910 KB250910 November 2, 2013
249802 PRB: Error Message Occurs When You Install SQL Server 7.0 Service Packs in a Cluster Environment Q249802 KB249802 November 2, 2013
249671 Passwords unusable after SQL Server 6.5 to 7.0 upgrade with different sort order Q249671 KB249671 November 2, 2013
248407 PRB: Utilizing xp_cmdshell with Non-Sysadmin Accounts in a Clustered Environment Q248407 KB248407 November 2, 2013
247110 PRB: Replication Must be Removed Before Applying Service Pack Q247110 KB247110 November 2, 2013
241113 PRB: A Full-Text Search Query on TEXT or NTEXT Column Does Not Return Valid Results Q241113 KB241113 November 2, 2013
240193 PRB: Upgrading Replication Settings May Fail When Inserting Rows into Msdistribution_agents Q240193 KB240193 November 2, 2013
237487 PRB: Service Pack Setup Requires Default Named-Pipe Name Q237487 KB237487 November 2, 2013
236885 PRB: Using SQL 6.5 and 7.0 Enterprise Manager to Read from a Remote Server Q236885 KB236885 November 2, 2013
236825 PRB: #deleted seen when SQL Server 7.0 tables or SQL Server 6.5 tables that are linked to Access 97 or Access 2000 are opened Q236825 KB236825 November 2, 2013
234060 PRB: Cannot Install SQL Server 7.0 Enterprise Edition After Upgrade to Windows NT 4.0 Enterprise Edition Q234060 KB234060 November 2, 2013
222106 PRB: Cannot install Enterprise Edition on Windows NT Server Q222106 KB222106 November 2, 2013
200921 PRB: OpenQuery with ATL Provider Fails When Set Up with SQL Enterprise Manager Q200921 KB200921 November 2, 2013
199230 PRB: SQLServerAgent Service Does Not Start After Unclustering Q199230 KB199230 November 1, 2013
153676 PRB: SQLMail Always Saves Sent Mail with Exchange Client Q153676 KB153676 November 1, 2013
141666 PRB: GO as 1st Word on Line Treated as Batch Terminator Q141666 KB141666 November 1, 2013
42624 PRB: Error Creating Stored Procedure Q42624 KB42624 November 1, 2013
818671 PRB: Access Violation Exception Occurs When Optimized Query Plan Uses Hash Match Team Operator Q818671 KB818671 October 26, 2013
815063 PRB: Error 1927: "There Are Already Statistics on Table <Table_Name> Named <Statistics_Name>" Q815063 KB815063 October 26, 2013
814578 PRB: OLE Automation Error Occurs When SQL Server Runs a Stored Procedure Q814578 KB814578 October 26, 2013
811906 PRB: The "Use Encryption for Data" Property Is Not Recognized When You Run a DTS Package on a Computer with MDAC 2.5 or Earlier Q811906 KB811906 October 26, 2013
327424 PRB: An Access Violation Occurs If the Sqlsort.dll Version Is Not Compatible with the SQL Server Version Q327424 KB327424 October 26, 2013
315005 PRB: SQL Server Agent Job Fails with Error Message "...Driver's SQLSetConnectAttr failed..." Q315005 KB315005 October 26, 2013
310631 PRB: Error 2757 If Table Has More Than 254 Columns in a Publication Q310631 KB310631 October 26, 2013
291961 PRB: Debugging Stored Procedure Fails with "Cannot load the DLL mssdi98.dll, or one of the DLLs it references" Error Message Q291961 KB291961 October 26, 2013
277549 PRB: Unable to Build Full-Text Catalog After You Modify MSSQLServer Logon Account Through Control Panel Q277549 KB277549 October 26, 2013
246694 PRB: Setup on Windows 2000 Fails Through Terminal Client Q246694 KB246694 October 26, 2013
246328 PRB: SQL performance counters may be missing after MDAC installation on a cluster Q246328 KB246328 October 26, 2013
240688 PRB: Replication Subscribers Unable to Synchronize with Pull Subscription Q240688 KB240688 October 26, 2013
233338 PRB: Repl Logreader Fails on Remote Distributor after Cluster Failover Q233338 KB233338 October 26, 2013
218739 PRB: BACKUP with NO_TRUNCATE Not Possible with Missing Primary Data File Q218739 KB218739 October 26, 2013
163446 PRB: Guarantee @@IDENTITY Value on a Per Table Basis Q163446 KB163446 October 26, 2013
152134 PRB: XP_CMDSHELL Does Not Work with XCOPY Q152134 KB152134 October 26, 2013
80629 PRB: Transaction Log Partially Truncated Q80629 KB80629 October 26, 2013
284942 PRB: ADO Does Not Support Default Values in Stored Procedures Q284942 KB284942 October 23, 2013
248380 PRB: SQL 7.0 Failover Wizard Error when Updating Binaries on Cluster Q248380 KB248380 October 22, 2013
281340 PRB: File Compare Utility Fails to Run from Xp_cmdshell Q281340 KB281340 October 21, 2013
271247 PRB: DTS Wizard "Fixed Field Column Positions" Wraps Text Q271247 KB271247 October 21, 2013
238332 PRB: Differences Between DMO 7.0 and DMO 6.5 With ExecuteWithResults Q238332 KB238332 October 21, 2013
237412 PRB: Quick Links from SQL Server 7.0 Support Highlights Page Do Not Contain Information on SQL Server Q237412 KB237412 October 21, 2013
235366 PRB: Profiler Errors If Connected Using SQL Authentication via TCP/IP Socket Q235366 KB235366 October 21, 2013
232984 PRB: Unable to See VIEWs Using Query Builder in DTS Import/Export Wizard Q232984 KB232984 October 21, 2013
252434 PRB: Table Designer Automatically Clears Results Pane When Idle Q252434 KB252434 October 20, 2013
249842 PRB: DTS Package Creation May Fail with "Could not create Component Categories Manager" Q249842 KB249842 October 20, 2013
223786 PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly Q223786 KB223786 October 20, 2013
221148 PRB: SQL 7.0 Upgrade Fails w/ 'Could not find stored procedure' Msg Q221148 KB221148 October 20, 2013
214601 PRB: ANSI_NULLS OFF Behavior in SQL Server 6.x and 7.0 Q214601 KB214601 October 14, 2013
205557 PRB: SQL Server Tape Backup is Unsupported on Windows 95/98 Computers Q205557 KB205557 October 11, 2013
201868 PRB: View Designer Errors if Query Cannot Display Graphically Q201868 KB201868 October 11, 2013
199217 PRB: Uninstall Does Not Remove All Replication Files Q199217 KB199217 October 11, 2013
198064 PRB: Filter on Saved Profiler Trace Replaces Previous File Q198064 KB198064 October 11, 2013
197799 PRB: Cannot Create FK Relationship Using Design Table Interface Q197799 KB197799 October 11, 2013
152415 PRB: sp_processmail Gets Ambiguous Recipient Error Q152415 KB152415 September 30, 2013
271128 PRB: Implicit Connections Created by the SQL Server OLE DB Provider (SQLOLEDB) Are Not Pooled Q271128 KB271128 October 26, 2012
245768 PRB: Case-Sensitive Unicode Collating Sequence and Windows NT Logins Q245768 KB245768 February 12, 2012
281517 PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error Q281517 KB281517 February 5, 2011
298725 PRB: Scheduled DTS Package Fails With "Permission Denied: CreateObject" Q298725 KB298725 November 30, 2007
295743 PRB: SQL Server Local Temp Tables Aren't Created When Parameterized ADO Query Is Used Q295743 KB295743 November 30, 2007
261225 PRB: TSQL PRINT Statement Breaks Lines Longer Than 255 Characters When You Use OSQL to Create a Flat File Q261225 KB261225 August 8, 2007
811030 PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication Q811030 KB811030 May 30, 2007
811034 PRB: Inconsistent Error Handling Behavior Occurs with @@ERROR in SQL Server Q811034 KB811034 May 10, 2007
285077 PRB: SQL Server 7.0 Setup Fails When ODBC Components on Your System Need Updating Q285077 KB285077 April 25, 2007
289573 PRB: Configuring DSNs with SQL Server Net-Libraries Q289573 KB289573 March 27, 2007
280084 PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL Q280084 KB280084 February 23, 2007
257767 PRB: Cannot Open Pubs Table Image Data Through Microsoft Access Link Q257767 KB257767 February 12, 2007
241643 PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User Q241643 KB241643 November 27, 2006
814401 PRB: Error message: Cannot generate SSPI context Q814401 KB814401 July 26, 2006
288910 PRB: "Invalid class string" error message when opening DTS package Q288910 KB288910 July 5, 2006
136869 PRB: SQLMail Functions Hang on MAPI Error Q136869 KB136869 June 30, 2006
238232 PRB: MSDE unattended installation needs full path name of the .iss file Q238232 KB238232 May 10, 2006
299410 Performing a SQL distributed query by using ADSI Q299410 KB299410 April 11, 2006
68941 Procedure for testing named pipes Q68941 KB68941 January 10, 2006
268505 PRB: Deletion of rows with the same values behaves differently in SEM and Query Analyzer Q268505 KB268505 December 29, 2005
271889 PRB: Error message: "Exception Access Violation 2147221499.Need to run the object to perform this operation" occurs when you run a DTS package in Microsoft Visual Basic code Q271889 KB271889 December 28, 2005
262973 "Possible thread starvation detected" message may be reported in the SQL Server error log when all worker threads for a particular UMS scheduler are in a wait state in SQL Server Q262973 KB262973 December 13, 2005
305635 PRB: A Timeout Occurs When a Database Is Automatically Expanding Q305635 KB305635 December 2, 2005
302676 PRB: SQL Enterprise Manager Does Not Retain All Custom View Settings Q302676 KB302676 September 26, 2005
247221 PRB: Unattended Install of SQL Server 7.0 or MSDE 1.0 Stops Responding Q247221 KB247221 June 23, 2005
261297 PRB: Error When You Use adLockBatchOptimistic with OLE DB Provider Q261297 KB261297 April 1, 2005
154000 PRB: STR() Inconsistent with Exact Numeric Data Q154000 KB154000 March 16, 2005
196657 PRB: "Event ID (1001) in Source (SQLCTR70) Could Not Be Found" Q196657 KB196657 March 14, 2005
196293 PRB: Distributed Query With Jet Changes Native Column Order Q196293 KB196293 March 14, 2005
151602 PRB: How to Use sp_displayoaerrorinfo in the sp_OA Samples Q151602 KB151602 March 14, 2005
135861 PRB: Datetime Rounding Up Behavior Undesirable Q135861 KB135861 March 14, 2005
47603 PRB: Dealing with locks and timeouts in DB-Library Q47603 KB47603 March 14, 2005
47180 PRB: CONVERTing Character to an Integer Causes Syntax Error Q47180 KB47180 March 14, 2005
47048 PRB: DATEADD Doesn't Work When Using a Variable as a Date Q47048 KB47048 March 14, 2005
187942 PRB: Catastrophic Error Occurs Referencing ADO Recordset Q187942 KB187942 March 2, 2005
46438 PRB: Improving Response Time When Communicating over Network Q46438 KB46438 March 2, 2005
164291 PRB: Proper Handling of the Escape Sequence \<cr><lf> Q164291 KB164291 March 1, 2005
70867 PRB: Maximum TEXTSIZE in OSQL and ISQL Q70867 KB70867 February 14, 2005
70673 PRB: Process All Results to Find Number of Rows Affected Q70673 KB70673 February 14, 2005
70267 PRB: Using COMPUTE with Converted Columns Q70267 KB70267 February 14, 2005
67303 PRB: Rolling Back Individual Rows from an INSERT Trigger Q67303 KB67303 February 14, 2005
66057 PRB: Running Out of Log Space When Running Large Bulk Loads Q66057 KB66057 February 14, 2005
64238 PRB: IF UPDATE Trigger with No Rows Changed Q64238 KB64238 February 14, 2005
59461 PRB: Zero Rows Returned from SQL SELECT Statement Q59461 KB59461 February 14, 2005
302850 PRB: Upgrade to SQL Server 7.0 or SQL Server 2000 fails during "Import and Export" step Q302850 KB302850 November 17, 2004
286082 PRB: The Attach Database option and the Detach Database option are not available when you try to attach or detach a database on SQL Server 7.0 by using Enterprise Manager that was installed from SQL Server 2000 Q286082 KB286082 November 17, 2004
291366 PRB: Upgrading SQL Server 6.5 Databases with Integrated Logins to SQL Server 7.0 or SQL Server 2000 Q291366 KB291366 November 16, 2004
324302 PRB: You cannot pass the LCID to the MSIXDS Provider to specify the connection to the Indexing Service Q324302 KB324302 October 29, 2004
326352 PRB: You receive error 3724 when you drop a non-replicated object Q326352 KB326352 October 11, 2004
298794 PRB: Population or Query of a Full Text Catalog May Stop Responding Q298794 KB298794 July 16, 2004
266337 PRB: Some SQL Server 7.0 Service Pack 2 Updates Must be Added Manually Q266337 KB266337 July 16, 2004
310542 PRB: Upgrade Wizard Fails with "Logins ID unable to open registry on the target computer." Error Message Q310542 KB310542 July 15, 2004
283845 PRB: RDO Rowcount Returns Zero For Large SQL Server Recordsets Q283845 KB283845 July 15, 2004
296393 PRB: Attributes Are Not Generated for Fields That Contain a NULL Value When ADO Recordset Is Persisted in XML Q296393 KB296393 July 14, 2004
251238 PRB: Distributed Queries Return Error 7356 with MSDAORA Q251238 KB251238 July 14, 2004
306216 PRB: Error "Unable to Load Communication Module" in ASP/ADO/SQL Server Q306216 KB306216 July 13, 2004
306385 PRB: CursorType Returns adOpenStatic When You Request adOpenDynamic from a Server-Side Recordset Q306385 KB306385 June 30, 2004
264123 PRB: SQL Server 7.0 Service Pack Installation Fails with an Error Message When a Script File Is Run Q264123 KB264123 June 29, 2004
280134 PRB: Error When You Create SQL Server TEMP Tables Using Remote Data Objects (RDO) Q280134 KB280134 June 28, 2004
259571 PRB: DTS Connection Password Is Write Only Q259571 KB259571 June 24, 2004
220915 PRB: SQL Distributed Query with Oracle requires Oracle client and networking components Q220915 KB220915 May 13, 2004
271223 PRB: sp_attach_single_file_db Does Not Work for Databases with Multiple Log Files Q271223 KB271223 February 26, 2004
285106 PRB: SQL Server Enterprise Manager Reports That the Replication Agent Is Suspect Q285106 KB285106 February 25, 2004
163069 PRB: Multiplying Numeric Datatypes May Yield Lower Precision Q163069 KB163069 February 25, 2004
247360 PRB: DTS May Skip More Rows than Specified for Fixed-Length Files Q247360 KB247360 February 24, 2004
238367 PRB: Error Message "Unspecified Error" When Executing a DTS Package Modified Dynamically Q238367 KB238367 February 24, 2004
220163 PRB: DTS Does Not Copy Identity, Indexes, Primary Key or Other Constraints Q220163 KB220163 February 24, 2004
200797 PRB: OPTIMIZER LOCK HINTS Error with OpenQuery Q200797 KB200797 February 24, 2004
236828 PRB: E_UNEXPECTED Returned from IRowsetChange::DeleteRows Without Releasing ISequentialStream Pointer Q236828 KB236828 January 6, 2004
286370 PRB: OpenQuery Function Fails with Queries That Exceed 8000 Characters Q286370 KB286370 December 5, 2003
281268 PRB: Performance Issues with SQL Server OLE DB Provider When Working with BLOB Data Types Q281268 KB281268 December 5, 2003
272358 PRB: SQLOLEDB Allows Only One Connection in Scope of Transaction Q272358 KB272358 December 5, 2003
246265 PRB: Slow Inserts Using SQLOLEDB Provider When No Index on SQL7.0 Table Q246265 KB246265 December 5, 2003
241147 PRB: SQL Server ODBC Driver Returns Output Parameter as a Result Set in a Plain SQL Statement Q241147 KB241147 December 5, 2003
240340 PRB: SQL Distributed Query with Oracle Causes "Could not open table" Error Q240340 KB240340 December 5, 2003
222104 PRB: "Optional feature not implemented" or "#name" in SQL Server 7.0 Q222104 KB222104 December 5, 2003
221552 PRB: SQL Distributed Query with Oracle NUMERIC Column Gives Error Q221552 KB221552 December 5, 2003
296537 PRB: Sharing Violation Occurs with Operating System Job That Runs Batch File That Echoes Text to Ouput File Q296537 KB296537 December 3, 2003
293873 PRB: ADO Recordset AddNew and Update Methods Ignore ANSI PADDING OFF Setting Q293873 KB293873 December 3, 2003
253240 PRB: Errors Not Returned When Stored Procedure Statement Fails Q253240 KB253240 December 3, 2003
193339 PRB: Unexpected Errors Using OLE DB Provider for SQL Server Q193339 KB193339 December 3, 2003
63212 PRB: Assignment of NULL Value to Local Variable in SQL Q63212 KB63212 December 3, 2003
40913 PRB: BCP Ignores Rules and Triggers Q40913 KB40913 December 3, 2003
296711 PRB: "Unspecified error" Error 7399 Using OPENROWSET Against Jet Database Q296711 KB296711 December 1, 2003
203312 PRB: Cannot Register Server if Password Exceeds 60 Characters Q203312 KB203312 November 21, 2003
200796 PRB: SQL Enterprise Manager Requires Uppercase for Linked Server Name Q200796 KB200796 November 21, 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
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
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
259372 PRB: Some Arguments in sp_sproc_columns and sp_columns Support Wildcard Pattern Matching Q259372 KB259372 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
141183 PRB: Log Segment Moved to Device Incorrectly if Tempdb Expanded Q141183 KB141183 November 14, 2003
254304 PRB: ADO Errors Collection Does Not Contain User-Defined Error Messages Q254304 KB254304 November 7, 2003
253673 PRB: Recordset Based on SQL Server View Updates Base Tables Q253673 KB253673 November 7, 2003
241818 PRB: Calculated Field Contents Cannot be Modified by ADO Q241818 KB241818 November 5, 2003
252405 PRB: ADO EOF Returns True on SQL Server 7.0, Returns Time-out Error on SQL Server 6.5 Q252405 KB252405 November 4, 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
235053 PRB: E_FAIL Returned from Prepare() When SQL Statement Contains a Parameter in a Subquery Q235053 KB235053 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
295026 PRB: Errors When You Redistribute SQL Server 2000 DMO Clients in SQL Server 7.0 Environment Q295026 KB295026 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
292588 PRB: Data Transformation Services May Fail to Import DBCS File Using Fixed Field Q292588 KB292588 October 31, 2003
288745 PRB: DBCC CHECKDB Reports Error Message 2501 During Database Activity Q288745 KB288745 October 31, 2003
275680 PRB: Bulk Operations into Tables Result in Rows Not Replicated in Merge Replication Q275680 KB275680 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
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
238678 PRB: RebuildM Cannot Find Original Master Database Files for MSDE Installation Q238678 KB238678 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
327056 PRB: SQL Server Enterprise Manager Inserts Extra Spaces in a View's Column Names Q327056 KB327056 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
308843 PRB: Non-Unique Clustered Index on a Published Table Causes Incorrect Data to Replicate to Subscribers Q308843 KB308843 October 30, 2003
301076 PRB: Unable to Connect to SQL Server Through ODBC When Password Contains a Semi-colon Q301076 KB301076 October 30, 2003
274188 PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete Q274188 KB274188 October 30, 2003
247825 PRB: DTS Copy Table Uses Table Schema of Existing Table Q247825 KB247825 October 30, 2003
255067 PRB: Owner of a Table Cannot Access It Directly If Made Sysadmin After Creation Q255067 KB255067 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
260895 PRB: Error -2147217900 When You Run Distributed Queries in SQL from MTS Q260895 KB260895 October 28, 2003
238146 PRB: Constraint Violation Is Not Detected If Update with the Same Data Q238146 KB238146 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
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
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
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
303445 PRB: ObjectID Filter in SQL Profiler Triggers Only with Specific Events Q303445 KB303445 October 17, 2003
295371 PRB: Filegroup Log Restore May Fail with Error Message 4305 Q295371 KB295371 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
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
264593 PRB: RESTORE WITH STANDBY Does Not Catch Invalid or ReadOnly File Name Until After the Load Q264593 KB264593 October 17, 2003
262951 PRB: System Stored Procedures Return Underlying SQL Code or Unexpected Results Q262951 KB262951 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
254492 PRB: Views Fail to Upgrade Q254492 KB254492 October 17, 2003
248391 PRB: Error 1314 Raised By xp_cmdshell When Executed as Non-SA User Q248391 KB248391 October 17, 2003
244513 PRB: Scheduled SQL Server Backups Display "BackupTapeFile::WriteFileMark: WriteTapemark failure" Error Q244513 KB244513 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
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
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
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
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
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
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
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
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
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
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
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
275583 PRB: SELECT...FOR XML AUTO Results Are Separated into Lines of 2033 Chars with ODBC Q275583 KB275583 October 16, 2003
274747 PRB: Registered Remote SQL Servers May Be Lost from SQL Server 2000 Enterprise Manager Q274747 KB274747 October 16, 2003
268593 PRB: Querying a DATETIME Value Without Quotes Gives Unexpected Results Q268593 KB268593 October 16, 2003
241511 PRB: REPL: Msgs. 20515, 21054, or 20512 with Immediate-Updating Subscribers Q241511 KB241511 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
240882 PRB: Stored Procedure Calls May Result in Attentions Being Seen on SQL Server Q240882 KB240882 September 17, 2003
239759 PRB: Error 5177 May Be Raised When Creating Databases Q239759 KB239759 August 12, 2003
194014 PRB: Data Designer Does Not Support CASE Statements in Views Q194014 KB194014 May 29, 2003
306388 PRB: CursorType Returns adOpenStatic from Server-Side Recordset and Behaves Like a Forward-Only Recordset Q306388 KB306388 May 8, 2003
297502 PRB: Error -2147217887 "No Error Description" When You Send SQL Text Field to Output Stream Q297502 KB297502 May 8, 2003
246636 PRB: Multiple Statements in Stored Procedure Causes Forward-Only/Read-Only Recordsets Q246636 KB246636 May 8, 2003
237398 PRB: SQL Enterprise Manager Returns "Cannot Start Transaction While in Firehose Mode" Error Q237398 KB237398 October 15, 2002
306655 PRB: SQLServerAgent Service May Stop Responding (hang) After You Restart the Computer Q306655 KB306655 July 1, 2002
223295 PRB: PreBuildServer Error During SQL 7.0 Setup Q223295 KB223295 June 11, 2002
258697 PRB: Single SQL Server Connection Can Support Only One Active Firehose Cursor Q258697 KB258697 January 11, 2001
230568 PRB: Restoring Master Database In Enterprise Manager Generates GetOverlappedResult() Error Q230568 KB230568 October 27, 2000
199351 PRB: Renaming a Table in Table Designer Gets No Warning Message Q199351 KB199351 October 27, 2000
256087 PRB: SQL Server 7.0 Backup Stops Responding When You Use an Embedded NCR "ON BOARD" 53C810 SCSI Adapter and a TLZ07 Tape Driver Q256087 KB256087 May 21, 2000
196653 PRB: Temporary Directory Left by InstallShield After Setup Q196653 KB196653 April 21, 1999

SQL Server 7.0 articles, fixes and updates - letter P