• Microsoft Developer Network
• ▶Highlights
• ▶Technical Articles
• ▶Sample Code
• ▶Resource and Strategy
• ▼Knowledge Base and Bug Lists
  • ▶C/C++ KBase
  • ▶CodeView KBase
  • ▶LAN Manager KBase
  • ▶MASM KBase
  • ▶MS-DOS KBase
  • ▶MS Foundation Classes (MFC) KBase
  • ▶MS Test for Windows KBase
  • ▶Multimedia KBase
  • ▶Programmer's WorkBench KBase
  • ▶QuickC for Windows KBase
  • ▼SOL Server KBase
    • INF: Setup Fails While Creating Master Database
    • PRB: Cannot Connect to SQL Server Using ISQL/SAF/SQLTEST(R/P)
    • INF: Invoking an Editor from ISQL
    • INF: SQL Server Disk-Space Management, Part 1
    • INF: Case Sensitivity in SQL Server
    • PRB: Resetting Configuration Parameters to Defaults
    • PRB: Cannot Use /Zp Compiler Option with DB-LIBRARY
    • INF: DB-LIB and Floating Point
    • INF: Using dbdata() Versus dbbind()
    • PRB: DBCC Reports Page Count Discrepancy on SYSLOGS Table
    • INF: Interrupting the Display of SQL Server Output
    • INF: How to Calculate the Virtual Device Number
    • INF: SQL Server Disk-Space Management, Part 2
    • INF: SQL Server Disk-Space Management, Part 3
    • PRB: SQL Server Msg 4002: Login Failed; Login Incorrect
    • INF: Disk Dump Device Size in SYSDEVICES
    • PRB: BCP Ignores Rules and Triggers
    • INF: How to Start SQL Server
    • PRB: SAF OK_to_clear Dialog Clears Only SQL Query Window
    • INF: Cannot Add the
    • INF:
    • INF: Using Browse Mode in DB-LIBRARY
    • PRB: CREATE TABLE Appears to Ignore IF Statements
    • PRB: Error Creating Stored Procedure
    • PRB: DOS Workstation Fails to Connect with SQL and SQLTESTR
    • INF: Using Built-In Functions with Triggers
    • INF: SQL Row Size Limited to 1962 Characters
    • INF: Concurrency and Consistency, and SQL Server Alternatives
    • INF: Timestamps and Their Usages
    • INF: Using Windows Global Heap Buffers
    • INF: Pages Counted by DBCC Differs from dpages
    • INF: Creating Stored Procedures That Modify System Tables
    • INF: Issuing an Update in Browse Mode
    • INF: WAITFOR ERROREXIT/PROCESSEXIT Wake-Up Conditions
    • INF: dberrorhandle and dbmsghandle Error-Handling Routines
    • INF: Using Separate Pipes for Update in Browse Mode
    • INF: Use of Timestamps in Browse Mode
    • INF: Use of Multiple Unique Indexes by dbqual in Browse Mode
    • INF: Updating Values in Columns Used by dbqual in Browse Mode
    • INF: Updating a Row a Second Time in Browse Mode
    • INF: Determining If a Row Has Been Changed in Browse Mode
    • INF: Retrieving Current Timestamp from Data Row
    • INF: No Timestamp Is Returned by dbtsnewval() If Update Fails
    • INF: Why dbqual Returns Null WHERE Clause in Browse Mode
    • INF: Restrictions for Multi-Table Outer Joins
    • PRB: Using a Self-Join to Produce a Cartesian Product
    • INF: Shared Access to Modified Data
    • INF: Waiting for Access to Modified Data
    • INF: Detecting Deadlocks
    • INF: Rollback from Within Triggers
    • INF: Writing Efficient Queries and Stored Procedures
    • INF: Locking Multiple Tables in SQL Server
    • INF: Temporary Tables and Logging
    • INF: Purpose of TRUNCATE TABLE
    • PRSQL9012001: DATEDIFF Overflows If Less Than One Day
    • INF: Table Locking De-Escalation
    • INF: Fixed-Length Versus Variable-Length Index Entries
    • INF: Data Page Cache Management in SQL Server
    • INF: Sorting Data Out of SQL Server
    • INF: SQL Clustered and Non-Clustered Index Sort Work Area
    • INF: Handling of NULLs, Null Strings, and Blanks in SQL Server
    • INF: Partitioning Logical Disks for Use with SQL Server
    • INF: Using Hard Disk Controller Caching with SQL Server
    • INF: Effect of SET ROWCOUNT on SELECT with ORDER BY
    • INF: Support of Page and Table Locking in SQL Server
    • INF: dbopen() Failure Can Abort SQL Server Program
    • INF: BCP and Transaction Logging
    • INF: Monitoring SYSLOGS Space Usage
    • INF: Copying SQL Database Files for Backup/Restore Purposes
    • INF: Writing Efficient Queries and Stored Procedures
    • INF: Deadlocks and Timeouts
    • PRB: Improving Response Time When Communicating over Network
    • PRB: Using DISK REFIT Versus DBCC DROPDB on Damaged Databases
    • INF: Recovering from Media Failure in SQL Server
    • PRB: DATEADD Doesn't Work When Using a Variable as a Date
    • INF: Deadlock Scenarios and Avoidance in SQL
    • PRB: CONVERTing Character to an Integer Causes Syntax Error
    • INF: Sp_foreignkey Does Not Automatically Create a Common Key
    • PRSQL9103051: SAF DBO Options Not Available to Aliased DBO
    • INF: SQL Access Permissions and Trigger Execution
    • INF: Starting SQL Server Remotely
    • INF: Deadlocks and Two-Phase Commit
    • INF: Do Not Use CONSOLE with SAF
    • INF: Stored Procedures Can Be Nested 12 Deep
    • INF: Purpose of PROBE.EXE
    • INF: Effect of Permissions Additions/Deletions on SYSPROTECTS
    • PRB: Locks and Timeouts
    • INF: Finding Names of Columns That Comprise the Key of a Table
    • INF: Handling Timeouts Correctly in DB-LIBRARY
    • PRB: Using Datetime Variable w/ WAITFOR TIME or WAITFOR DELAY
    • INF: Using BCP
    • INF: Modifying BCP Format File to Load into Specific Columns
    • PRB: dpages Inconsistencies Reported by DBCC
    • PRB: Number of User Connections Has Been Exceeded Error
    • INF: How DATALENGTH Determines the Length of Text Fields
    • INF: Stopping an SQL Server
    • INF: Understanding the Microsoft SQL Server Optimizer
    • PRB: Zero Rows Returned from SQL SELECT Statement
    • INF: Cannot Turn Off Transaction Logging
    • INF: Cannot Suppress Column Headings When Using ISQL
    • INF: Numbers Reported by sp_monitor for cpu_busy
    • INF: SQL Server Shuts Down When Master Database Is Reloaded
    • INF: Size Considerations for Database and Log Devices
    • INF: Restoration of a Database from Transaction Dumps
    • INF: Altering Database to Add Multiple Log Devices
    • INF: Creating a Log Device If
    • PRB: Using BldMastr to Reset Configuration to Default
    • INF: sp_configure Parameters Affect Memory Usage by SQL Server
    • INF: Two-Phase and Three-Phase Commit Information
    • INF: Administering a Server from a Remote Location
    • INF: Creating
    • INF: SQL Server Extent Allocation Information
    • INF: SQL Server Performance Analysis
    • INF: SQL Server SELECT with HOLDLOCK Transaction Information
    • INF: Conditions When Stored Procedures Are Recompiled by SQL
    • INF: Backing Up and Recovering Databases
    • PRB: Assignment of NULL Value to Local Variable in SQL
    • INF: Creating NOT NULL Character Fields Without Padded Blanks
    • INF: Finding Length of SQL IMAGE Fields While Using DB-LIBRARY
    • PRB: SQL Server DBCC Checkalloc
    • INF: GROUP BY Function Only Returns Rows
    • PRB: No Error If UPDATE or DELETE Processes 0 Rows
    • INF: SYSPROCESSES Table to Display Resource Information
    • INF: Processing Time for Update/Delete Transactions
    • PRB: Db-lib Not Compatible with Borland's Turbo Compilers
    • INF: Dynamically Altering Table Definitions in SQL Server
    • PRB: IF UPDATE Trigger with No Rows Changed
    • PRB: Errors Creating Recursive Stored Procedures
    • INF: Differentiating Between Timestamp and Varbinary Types
    • PRB: Use of Clustered Index Improves Self-Join Performance
    • INF: MIN and MAX Should Not Be Used on Timestamp Column
    • PRSQL9012043: sp_monitor Reports That idle_time Is Zero
    • INF: SQL Server NetWare Named Pipes Information
    • INF: Creation of Indexes and Memmove Error #632
    • INF: Disk Space Allocated for and Used by the Master Database
    • INF: Reserve More Disk Space for Master Database Syslogs File
    • INF: Global Variable @@error Checks for Successful Completion
    • INF: Interpretation of SET STATISTICS TIME ON Results
    • INF: Distributing Db-lib w/ Front-end SQL Server Applications
    • INF: Error Handling in a DB-LIBRARY Application
    • PRB: Updating a Database Sysindexes Table
    • PRSQL9012002: Problems Using BCP Functions in DB-LIBRARY
    • PRSQL9012003: Problems Using dbbind() with Global Variables
    • PRB: Problems with SAF and Novell Requester NETAPI.DLL File
    • PRSQL9012004: Incorrect Results Returned by dbcount()
    • INF: MS-DOS Programs for SQL Server on a Novell Platform
    • PRSQL9012005: SELECT * in EXISTS Subquery Returns True
    • PRSQL9012006: Overflow Error Problem with Nonnull INTs
    • PRSQL9012007: ISQL Confuses GOTO with GO in SQL Server 1.10
    • PRSQL9012008: dbexit() Fails Under Windows in SQL Server 1.1
    • INF: Using Temporary Tables with Stored Procedures/Triggers
    • INF: Dump/Load Database Time Differences
    • INF: SQL Server Third-Party Apps and Consultants Directory
    • INF: Using DBLOCKLIB
    • PRSQL9012010: Embedded GOs and Syntax Errors in SAF
    • INF: SQL Server 1.1 NetLib (Open Architecture) Information
    • INF: Calculating Space for the Storage of NULL Values
    • PRSQL9012011: Shutdown Query from SAF Hangs MS-DOS
    • PRSQL9012012: Bad Pointers on Text Data Sent Via BCP
    • PRB: Running Out of Log Space When Running Large Bulk Loads
    • PRSQL9012014: dbwinexit() Problems with Windows Dblib
    • PRSQL9012015: dbtxtsnewval() Fails Under Windows 3.00
    • PRSQL9012016: After dbclrbuf() Is Called, No Rows Retrieved
    • PRSQL9012017: Problems Calling dbnextrow() After dbgetrow()
    • INF: Using SQL Db-lib Calls in Multithreaded Programming
    • INF: How to Determine If DBNMPIPE.EXE Is Loaded from C Program
    • INF: Providing Application Security Through Triggers in SQL
    • INF: Using BCP to Import NULL Values into Datetime Columns
    • PRB: SQL Server Fails to Start During Installation
    • INF: Invoking Stored Procedures from Embedded SQL for COBOL
    • INF: Using Cursors to Return Results in Embedded SQL for COBOL
    • INF: Using a Prepared Cursor in Embedded SQL for COBOL
    • INF: Branching Within Static Batch in Embedded SQL for COBOL
    • INF: Data Conversion Sample Program in Embedded SQL for COBOL
    • INF: Error 7129 If Concurrent Processes Update Same Text Page
    • PRSQL9012018 Can't Subtract with DATEADD Function
    • PRB: SQL Server Error 1608 in Errorlog
    • INF: What Happens When UPDATE Performs INSERT/DELETE
    • INF: Recommended File System Setup for SQL Server
    • PRSQL9103054: 10/3/90 Build of ISQL Needs 10/3/90 PDBLIB.DLL
    • INF: Using a Stored Procedure in a Cursor Definition
    • PRB: Setup Won't Install Utilities from Remote Floppy Drive
    • PRB: Rolling Back Individual Rows from an INSERT Trigger
    • PRSQL9106020: Procedure with SELECT INTO Cannot Be Restored
    • PRSQL9012020: Views Contain
    • PRSQL9012021: ISQL Hangs Restoring Master Database
    • PRSQL9012022: Can't Insert Money/Float Larger Than 2147483647
    • INF: QS0431: Commonly Asked BCP Utility Questions in SQL
    • INF: Use User-Defined Data Type to Extract Current Time
    • INF: QS0433: Devices, Databases, and Transaction Logs
    • PRSQL9012023: SAF GP-Faults When Adding User Logins
    • INF: SQL Memory Configuration Minimization
    • PRB: Why SQL Server Prints Numerous Rows of Dots at Startup
    • INF: ISQL Lines That Have Already Been Typed in Can Be Edited
    • PRSQL9012024: Upgrading on a Server with No Monitor
    • INF: Informing SQL Server That More Memory Has Been Added
    • PRB: Error 2102 Occurs While Installing SQL Server on Novell
    • INF: Extracting Month and Year from ASCII File with BCP
    • INF: BCPing in Just the Date of Datetime Column
    • PRB: Starting SAF on a Stand-Alone SQL Server
    • INF: Deleting Text from SQL Stored Procedures and Triggers
    • PRSQL9012025: Joins with False WHERE Clause GP-Fault
    • INF: How the SQL SOUNDEX Algorithm Works
    • INF: Transferring Tables and Data from Paradox to SQL Server
    • PRB: No Error Occurs When Adding Trigger That Exists
    • PRB: SELECT INTO Fails Inside a User-Defined Transaction
    • PRSQL9012027: DB-LIBRARY Returns Incorrect Error Level
    • INF: Executing SQL Server Stored Procedures from Excel
    • PRB: Problems with Altering Model Database to Move Syslogs
    • INF: Checking Results of Stored Procedures with RAISERROR
    • PRSQL9012028: ISQL Interprets Label as GO Command
    • PRSQL9012029: Incorrect Filename Can GP-Fault SAF
    • PRSQL9012030: SAF Does Not Display Long Filenames
    • INF: Storage of SQL Server's Error Log on Stand-Alone Server
    • INF: SQL Doc Error on When to Run
    • PRB: Making DB-LIBRARY Calls in a User-Defined DLL
    • INF: Quick Method for Reinstalling SQL Server
    • INF: Using Substring to Parse
    • INF: Sizing Considerations for SQL Databases
    • PRSQL9012031: GP-Fault in SAF with smallint
    • PRSQL9012032: ORDER BY Produces NULL Column
    • PRSQL9012033 Can't USE
    • PRB: Using WHERE with OR or IN Can Slow Down Performance
    • PRB: Rows Affected by INSERTS/UPDATES Not Shown in SAF
    • INF: Location of Deleted and Inserted Tables
    • INF: QS0436: Procedure for Testing Named Pipes
    • PRSQL9012034: Compile with /W4 Causes Error with SQLFRONT.H
    • PRSQL9012036: Mouse Control Lost After Shutdown Issued
    • PRSQL9107005: Dbconvert() Incorrectly Converts to DATETIME
    • INF: Implicit Rollbacks of Transactions in SQL Server
    • INF: Converting SQL CHAR Values into DATETIME Values
    • PRSQL9012037: Error 4405 When Inserting Through Views
    • PRB: Process All Results to Find Number of Rows Affected
    • INF: Using FOR BROWSE on a View in SQL Server
    • Update to SQL Server 1.10 Is Available
    • PRB: When to Use bcp_columns() and bcp_colfmt()
    • PRSQL9103055: Queries Using the MAX() Function May Run Slowly
    • INF: Changes Incorporated in 10/03/90 Build of SQL Server
    • INF: Using BCP to Load Data into SQL Table with Unique Index
    • INF: Using BCP to Import Image Data into SQL Server
    • INF: Dump Point Flag in the Transaction Log of SQL Server
    • INF: Configuring LAN Manager Peer Service for SQL Server
    • INF: QS0434: Optimization Techniques for SQL Server 1.10
    • PRB: No Size Change When Dump Overlaid Over Previous Dump
    • INF: SQL SELECT INTO Option for TEMPDB and Temporary Tables
    • INF: Creating a Duplicate SQL Database
    • INF: No Conflicts Between DBO and Aliased DBO in SQL Server
    • INF: Creating a 4 Byte User-Defined DATE Data Type
    • INF: SQL Backup Support Using Removable Storage Media
    • PRSQL9012038: SQL Server Allows an Invalid Device Name
    • INF: Conventions dbconvert() Uses to Convert FLOAT to CHAR
    • PRSQL9012039: dbgetmaxprocs()
    • INF: Explanation of SQL Server PATINDEX Parameters and Output
    • INF: NNEXTREAD Error in SQL Server Error Log
    • PRB: Sp_helpdb Uses the SET NOCOUNT ON SQL Statement
    • QS0435: Correcting
    • PRB: Excel Function Macros Cannot Access SQL Server Data
    • INF: How Q+E Handles Table Permissions in SQL Server
    • INF: Documentation Unclear on
    • PRSQL9012040: Dbconvert() Does Not Call Error Handler
    • PRSQL9012041: dbsetopt() After dbsqlexec() GP-Faults Dblib
    • INF: SQL Server Truncates Program Name and Host Name
    • PRSQL9103001: The EXP Function GP-Faults SQL Server
    • PRSQL9103002: Outer Join on a Bit Column GP-Faults SQL Server
    • PRSQL9103003: The ANY Keyword Does Not Return Expected Results
    • PRSQL9103004: Results Incorrect with GROUP BY and Sum in Views
    • PRSQL9103005: Cannot Load Case Sensitive DB Into Insensitive
    • PRSQL9103006: Incorrect Results from an OR Select Statement
    • PRSQL9103007: Running a Query with an IN Clause GP-Faults SQL
    • PRSQL9103008: SQL Server Sends Incorrect TDS Token
    • PRSQL9103009: Cannot Assign a Local Variable a Computed Value
    • PRSQL9103010: Converting Type Bit with ORDER BY GP-Faults SQL
    • PRSQL9103011: Duplicate Values with a Unique Clustered Index
    • PRSQL9103012: SPACE(NULL) Will GP-Fault SQL Server 1.10
    • PRSQL9103014: Error 614 Occurs When the SQL Server Is Stressed
    • PRSQL9103015: Referencing a Table Created in a Transaction
    • PRSQL9103016: Positioning of
    • PRSQL9103017: Cannot Pass @@Version to a Stored Procedure
    • PRSQL9103020: Aliasing Column in Compute Clause GP-Faults SQL
    • PRSQL9103021: Dbmoretext() GP-Faults with a Pointer to a Null
    • PRSQL9103023: Cannot Use Large Filenames with DISKINIT in SQL
    • PRSQL9103024: Cannot Read Results After SQL Server Times Out
    • PRSQL9103025: Cannot Use a Blank for Field Terminator with BCP
    • PRSQL9103026: Error 4405 Occurs When Inserting Through Views
    • PRSQL9103027: Cannot CONVERT to Image with an ORDER BY
    • PRSQL9103030: Problems Inserting Large Invalid Image Data
    • PRSQL9103031:
    • PRSQL9103032: Datatype Corrupt If Table Created by SELECT INTO
    • PRSQL9103033: Extra Space Is Added to Local Variables
    • PRSQL9103034: Table Lock Not Escalated with TEXT Datatype
    • PRSQL9103035: Select Distinct Does Not Return Expected Results
    • PRSQL9103036: Installing SQL Server Remotely Fails 2nd Disk
    • PRSQL9103037: Updating in Browse Mode Can Cause a Deadlock
    • PRSQL9103038: Altering Table Can Cause Duplicate Column Names
    • PRSQL9103039: Backing Up Transaction Log to Floppy Disk Fails
    • PRSQL9103040: RAISERROR in Trigger Will Not Call Error Handler
    • PRSQL9103041: Do Not Use Embedded Go's with dbcmd
    • PRSQL9103042: Using Sqlpass(.) GP-Faults COBOL Compiler
    • PRSQL9103043: BCP Does Not Work with User-Defined Default
    • PRSQL9103045: Cannot Back Up SAF with 40/More Devices Defined
    • PRSQL9103046: DOS and Windows DB-LIBRARY Applications Hang
    • PRB: Maximum TEXTSIZE in SAF and ISQL
    • PRSQL9103048: Using the Datalength() Function with Convert()
    • INF: No Pascal API Interface to SQL Server
    • PRB: dbopen() Execution Time Degrades
    • PRB: Returning Results from SQL Updates/Inserts to Q+E
    • PRB: Accessing SQL Server from Excel with Q+E Query Files
    • INF: Removing Duplicate Rows from an Existing Table in SQL
    • PRB: Syntax Error Inserting DATETIME Data
    • PRB: NetServerEnum Error Going into SAF
    • PRSQL9103050: Column Datatype Not Listed on SP_HELP
    • PRSQL9104004: DB-LIBRARY Problem Using DBBUFFER
    • INF: Sending Transact-SQL Queries to Q+E Using COMMAND()
    • PRSQL9105003: Negative Money Values Incorrect in DB-LIBRARY
    • PRSQL9105004: Problem with Dependent Stored Procedures
    • PRSQL9105005: Problems When W3DBLIB.DLL Is Loaded at Run-Time
    • INF: SQL Server and User Level Security
    • INF: Determining Case Sensitivity of a 1.x SQL Server
    • INF: Number of Open Objects Allowed in SQL Server
    • INF: Passing SQL Command-Line Parameters with LANMAN.INI
    • INF: Embedded SQL for COBOL Version 1.0 Is Really 1.1
    • PRSQL9106001: Maximum of 15 dbopen() Calls from Windows App
    • PRSQL9106003: INT_CANCEL Returns SUCCEED Instead of FAIL
    • PRSQL9104003: dbclropt() Can Fail to Turn Off Row Buffering
    • PRB: Embedded SQL for COBOL Documentation Error, Page 38
    • INF: Recoverability and Transaction Log Dumps
    • PRB: SAF Does Not Allow Numeric Login IDs and Passwords
    • INF: Reasons Why Q+E Update of SQL Server Table May Fail
    • PRSQL9106006: Subquery in Double Parentheses GP-Faults Server
    • PRB: R6009 - Out of Environment Space in ESQL for COBOL
    • INF: Linking Embedded SQL for COBOL MS-DOS Apps with COBLIB
    • INF: Creating .GNT Files with Embedded SQL for COBOL
    • INF: Fast Query to Return Number of Rows in a Table
    • INF: Using BCP When Data Is Within Quotation Marks
    • INF: ISQL Is Faster When Output Is Sent to Disk File
    • PRB: Unable to Call W3DBLIB.DLL Functions from Macro Languages
    • INF: Using dbsqlsend() and dbdataready() in Windows
    • PRB: Reasons for Error 10008: Bad Token from SQL Server
    • PRB: LAN Manager Maxusers Limits SQL Server Connections
    • PRSQL9106013: DBMORECMDS() Returns FAIL
    • PRSQL9106007: Dbprrow() Output in Wrong Order When Redirecting
    • PRSQL9106008: Rule Violation on Table Causes tempdb Problems
    • PRSQL9106010: Cannot Insert NULL Datetime with BCP DB-LIBRARYS
    • PRSQL9106012: Incorrect Query with COMPUTE May GP-Fault SQL
    • PRB: Problem Creating New Login
    • PRSQL9106014: Dbaltbind() Fails with VARYCHARBIND
    • PRSQL9106017: Dbprrow() Succeeds After Dbsqlexec() Fails
    • PRSQL9106018: Dbconvert() Incorrectly Converts Money Values
    • PRSQL9107006: #defines Missing Causes Unpredictable Behavior
    • PRSQL9107007: Dbqual() Does Not Accept Keys That Allow Null
    • PRSQL9107009: Bcp_exec() Cannot Read Unformatted Data Files
    • PRSQL9107011: Row Buffering Runs Out of Selectors with Select
    • PRSQL9107010: Compute Data Structures Not Being Deallocated
    • PRSQL9107012: DB_OUT Mode Reports Overflow Errors
    • PRSQL9107014: Dbclropt() Does Not Deallocate Buffer Space
    • PRSQL9107016: Binary Data Stored in Column Defined as Text
    • PRSQL9105006: Kernel Errors with Text Data Types
    • PRSQL9105007: SELECT..FOR BROWSE Fails with NULL TIMESTAMP
    • INF: Implementing a Unique, Increasing Key Value
    • PRSQL9108001: L2029 on DBERRHANDLE and DBMSGHANDLE with /Gc
    • INF: Explanation of Index ID 255
    • INF: Using Transact-SQL SET Options in DB-LIBRARY Application
    • PRB: Can't BCP in NULLs from Fixed-Length Files
    • PRB: Optimizer Maintains Stats on First Column of Indexes
    • PRSQL9110014: Stored Procedure Group Problem After Re-Creating
    • INF: Too Many User Connections Keep SQL Server from Starting
    • INF: Restricting Access to Master Database in SQL Server
    • PRSQL9108002: Invalid Use of Aggregate Function Max()
    • PRB: SA Login Fails After Dropping Default Database
    • INF: Programming DB-LIBRARY TSR with MS-DOS Extenders
    • PRSQL9107020:
    • INF: Complexity of WHERE Clauses in SQL Server
    • PRSQL9108004: Running ENDDBLIB After LOADHIGH DBNMPIPE
    • PRSQL9108005: Dbproc Is NULL After a Query Times-out
    • PRB: Reasons for Receiving Message Numbers 3115 and 3116
    • PRB: Sp_helpdevice Shows Multiple Devices with Device_number 0
    • PRB: High Column of the Sysdevices Table Used for Dump Devices
    • PRSQL9108006: Cannot SELECT with LIKE on TEXT Column in a View
    • PRSQL9108007: Error 703 When Trying to Add New Logins
    • PRSQL9108008: SQL Query with CONVERT Causes GP-Fault
    • PRSQL9108009: Error 625 After Creating Multiple Databases
    • INF: FILLFACTOR Settings in SQL Server
    • PRSQL9108012: SQL Server GP Faults on SUBQUERY with BROWSE
    • PRSQL9108013: DISK INIT in a Stored Procedure Causes GP-Fault
    • INF: Limit of 40 Variables with DECLARE in Batch and Procedure
    • PRSQL9108014: SQL Server GP-Faults on Outer Join on View
    • INF: Reducing Lock Contention in SQL Server
    • PRSQL9108015: Dbnextrow Returns Unexpected Row After Dbgetrow
    • PRSQL9107008: Using CHARBIND to Bind a CHAR(1) Column
    • PRSQL9107015: Bcp_sendrow() Allows 2 Chars Stored in varchar(1
    • PRSQL9107017: Text Data Incorrectly Inserted into SQL Server
    • PRSQL9107018: BCP Calls Cause Data Conversion Errors
    • PRSQL9107019: DBLIB Program Hangs Trying to Connect to SQL
    • PRSQL9107020: BCP GP-Faults If Unique Index Exists
    • INF: Indexes Use Distribution Page Statistics
    • PRSQL9109001: PATINDEX with Brackets Returns Incorrect Index
    • PRSQL9109002: Updating a FLOAT, INT, or MONEY Column
    • PRSQL9109003: Bcp_sendrow Ignores Length If Terminator Exists
    • PRSQL9109004: Using bcp_sendrow() with Multiple Bit Columns
    • PRSQL9109007: BCP Utility Incorrectly Handles Command Line
    • PRSQL9109006: Convert from INT NULL to VARCHAR Fails
    • PRSQL9109005: Dbqual() Returns Syntactically Incorrect String
    • PRSQL9109008: Problem Starting New BCP Operation After Error
    • INF: Operating System Commands and Control of Flow in ISQL
    • PRB: Cannot Use dbclose() or dbexit() in an OS/2 Exit Routine
    • PRSQL9110001: Money Division Resulting in $0.0001
    • PRSQL9110002: Two-Phase Commit/Start_xact Stored Procedure
    • INF: Error 3004 Uninitialized Pages Dumping Database
    • INF: Representative Sorting/Scanning Rates for SQL Server
    • PRSQL9110005: SQL Server GP-Faults When Fed Binary File
    • PRSQL9110006: Error 911 in Log If
    • PRSQL9110012: Inserting Using PREPARE and EXECUTE/USING Slows
    • PRSQL9110010: BCP_INIT Fails with Syntax Error Message
    • PRB: Msg 3201 When Attempting to Dump or Load Database
    • PRB: SQL Server Connections Not Closed from Visual Basic
    • PRB: No RAISERROR in sp_password
    • PRB: Subquery with IN Clause Runs Very Slowly
    • INF: Doc Err on Visual Basic Library for SQL Server Login Proc
    • PRB: Error 10001: NULL DBPROCESS Pointer Encountered
    • PRSQL9111001: Executing Certain INSERT Statements and GP-Fault
    • PRSQL9111002: Msg 924 When Running Stored Procedure
    • PRSQL9111003: New Data Not in Table Created by SELECT INTO
    • PRSQL9111005: Testing for Dynamic Tables Breaks Connection
    • INF: When Dirty Cache Pages Are Flushed to Disk
    • PRSQL9111006: LIKE Clause in SELECT with JOIN GP-Faults Server
    • PRSQL9111008: dbopen/dbclose Loop Runs Out of Memory
    • PRSQL9111011: GP Fault Using Variable Assignment with INSERT
    • PRB: Cause of Trap 0002 Errors
    • PRSQL9110001: Incorrect Error Message When CREATE INDEX Fails
    • PRSQL9112002: No Error Creating an Index on 17 Columns
    • PRSQL9112003: sp_helpindex Truncates Index Key List
    • PRSQL9112004: Can't Log in When No User ID in Default Database
    • INF: LAN Manager Caching and SQL Server
    • PRSQL9112005:Incorrect Database Ownership After Dropping Login
    • PRB: Changing Ownership of a Database
    • PRSQL9112006: Trigger Rollback in Batch Halts Processing
    • PRB:
    • PRSQL9112011: Modifying a Table Without Permissions
    • PRSQL9112013: Ownership Chains Improperly Implemented
    • INF: Example of Using Nested Triggers
    • PRSQL9112015: Illegal Login ID Containing Embedded Spaces
    • PRSQL9112009: Error 511 After ALTER TABLE
    • INF: Setting Up Servers to Use Remote Procedure Calls
    • PRSQL9201001: INSERT
    • PRSQL9201002: Not Enough Memory in SAF on MS-DOS Workstation
    • PRSQL9201003: Cursor Not Accept Temp Tables in ESQL for COBOL
    • INF: Mix of Aggregate Functions
    • INF: Expiring SQL Server Login Passwords
    • PRB: View Created with a Subquery Cannot Be Updated
    • PRSQL9201006: SAF Incorrectly Displays
    • INF: SQL Server Sizing Considerations
    • PRSQL9201007: bcp_colfmt() Incorrectly Uses file_collen Param
    • PRB: Transaction Log Partially Truncated
    • PRB: Unable to Access SQL Server from an OS/2 Client
    • PRSQL9201008:
    • PRSQL9201009: BCP Inserts Logged If Dest. Table Has Trigger
    • INF: Building Apps with Visual Basic Library for SQL Server
    • PRSQL9202002: BCP: Nulls Inserted in Non-Null varchar Column
    • PRSQL9202004: ISQL GP Fault/SAF Hang Loading Large Image Data
    • PRSQL9202007: Conversion Incorrectly Handles Trailing Blanks
    • PRSQL9202008: Convert Defaults to 30 When No Length Is Given
    • PRSQL9202003: Permissions Granted Improperly on New Columns
    • PRB: SYS2070: System Could Not Demand-Load Application Segment
    • PRSQL9202009: Login Fails If User's Default Database Is Lost
    • INF: Using Batch Sizes with the BCP Utility
    • PRB: Error Log Shows One Transaction Rolled Forward on Startup
    • PRSQL9202013: SqlOpenConnection%() Doesn't Set Name in Record
    • PRB: ErrorNum 10034 When Calling SqlSetOpt%()
    • PRSQL9202018: UPDATE Statement Causes GP-Fault
    • PRSQL9202014: UAE When Closing Multiple VBSQL Applications
    • PRSQL9202015: UAE When Running Multiple VBSQL Applications
    • PRSQL9202017: User Cannot BCP Data into a Table
    • PRSQL9203001: SAF Does Not Display Network Login IDs
    • PRSQL9203002: DUMP / TRUNCATE / DUMP Causes 3201 Error
    • PRSQL9202020: Login with no User Name Cannot Log In
    • PRSQL9202021: Cause of 602 and 813 Errors with Stored Procs
    • INF: Moving Databases Between Servers Using DUMP/LOAD
    • INF: Change in Default Datetime Display Format in DB-LIBRARY
  • ▶Visual Basic KBase
  • ▶Windows DDK KBase
  • ▶Windows for Pen Computing KBase
  • ▶Windows SDK KBase
• ▶Books and Magazine Articles
• ▶Product Documentation
• ▶Unsupported Tools & Utilities