kbupdate.info ›
Daily Updated!
SQL Server 7.0 articles, fixes and updates - letter P
Daily Updated!
chronological list: 2021 | 2020 | 2019 | 2018 | 2017 | 2015 | 2014 | 2013/12 11 10 9 8 7 3 ... 1999
alphabetical list: A B C D E F G H I K M N O P R S T U V W Y
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