SQL Server 7.0 articles, fixes and updates - February 2005

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

• 164171 BUG: dbprocerrhandle Does Not Get Fired For Error 10029 Q164171 KB164171 February 22, 2005
• 124015 INFO: Trigger Execute Even if No Rows Affected by SQL Statement Q124015 KB124015 February 22, 2005
• 115333 BUG: Recreating a Table Causes sysdepends to Become Invalid Q115333 KB115333 February 22, 2005
• 104829 INFO: Converting Binary Data to Hexadecimal String Q104829 KB104829 February 22, 2005
• 173848 BUG: Sp_OA Procedures May Produce "Bad Variable Type" or "Type Mismatch" Error Q173848 KB173848 February 14, 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
• 89938 BUG: ISQL Problems with PRINT in Stored Procedures Q89938 KB89938 February 14, 2005
• 89656 How to calculate the product of a field Q89656 KB89656 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
• 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
• 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
• 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
• 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
• 59461 PRB: Zero Rows Returned from SQL SELECT Statement Q59461 KB59461 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
• 317044 HOW TO: Read and Write a File to and from a BLOB Column by Using Chunking in ADO.NET and Visual C++ .NET Q317044 KB317044 February 7, 2005