SQL Server 7.0 articles, fixes and updates - letter I

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

• 234656 Information about using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 January 25, 2021
• 316626 INF: How SQL Server Compares Strings with Trailing Spaces Q316626 KB316626 August 20, 2020
• 295108 Incomplete transaction may hold large number of locks and cause blocking Q295108 KB295108 April 20, 2018
• 321081 Installation of MSDE creates an 'sa' account with a blank password in Visio Q321081 KB321081 April 19, 2018
• 224453 INF: Understanding and resolving SQL Server blocking problems Q224453 KB224453 October 23, 2017
• 318610 INF: Data Types to Use for Currency Conversion Between European Nations Q318610 KB318610 January 17, 2015
• 317862 INF: Workaround for Changing the File Path of a Report in SQL Web Publishing Q317862 KB317862 January 17, 2015
• 306625 INF: Last Batch Date is Seen as 1900-01-01 00:00:00.000 Q306625 KB306625 January 16, 2015
• 285165 INF: Attaching or Restoring a SQL Server 7.0 Database To SQL Server 2000 Does Not Change the Compatibility Mode Q285165 KB285165 January 16, 2015
• 269487 INF: SQL Server Service Manager Does Not Immediately Indicate Service Status Q269487 KB269487 January 16, 2015
• 263872 INF: Restrictions for Use of the Fraction Field of a TIMESTAMP_STRUCT with SQL Server Q263872 KB263872 January 16, 2015
• 250337 INF: Appending Backups to Tape May be Slower in SQL Server 7.0 than SQL Server 6.5 Q250337 KB250337 January 16, 2015
• 246333 INF: SQL Server Data Transformation Services and the Microsoft Repository Q246333 KB246333 January 16, 2015
• 229888 INF: Subquery Column Can Be Resolved as Outer Query Column Q229888 KB229888 January 16, 2015
• 199834 INF: SQL Server Support for the Euro Currency Symbol Q199834 KB199834 January 16, 2015
• 269074 INF: How to Run a DTS Package as a Scheduled Job Q269074 KB269074 June 22, 2014
• 263556 INF: How to Configure SQL Mail Q263556 KB263556 June 22, 2014
• 256650 INF: How to Shrink the SQL Server 7.0 Transaction Log Q256650 KB256650 June 22, 2014
• 810391 INF: SQL Server 6.5, SQL Server 7.0, and MSDE 1.0 Support on Windows Server 2003 Q810391 KB810391 February 27, 2014
• 318268 INF: SQL Server 7.0 Security Update for Service Pack 3 Q318268 KB318268 November 3, 2013
• 232574 INF: Readme.txt for SQL Server 7.0 Service Pack 1 Q232574 KB232574 November 3, 2013
• 323139 INF: Installing Microsoft SQL Server 7.0 (White Paper) Q323139 KB323139 November 2, 2013
• 323136 INF: Microsoft SQL Server 7.0 Preparedness Review (White Paper) Q323136 KB323136 November 2, 2013
• 323047 INF: Using COM Interfaces to Expand DTS Functionality (White Paper) Q323047 KB323047 November 2, 2013
• 323043 INF: Storage Engine Capacity Planning Tips (White Paper) Q323043 KB323043 November 2, 2013
• 322903 INF: SQL Server 7.0 Storage Engine (White Paper) Q322903 KB322903 November 2, 2013
• 322899 INF: SQL Server 7.0 Security (White Paper) Q322899 KB322899 November 2, 2013
• 322881 INF: SQL Server 7.0 Features Guide (White Paper) Q322881 KB322881 November 2, 2013
• 322873 INF: SAP R/3 Performance Tuning Guide for Microsoft SQL Server 7.0 (White Paper) Q322873 KB322873 November 2, 2013
• 322870 INF: Replication for SQL Server 7.0 (White Paper) Q322870 KB322870 November 2, 2013
• 322714 INF: Migrating Your Microsoft Access Database to SQL Server 7.0 (White Paper) Q322714 KB322714 November 2, 2013
• 322702 INF: Leveraging the Power of DTS (White Paper) Q322702 KB322702 November 2, 2013
• 322698 INF: Index Tuning Wizard for SQL Server 7.0 (White Paper) Q322698 KB322698 November 2, 2013
• 322697 INF: Implementing Large Decision Support Databases on SQL Server 7.0 (White Paper) Q322697 KB322697 November 2, 2013
• 322619 INF: How to Install SQL Server 7.0 Enterprise Edition on Microsoft Cluster Server: Step-by-Step Instructions (White Paper) Q322619 KB322619 November 2, 2013
• 322602 INF: Developing with Microsoft English Query in SQL Server 7.0 (White Paper) Q322602 KB322602 November 2, 2013
• 322109 INF: How to Turn On Tracking of CPU Data for the Sysprocesses CPU Column Q322109 KB322109 November 2, 2013
• 300164 INF: How to Set Up an Identity Column on both the Publisher and the Subscriber with Transactional Replication Q300164 KB300164 November 2, 2013
• 289742 INF: How to Create a SQL Server 7.0 Trace Q289742 KB289742 November 2, 2013
• 289279 INF: How to Monitor SQL Server 7.0 Traces Q289279 KB289279 November 2, 2013
• 289277 INF: How to View SQL Server 7.0 Performance Data Q289277 KB289277 November 2, 2013
• 289276 INF: How to View SQL Server 7.0 Blocking Data Q289276 KB289276 November 2, 2013
• 289274 INF: How to View SQL Server 7.0 Activity Data Q289274 KB289274 November 2, 2013
• 286191 INF: Job to Monitor SQL Server 7.0 Performance and Activity Q286191 KB286191 November 2, 2013
• 273933 INF: How to Use the SQL Server 7.0 TraceReader Objects Q273933 KB273933 November 2, 2013
• 269603 INF: SQL Server 7.0 Setup Fails With Exception Error Q269603 KB269603 November 2, 2013
• 268232 INF: How to Add or Modify SQL Server Licenses Q268232 KB268232 November 2, 2013
• 256973 INF: Error Message: 3132 "The RAID set for database ... missing member number" Q256973 KB256973 November 2, 2013
• 255254 INF: How to Use Check65.exe to Check for Problems Before You Upgrade to SQL Server 7.0 Q255254 KB255254 November 2, 2013
• 252660 INF: SQL Server 7.0 Clients Can Send Encrypted Password Strings Q252660 KB252660 November 2, 2013
• 237674 INF: bcp_exec API Requires User Error Handler When Processing 1000 or More Records Q237674 KB237674 November 2, 2013
• 236563 INF: INSCAT.sql Comment About Updating spt_server_info Can be Ignored Q236563 KB236563 November 2, 2013
• 235893 INF: How To Find a Specific Task/Step Inside a DTS Package Q235893 KB235893 November 2, 2013
• 231735 INF: SQL 7.0 Remote Unattended Install Q231735 KB231735 November 2, 2013
• 46168 INF: Effect of SET ROWCOUNT on SELECT with ORDER BY Q46168 KB46168 November 2, 2013
• 220922 INF: Server Configurations Transferred During 7.0 Upgrade Q220922 KB220922 November 1, 2013
• 214799 INF: SQLProfiler From Command Line Parameters to Temp File Usage Q214799 KB214799 November 1, 2013
• 166270 INF: How to Increase SQL Server Multi-Protocol Connections Q166270 KB166270 November 1, 2013
• 163036 INF: How to Monitor Free Space in a User Database with PerfMon Q163036 KB163036 November 1, 2013
• 156096 INF: Tips for Debugging Stored Procedures from VC++ Q156096 KB156096 November 1, 2013
• 134660 INFO: Retrieving IDENTITY Value for Referential Integrity Q134660 KB134660 November 1, 2013
• 248999 INF: Readme.txt for SQL Server 7.0 SP2 Beta Q248999 KB248999 October 26, 2013
• 237303 INF: How to Upgrade SQL Server 7.0 Evaluation Edition to Retail Version Q237303 KB237303 October 26, 2013
• 230258 INF: DTC Setup Changes Starting with SQL Server 6.5 SP5 and SQL Server 7.0 Q230258 KB230258 October 26, 2013
• 216812 INF: Small Business Server 4.5 SQL Server 7.0 Limitations Q216812 KB216812 October 26, 2013
• 200103 INF: SQL Server 7.0 Startup Parameters Q200103 KB200103 October 26, 2013
• 198473 INF: How to Run NetMon Based on a Specific Error Occurring Q198473 KB198473 October 26, 2013
• 196658 INF: Differential Backup Time Considerations Q196658 KB196658 October 26, 2013
• 170496 INF: Tips for Debugging Stored Procedures from Visual Basic Q170496 KB170496 October 26, 2013
• 110905 INF: Readpipe Return Codes Q110905 KB110905 October 26, 2013
• 275146 INF: Frequently Asked Questions - SQL Server 7.0 - Log Shipping Q275146 KB275146 October 25, 2013
• 243775 INF: How to Use Lookups in Data Transformation Services Q243775 KB243775 October 22, 2013
• 274376 INF: sp_mergecleanupmetadata Optimized for Speed and Less Disk Space Usage Q274376 KB274376 October 21, 2013
• 239794 INF: Changes to SQL-DMO Objects in SQL Server 7.0 Q239794 KB239794 October 21, 2013
• 239583 INF: DTS Transfer SQL Server Objects Does Not Transfer Table with User-Defined Datatype Q239583 KB239583 October 21, 2013
• 238822 INF: How to Rebuild the Repository in SQL Server 7.0 Q238822 KB238822 October 21, 2013
• 238348 INF: SMS 2.0 Evaluation and SQL Server 7.0 Evaluation Q238348 KB238348 October 21, 2013
• 237898 INF: Data Transformation Services and Logged Loads Q237898 KB237898 October 21, 2013
• 232234 INF: How to Differentiate SQL 7.0 Standard and Developer Edition Q232234 KB232234 October 21, 2013
• 222073 INF: Getting Started with Data Transformation Services (DTS) Q222073 KB222073 October 20, 2013
• 207809 INF: DTS/Replication Licensing for Desktop SQL Server 7.0 Q207809 KB207809 October 11, 2013
• 198487 INF: INSERT EXEC of Text/Image/Ntext from XP Is Not Supported Q198487 KB198487 October 11, 2013
• 198416 INF: Trace Flag 8816 to Help Year 2000 Conversion Q198416 KB198416 October 11, 2013
• 197245 INF: How to Determine Tempdb Size Required by DBCC CHECKDB Q197245 KB197245 October 11, 2013
• 196905 INF: Backup with INIT or FORMAT Is Documented in Error Log Q196905 KB196905 October 11, 2013
• 43199 INF: Concurrency and Consistency and SQL Server Alternatives Q43199 KB43199 August 23, 2013
• 255596 INF: sp_lock2 Returns Additional Locking Details Q255596 KB255596 March 20, 2013
• 274348 INF: Distributed Queries Executed Within a Trigger Enlist MSDTC Q274348 KB274348 March 8, 2013
• 274797 INF: SQL Server 7.0 Service Pack 3 Fixlist Q274797 KB274797 January 28, 2013
• 238912 INF: Understanding Microsoft Repository Q238912 KB238912 December 11, 2012
• 274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Q274799 KB274799 November 30, 2012
• 195759 INF: Frequently Asked Questions - SQL Server 7.0 - SQL Setup Q195759 KB195759 October 17, 2012
• 229929 INFO: Registry Entries and Keywords for SQL Server Connection Strings Q229929 KB229929 April 20, 2012
• 315886 INF: Common SQL Mail Problems Q315886 KB315886 March 30, 2012
• 228940 INF: VB .DEP Files Not Available for SQL Server Redistributable Components Q228940 KB228940 September 17, 2011
• 307775 INF: Disaster Recovery Articles for Microsoft SQL Server Q307775 KB307775 October 29, 2007
• 192710 INF: Basic Guidelines for Installing SQL Server Version 6.5 or 7.0 Q192710 KB192710 October 26, 2007
• 219264 INF: Order of Installation for SQL Server 7.0 Clustering Setup Q219264 KB219264 September 28, 2007
• 214820 INF: How to Use the SQL Server DMO Objects from VBScript Q214820 KB214820 August 8, 2007
• 232570 INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Q232570 KB232570 July 18, 2007
• 274798 INF: Readme.txt for SQL Server 7.0 Service Pack 3 Q274798 KB274798 May 28, 2007
• 322742 INFO: Content Management Server Supports SQL Server Log Shipping for Failover Q322742 KB322742 May 23, 2007
• 254369 INF: SQL Server 7.0 Service Pack 2 Fixlist Q254369 KB254369 April 12, 2007
• 883724 Information about the SQL Server edition of the MPS Reporting tool Q883724 KB883724 April 10, 2007
• 327068 INF: SQL Server 7.0 Security Update for Service Pack 4 Q327068 KB327068 March 29, 2007
• 266650 Information About BackOffice Program Support on Windows 2000 Datacenter Server-Based Computers Q266650 KB266650 March 1, 2007
• 245543 INFO: ODBC Connection Pooling Counters in Performance Monitor and ADO Q245543 KB245543 February 15, 2007
• 240166 INFO: MDAC 2.1 Sets Session Pooling ON by Default Q240166 KB240166 February 15, 2007
• 324411 INF: Available White Papers for SQL Server Q324411 KB324411 September 13, 2006
• 225019 INF: SQL Server 7.0 Service Pack 1 Fixlist Q225019 KB225019 September 8, 2006
• 160181 INFO: Trace Flag to Replicate UPDATE as DELETE/INSERT Pair Q160181 KB160181 September 1, 2006
• 321817 INF: Readme.txt Files for SQL Server 7.0 Service Packs Q321817 KB321817 August 31, 2006
• 279153 INF: Upgrade Wizard Does Not Transfer Existing Stored Procedures Q279153 KB279153 July 27, 2006
• 283040 INF: Readme.txt for SQL Server 7.0 Service Pack 3 (Continued) Q283040 KB283040 July 19, 2006
• 323411 INF: Programs Run Through Xp_cmdshell Have No User Interface Q323411 KB323411 June 22, 2006
• 188883 INF: How to Install Only the SQL Server Books Online Q188883 KB188883 May 5, 2006
• 233337 INF: How to Determine When an Unattended SQL Server 7.0/MSDE 1.0 Setup is Complete Q233337 KB233337 March 31, 2006
• 251270 INFO: Where to Find Information About MSDE for Visual Studio Q251270 KB251270 August 15, 2005
• 152174 INF: Output Parameters, Return Codes and the ODBC Driver Q152174 KB152174 March 16, 2005
• 184039 INFO: Using Return Codes with xp_cmdshell Stored Procedure Q184039 KB184039 March 14, 2005
• 176480 INF: How to Restrict the Inner Table of an ANSI Outer Join Q176480 KB176480 March 14, 2005
• 175955 INF: How to Write a Variance Query in SQL Server Q175955 KB175955 March 14, 2005
• 156501 INF: QUOTED_IDENTIFIER and Strings with Single Quotation Marks Q156501 KB156501 March 14, 2005
• 154886 INF: Behavior of ANSI_PADDING Q154886 KB154886 March 14, 2005
• 143339 INF: ODBC Messages on SQL Server Connections Q143339 KB143339 March 14, 2005
• 139528 INFO: Table Alias Syntax Checking in SQL 6.0 and Later is ANSI-Compliant Q139528 KB139528 March 14, 2005
• 104446 INFO: New NO_INDEX Option for SQL Server for Windows NT Q104446 KB104446 March 14, 2005
• 198493 INFO: Using NEAR in SQL Full-Text and MSIDXS Distributed Queries Q198493 KB198493 March 2, 2005
• 197247 INF: "OR" Clause Prohibits the Use of Merge or Hash Algorithms Q197247 KB197247 March 2, 2005
• 48711 INF: Finding Names of Columns that Comprise the Key of a Table Q48711 KB48711 March 2, 2005
• 47605 INF: Collisions During Multiple-User Updates Q47605 KB47605 March 2, 2005
• 46424 INF: Copying SQL Database Files for Backup/Restore Purposes Q46424 KB46424 March 2, 2005
• 124015 INFO: Trigger Execute Even if No Rows Affected by SQL Statement Q124015 KB124015 February 22, 2005
• 104829 INFO: Converting Binary Data to Hexadecimal String Q104829 KB104829 February 22, 2005
• 171299 INF: How to Obtain Case-Sensitive Query Results with a Case-Insensitive Sort Order Q171299 KB171299 February 14, 2005
• 155723 INF: SQL Server Truncation of a DBCS String Q155723 KB155723 February 14, 2005
• 125627 INF: Starting SQL Server Remotely from the NT Command Prompt Q125627 KB125627 February 14, 2005
• 98620 INF: BCP and NULL Values Q98620 KB98620 February 14, 2005
• 90477 INFO: Aggregates and SET Clause in UPDATE Statement Q90477 KB90477 February 14, 2005
• 81339 INF: Using Batch Sizes with the BCP Utility Q81339 KB81339 February 14, 2005
• 79886 INF: Example of Using Nested Triggers Q79886 KB79886 February 14, 2005
• 76784 INF: Operating System Commands and Control of Flow in ISQL or OSQL Q76784 KB76784 February 14, 2005
• 75291 INF: Restricting Access to Master Database in SQL Server Q75291 KB75291 February 14, 2005
• 75282 INF: Using Transact-SQL SET Options in DB-Library Application Q75282 KB75282 February 14, 2005
• 73212 INF: ISQL Is Faster When Output Is Sent to Disk File Q73212 KB73212 February 14, 2005
• 70246 INF: ISQL Does Not Send Carriage Returns to SQL Server Q70246 KB70246 February 14, 2005
• 69286 INF: Using BCP to Import Image Data into SQL Server Q69286 KB69286 February 14, 2005
• 68230 INF: Using Substring to Parse & Interpret Binary Data in SQL Q68230 KB68230 February 14, 2005
• 67871 INF: Translating DBMONEY Datatype into Actual Dollar Amount Q67871 KB67871 February 14, 2005
• 67659 INFO: BCPing in Just the Date of Datetime Column Q67659 KB67659 February 14, 2005
• 67623 INF: ISQL or OSQL Lines That Have Already Been Typed in Can Be Edited Q67623 KB67623 February 14, 2005
• 67410 INFO: Use User-Defined Data Type to Extract Current Time Q67410 KB67410 February 14, 2005
• 64176 INF: Dynamically Altering Table Definitions in SQL Server Q64176 KB64176 February 14, 2005
• 60054 INF: Restoration of a Database from Transaction Dumps Q60054 KB60054 February 14, 2005
• 59462 INF: Cannot Turn Off Transaction Logging Q59462 KB59462 February 14, 2005
• 58534 INF: Specifying Priority for Deadlock Victim Selection Q58534 KB58534 February 14, 2005
• 47465 INF: Stored Procedures Can Be Nested 16 Levels Deep Q47465 KB47465 February 14, 2005
• 47270 INFO: SQL Access Permissions and Trigger Execution Q47270 KB47270 February 14, 2005
• 297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 Q297864 KB297864 January 12, 2005
• 286124 INF: How to Reschedule a DTS Package Q286124 KB286124 July 15, 2004
• 313980 INF: List of Bugs Fixed by SQL Server 7.0 Service Packs Q313980 KB313980 July 13, 2004
• 252987 INF: Execute a SQL Server DTS Package from Active Server Pages Q252987 KB252987 June 29, 2004
• 100365 INF: DIFFERENCE() and SOUNDEX() Functions in Transact-SQL Q100365 KB100365 June 29, 2004
• 199132 INF: OLAP: How to Index Star/Snowflake Schema Data Q199132 KB199132 June 28, 2004
• 285997 Initial snapshot generation may fail if network redirector caching is enabled Q285997 KB285997 May 6, 2004
• 287093 INFO: DB2OLEDB Supports UPDATE/DELETE from SQL Linked Server Q287093 KB287093 March 26, 2004
• 251004 INF: How to Monitor SQL Server 7.0 Blocking Q251004 KB251004 March 22, 2004
• 315642 INF: Information that PSS needs to troubleshoot SQL Server replication Q315642 KB315642 March 2, 2004
• 197456 INF: Optimizing Distributed Query with Numeric Predicates Q197456 KB197456 February 23, 2004
• 196911 INF: Database Creation and Backup Operations Use Parallelism Q196911 KB196911 February 23, 2004
• 272424 INF: Object Ownership Chain Checking Across Databases Depends on the Login That Is Mapped to the Object Owners Q272424 KB272424 February 5, 2004
• 199294 INF: Server Side Cursor Behavior When CURSOR_CLOSE_ON_COMMIT Set OFF Q199294 KB199294 December 5, 2003
• 143337 INF: Behavior if Both ARITHABORT & ARITHIGNORE Are Set ON Q143337 KB143337 December 5, 2003
• 151596 INF: Extended Procedure Error: "Cannot find the DLL 'xxx.dll'" Q151596 KB151596 December 3, 2003
• 140696 INF: RAISERROR, PRINT, and the MS SQL Server ODBC Driver Q140696 KB140696 December 3, 2003
• 139555 INF: Invalid Use of dbwritetext Can Cause 806 Errors Q139555 KB139555 December 3, 2003
• 61793 INF: Creating & Filling a Table with Sample Data in SQL Server Q61793 KB61793 December 3, 2003
• 48712 INF: Handling Timeouts Correctly in DB-Library Q48712 KB48712 December 3, 2003
• 47295 INF: Deadlocks and Two-Phase Commit Q47295 KB47295 December 3, 2003
• 46783 INF: Updating Column in One Table w/ Column from Another Table Q46783 KB46783 December 3, 2003
• 46435 INF: Deadlocks and Timeouts Q46435 KB46435 December 3, 2003
• 45590 INF: Purpose of TRUNCATE TABLE Q45590 KB45590 December 3, 2003
• 44415 INF: Timestamps and Their Uses Q44415 KB44415 December 3, 2003
• 240025 INF: Rollback Transaction in Triggers at Subscriber Can Break Transactional Integrity Q240025 KB240025 November 26, 2003
• 68938 INF: @@TRANCOUNT Global Variable Detects Rollback Q68938 KB68938 November 25, 2003
• 198625 INF: Optimizing Comparisons with Numeric, Integer, and Others Q198625 KB198625 November 21, 2003
• 171221 INF: List of Version Numbers of ODBC Driver Manager and SQL Server Q171221 KB171221 November 20, 2003
• 239454 INF: ScriptPkg Tool Generates DTS Object Model Code to Help Use DTS Programmatically Q239454 KB239454 November 17, 2003
• 268877 INF: Registering SQL Server Wizard Gives a Misleading Error Message Q268877 KB268877 November 14, 2003
• 268784 INF: SQL Enterprise Manager Rounds Database Size Q268784 KB268784 November 14, 2003
• 257434 INF: Network Library in Existing DSN Replaced by Network Library in New DSN to the Same SQL Server Name Q257434 KB257434 November 14, 2003
• 174817 INF: Microsoft SQL Server DB-Library Has Limited Extensibility Q174817 KB174817 November 14, 2003
• 271624 INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage Q271624 KB271624 November 12, 2003
• 235282 INFO: SQL Server Spawns Additional Connections When You Open Multiple ForwardOnly ADO Recordsets Q235282 KB235282 November 5, 2003
• 222657 INF: Storing a Directory Tree and Maintaining a Full Path Using Recursive Triggers Q222657 KB222657 November 3, 2003
• 178132 INFO: ODBC Client Error After Connecting Using MDAC SQL Server Driver Q178132 KB178132 November 3, 2003
• 308518 INF: Refresh of Current Activity in SEM May Cause "Error 1222: Lock Request time out period exceeded" Error Message Q308518 KB308518 October 31, 2003
• 292442 INF: How to Use the Windows Synchronize Manager with Pull Subscribers Q292442 KB292442 October 31, 2003
• 279660 INF: How to Query with Data Using SQL Mail and Exchange Server Q279660 KB279660 October 31, 2003
• 277535 INF: How to Install Localized SQL Server Error Messages Q277535 KB277535 October 31, 2003
• 275312 INF: SQL Server Procedure to Change Object Owner Q275312 KB275312 October 31, 2003
• 266694 INF: ALTER TABLE with ADD COLUMN and DEFAULT May Take a Long Time on a Large Data Set Q266694 KB266694 October 31, 2003
• 255937 INF: How to Create and Attach a Removable SQL 7.0 Database Q255937 KB255937 October 31, 2003
• 254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 Q254561 KB254561 October 31, 2003
• 198024 INFO: Understanding ADO Transactions with MS SQL Server Q198024 KB198024 October 31, 2003
• 306230 INF: How to Check the ANSI Settings Under Parsing Time Q306230 KB306230 October 30, 2003
• 242543 INF: DTS Row Level Restartability After an Unexpected Failure Q242543 KB242543 October 30, 2003
• 44519 INF: Error Handling in Transact-SQL Blocks and Stored Procedures Q44519 KB44519 October 30, 2003
• 275685 INF: Importing Performance Monitor Logs into SQL Server Q275685 KB275685 October 29, 2003
• 221465 INF: Using the WITH MOVE Option with the RESTORE Statement Q221465 KB221465 October 28, 2003
• 325334 INF: SQL Server and Striped Backups Q325334 KB325334 October 17, 2003
• 323161 INF: Avoid Using Device Names as Database Names Q323161 KB323161 October 17, 2003
• 315689 INF: SQL Query Analyzer Color Code Information Q315689 KB315689 October 17, 2003
• 314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO Counters Q314648 KB314648 October 17, 2003
• 303459 INF: How to Improve the Performance of Full-Text Search Queries for Large Database Tables Q303459 KB303459 October 17, 2003
• 270716 INF: You Cannot Use xp_loginconfig to Set Configuration Values Q270716 KB270716 October 17, 2003
• 257856 INF: SQL Server Agent Automatically Sets "Trunc. Log on Chkpt" for MSDB Q257856 KB257856 October 17, 2003
• 247193 INF: Database Property Sheet Displayed Incorrectly Q247193 KB247193 October 17, 2003
• 246181 INF: SQL 6.5 Database Upgrade with a Space in the Path to Master.dat Fails Q246181 KB246181 October 17, 2003
• 243811 INF: Sqldiag.exe Can be Included in an MSDE Custom Setup Q243811 KB243811 October 17, 2003
• 242260 INFO: Cannot Use OSP Data Providers with SQL DTS Q242260 KB242260 October 17, 2003
• 234181 INF: Logins Aliased to Databases Users Cannot Be Viewed from SQL Enterprise Manager Q234181 KB234181 October 17, 2003
• 232196 INF: Log Space Used Appears to Grow After Restoring from Backup Q232196 KB232196 October 17, 2003
• 232195 INF: Proper Use of the COLUMNS_UPDATED() Function Q232195 KB232195 October 17, 2003
• 231830 INF: Insertion of Strings Containing Trailing Spaces Q231830 KB231830 October 17, 2003
• 221832 INF: How to Enable Logging for SQL Server Cluster Wizard Q221832 KB221832 October 17, 2003
• 214602 INF: sp_dbcmptlevel 'master' is not Allowed Q214602 KB214602 October 17, 2003
• 207396 INF: Cannot See Actual Data Values for Columns in Enterprise Manager Q207396 KB207396 October 17, 2003
• 200117 INF: Not Possible to Remove Optional Components of SQL Server Q200117 KB200117 October 17, 2003
• 198851 INF: User Cannot Bind Rule to UDDT Created By Different User Q198851 KB198851 October 17, 2003
• 322877 INF: SAP Retail - Benchmark (White Paper) Q322877 KB322877 October 16, 2003
• 312983 INF: Lotus Notes GUID Format Different Than SQL Server GUID Q312983 KB312983 October 16, 2003
• 306628 INF: Inconsistent Behavior with Object Ownership with db_owner Created Objects Q306628 KB306628 October 16, 2003
• 271669 INF: Distributed Queries are not Run as Parallel Query Steps Q271669 KB271669 October 16, 2003
• 216575 INF: xp_enum_oledb_providers Enumerates the OLE DB Providers Q216575 KB216575 October 16, 2003
• 313986 INF: SQL Server 7.0 Service Pack 4 Readme.htm Additions Q313986 KB313986 October 9, 2003
• 132224 INF: Network Encryption Available Using the Multi-Protocol Net Library Q132224 KB132224 September 24, 2003
• 243352 INF: "DBCC TRACEON (208)" Messages in the Error Log When Using MSQuery Q243352 KB243352 September 16, 2003
• 142480 INF: Cascading Deletes and Updates of Primary Keys Q142480 KB142480 September 16, 2003
• 311826 INF: Index Tuning Wizard Best Practices Q311826 KB311826 September 15, 2003
• 248241 INF: Enabling SQL DMO Clients Without Installing the Client Side Utilities Q248241 KB248241 May 13, 2003
• 215520 INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level Q215520 KB215520 May 13, 2003
• 242391 INF: DTS Package Development, Deployment and Performance Q242391 KB242391 November 25, 2002
• 199819 INF: SQL Server 7.0 BCP and Code Page Conversion Q199819 KB199819 August 28, 2002
• 276044 INF: How to Manually Uninstall SQL Server 7.0 Q276044 KB276044 June 11, 2002
• 322611 INF: SQL Server 7.0 Distributed Queries: OLE DB Connectivity (White Paper) Q322611 KB322611 May 28, 2002
• 322351 INF: Accessing Heterogeneous Data with SQL Server 7.0 (White Paper) Q322351 KB322351 May 23, 2002
• 248683 INF: Microsoft Data Engine Security Recommendations for ISVs Q248683 KB248683 March 1, 2002
• 242377 INF: How to Use Data Transformation Services (DTS) Q242377 KB242377 February 5, 2002
• 251281 INF: Using Logical Names in SQL Server 7.0 Q251281 KB251281 January 7, 2002
• 234987 INFO: SQL Server Driver Version 3.70 May Return Fractional Truncation Message When Processing DateTime Parameter Q234987 KB234987 August 23, 2001
• 281879 INF: How DBCC SQLPERF (Logspace) Reports Percentage Used Q281879 KB281879 August 15, 2001
• 258990 INF: How to Trace in SQL Server by Using Extended Stored Procedures Q258990 KB258990 July 27, 2001
• 246310 INF: How to Use DTS Wizard to Insert Data into SQL Tables with an Identity Column Q246310 KB246310 October 27, 2000
• 197297 INF: Comparison of Join Techniques Q197297 KB197297 April 21, 1999