- 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