ANSI Join Table w/ Nested View w/ Group by Clause May Cause AV

BUG DOC: Log Backup Mode Incorrectly Documented for Backup Seq.

BUG: Agent Fails w/ Incorrect Syntax for Updating Subscribers

BUG: Err 'Invalid Object Name' on Linked Server Table w/ OLEDB

BUG: Error 17835 Received When Connecting Locally

BUG: Errors in 'Implementing Nonpartitioned,...' BOL Sample

BUG: Function dbcursorfetch Fails with Error 221

BUG: ISQL/W Has Problem Displaying Large Strings

BUG: 'Cannot Start Service' Error Starting OLAP Services

BUG: 'Do You Want to Delete This Index' Msg. When Creating Index

BUG: 'If' or 'Where Exists' Statements Report Syntax Error

BUG: 'SET TRANSACTION ISOLATION LEVEL' Ignored in Stored Proc

BUG: 'Too Many Arguments Were Supplied' Error Inserting a Row

BUG: 'Too Many Open File Handles' Error Using Named Pipes

BUG: 'Unable to Connect' Msg May Occur in Application Event Log

BUG: 'Not Null' Constraints May Be Ignored When Inserting Data

BUG: (DOC) Description of Sysaltfiles Table Incorrect

BUG: (local) Disappears Using DTS Transfer SQL Server Object

BUG: @@IDENTITY in Nested Stored Procedure Returns NULL

BUG: @@IDENTITY Variable Not Handled Like a Global Variable

BUG: @@OPTIONS Does Not Revert to Pre-Procedure Setting

BUG: @@ROWCOUNT May Be Misreported Inside a Trigger

BUG: 1105 During Object Resolution Can Cause Thread AV

BUG: 1205 - Deadlock Situation Not Detected by SQL Server

BUG: 229 Error on Stored Procedures Dependent Object

BUG: 2710 Error When Executing St. Proc. w/ UPDATE STATISTICS

BUG: 32-bit ISQL.EXE Does Not Properly Set ERRORLEVEL

BUG: 32-bit Object Manager Fails When Using Transfer Feature

BUG: 3307 Lock Error on INSERT SELECT UNION Abort w/ Dup Key

BUG: 3600 Errors Written to ERRORLOG With INSERT..EXEC of xproc

BUG: 6.5 Parse/Compile Time Is Greater than 6.0 on Large Join

BUG: 6.5 Upgrade Requires Domain Login for SQLExecutive

BUG: 7.0 ISQL.EXE Returns Different Results than 6.5 ISQL.EXE

BUG: 7.0 Upgrade Loops When 6.5 Parameters Are Reversed

BUG: A Foreign Key Table with Data in Tempdb Creates Error 1105

BUG: A Process May Stop Responding Several Seconds with Waittype

BUG: Access Violation After Update of a Text Column

BUG: Access Violation Backing up Tran Log After Error 5042

BUG: Access Violation if 4 Mirror Device Files Not Available

BUG: Access Violation in kill_proc May Cause Server Hang

BUG: Access Violation in Setup.exe If SNMP Entries

BUG: Access Violation When Using ANSI JOIN on a Table with View

BUG: Active/Passive Cluster Setup Breaks Replication and DTS

BUG: Adding Check Constraint with ESCAPE Keyword Causes AV

BUG: Adding Columns of Non-Nullable User Defined Datatypes

BUG: Adding constraints through SEM sometimes unbind default o

BUG: Adding Several Defaults to Model Can Cause 602 Errors

BUG: Adding Steps to Database Maint Job Results in Error in SEM

BUG: Addition of Local Server Is Case Sensitive

BUG: ADOMD Hangs if no BeginTrans Corresponding to CommitTrans

BUG: Agent May Shut Down If SQL Server Is Started from Console

BUG: Agg. Functions in CASE Exp. in Correlated Subquery May AV

BUG: Aggregate Function on View With Correlated Subquery Can AV

BUG: Aggregate of an Expression May Return the Incorrect Scale

BUG: Alias w/ Aggregates Can Cause Handled AV on 4.2x Upgrade

BUG: Aliased DBOs in v6.0 May Not Be Able to Access Database

BUG: Already Present Counter Not Used in SQL Security Manager

BUG: ALTER DB Hangs When DUMP DB Performed Simultaneously

BUG: Alter Table May Fail to Create Primary Key Constraint

BUG: Alter Table Within a Stored Procedure Causes Msg 1750

BUG: Alternate Pipe Not Recognized in Unattended Installation

BUG: ANSI Full Outer Join and Non-ANSI Join May Cause Handled AV

BUG: ANSI Group By With

BUG: ANSI_PADDING Ignores Using Subquery in Insert

BUG: AnsiToOem Check Box Does Not Work in 6.0 Transfer Manager

BUG: Application Error When Expanding a Stored Procedure

BUG: Application Stops When Linking with RMDBLIB.LIB

BUG: Arithmetic Overflow Error when Using the Power() Function

BUG: Assigning datetime to smalldatetime May Change Value

BUG: Async Keyset Cursors and Memory Pressure May Cause AV

BUG: Attentions When Using Text Based Insensitive/Keyset Cursors

BUG: AV Declaring Cursor Based on View w/ No Underlying Table

BUG: AV If Extended Static Cursor Runs SP Containing GROUP BY

BUG: AV If Update on a Column with CASE and Aggregate Functions

BUG: AV in SEM Managing Logins Using Trusted Connections

BUG: AV May Occur With Invalid String in LIKE Clause

BUG: AV Occurs When Using Generate SQL Scripts Option in SEM

BUG: AV on Cursor with Arithmetic Operation and ORDER BY Clause

BUG: AV on FETCH From Updatable CURSOR Using VIEW

BUG: AV Updating Cursor on Cross-Database View After Restore

BUG: AV Using Aggregate Functions in the Select List

BUG: AV Using Insert With Correlated Subquery and Check Option

BUG: AV When INSERT SELECT UNION into a Table with a Foreign Key

BUG: AV When UPDATE STATISTICS in a Cursor Is Terminated

BUG: Backups Over Network Using INIT Take Longer to Complete

BUG: Bad Trigger Generated for Table with Nullable Foreign Key

BUG: Banyan Vines Netlib Does Not Support Larger TDS Packet Size

BUG: BCP Cannot Copy Text/Image Data

BUG: BCP Fails to Parse Format File If It Has Space in Col. Name

BUG: BCP Fails w/ Binary Convert to SYBCHAR

BUG: BCP Fails When Entry in Format File Has No Matching Data

BUG: BCP Fails with Unhandled Exception on MIPS Servers

BUG: BCP format file created for quote enclosed data cannot be

BUG: BCP Import Activities May Encounter an Undetected Deadlock

BUG: BCP In Fails With Files Larger Than 1.8 GB

BUG: BCP IN May Insert More Characters Than Column Allows

BUG: BCP IN of INT With Trailing Spaces May Fail

BUG: BCP Into a Table w/ IDENTITY Column Cannot Be Performed

BUG: BCP Into Table with Constraints May Cause AV in BCP.EXE

BUG: BCP No Error If Last Line of Data File Is Incomplete

BUG: BCP Utility Echoes Login Password

BUG: BCP w/ Format File Switching Columns w/ Nulls Causes Err.

BUG: BCP Will Insert Larger Values Than Decimal Column Allows

BUG: BCP Will Not Load Native File if First Two Bytes Are 0xFEFF

BUG: BCP: CONTROL+C or CONTROL+Break May Not Stop BCP Out

BUG: BCP: Err Msg: Attempt to Bulk-copy an Oversized Row

BUG: Bcp_bind Does Not Correctly Convert Real DBFLT4

BUG: bcp_done Sets TEXTSIZE to 4096

BUG: Bcp_exec Causes AV If Bcp_columns Less Than Table Columns

BUG: bcp_exec May Cause Unexpected EOF Message

BUG: BCP_EXEC Returns Incorrect Rows Affected on Failure

BUG: bcp_init() Fails if DBBUFFER Is Set Too Low

BUG: BOL Incorrectly Documents Permissions to System Stored Proc

BUG: BOL Incorrectly States That SQL Server Doesn't Support TOP

BUG: BOL States T-SQL Outer Joins in FROM Clause Support Dropped

BUG: Borland DB-Lib with Vines Fails with Memory Error

BUG: BULK INSERT Fails While Inserting into an IMAGE Column

BUG: Call to SqlCursorFetch from Vbsql.vbx Causes GPF

BUG: Calling dberrhandle in Error Handler Causes Recursion

BUG: Can Not Change Display Options in ISQL/W for Win-16

BUG: Can Not Change Recurring Tasks to Once a Day in SEM

BUG: Can't Access Table Created w/ SP in Another Database

BUG: Can't Save Changes When OLAP Repository on SQL Server 6.5

BUG: Canceling Striped Table Dump May Cause 1203, dbswritecheck

BUG: Cannot Convert Between TEXT and NTEXT by Using UPDATETEXT

BUG: Cannot Delete OLAP Service Directory After Removing OLAP

BUG: Cannot Drill Down Virtual Dimension w/More Than 760 Members

BUG: Cannot Grant User Permissions When Logging in as DBO

BUG: Cannot Have More Than Eight Full Text Joins and Operations

BUG: Cannot Import Excel 97 Spreadsheet with 256 or More Columns

BUG: Cannot Modify Grouped SPs in Enterprise Manager

BUG: Cannot Restore Database When Model Database Is in Use

BUG: Causes of Nsqlprep.exe Err. 'Couldn't Spawn Compiler.

BUG: Changing Database to Read Only Can Cause Error #2601

BUG: Changing Partition's Fact Table Changes Column Name

BUG: Character Translation Causes 105, Unclosed Quote Error

BUG: Check Constraint Not Enforced if Marked 'Not for Replica..'

BUG: Client Apps Stop Responding When Running Server-side Cursor

BUG: Client Network Utility Allows Invalid IPX Port Address Form

BUG: Client Terminated on Repeated Unsuccessful Obj Resolution

BUG: Close Connection After sp_certify_removable Gets Warning

BUG: CMDExec Task May Cause Heap Corruption and AV in SQL Exec

BUG: Column Level Permissions not Scripted if Generated Using EM

BUG: Columns Listed Multiple GROUP BY w/ CUBE Clauses Violation

BUG: Command Aborted When Inserting into a IGNORE_DUP_KEY Table

BUG: Comments Field Returned By xp_enumgroups is NULL

BUG: Comments in Views Removed When Using View Designer

BUG: Concurrent Async Keyset Cursors can Result in Server Hang

BUG: Concurrent Cursors and St Procs Against Table May Cause AV

BUG: Concurrent Insert w/ Open Object Reuse May Cause Hang

BUG: Config. Guide for SQL Monitor Registry Entries Incorrect

BUG: Conflict Viewer Shows Incorrect Format for Datetime Column

BUG: Confusing Error Message w/ CREATE UNIQUE NONCLUSTERED INDEX

BUG: Conn Using MP Netlib with Low Memory can Fail with AV

BUG: Connection Broken for Remote Stored Proc with COMPUTE BY

BUG: Connection Error From SEM After Adding Code Page 950

BUG: Connection Hangs Using Asynchronous Cursor to Insert Data

BUG: Convert Defaults to 30 When No Length Is Given

BUG: Convert From Binary to Numeric Gives Error 8114

BUG: Convert From FLOAT to NUMERIC Causes Arithmetic Overflow

BUG: Converting char to float Causes Arithmetic Overflow

BUG: Corr. Subqry with WHERE GROUP

BUG: Correlated Subquery in Col. List May Cause Divide by Zero

BUG: Correlated Subquery Using EXISTS and UNION Can Cause AV

BUG: Create Procedure May Cause Error 1203

BUG: Create Statistics or WHERE Clause on Float Returns Error

BUG: CREATE TABLE Allows More Than 31 FOREIGN KEYs

BUG: CREATE TABLE in Stored Proc w/Name 'sp_' May Fail

BUG: CREATE TABLE Statement May Be Missing in Generated Script

BUG: CREATE TABLE Trailing Comma Not Treated as Syntax Error

BUG: CREATE TABLE w/ IDENTITY Property May Cause Client AV

BUG: Create Table w/ Multi. Identity Columns Causes Handled AV

BUG: Create Table with Double Precision May Be Inconsistent

BUG: CREATE VIEW Fails with Message 8120

BUG: Create/Insert in Stored Procedure Does Not Init Timestamp

BUG: Creating a View in EM Using a Domain Account May Fail

BUG: Creating New TCP/IP Advanced Entry Deletes Existing Entries

BUG: Creating Table in EM Using Domain Acct. May Cause Server AV

BUG: Creating Temp Table in SEM Causes Error 208

BUG: Cross-Database Table Creation/Drop in Stored Procedure

BUG: Current Activity Blank in Enterprise Manager 6.5

BUG: Current Database Not Correct After Use in Query Window

BUG: Cursor Fetch Within Stored Procedure Behavior Inconsistent

BUG: Cursor Indifference to INDEX Optimizer Hints

BUG: Cursor on Query with Aggregate Blocks with READ UNCOMMITTED

BUG: Cursor Open 533 Error on UNION if MAX or MIN in Subquery

BUG: Cursor Update with a SELECT on View After LOAD Causes AV

BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins

BUG: Custom Stored Procedures Fail: Fractional Truncation Error

BUG: Cut or Paste into SQL Admin Query Window Changes DB Focus

BUG: Daily Tasks May Be Disabled If Activestartdate = 0

BUG: Data in Sysbackuphistory Table Not Displayed in GUI

BUG: Data Transfer Fails if Range Exceeds Rows in Table

BUG: Database Owner is Not Associated w/ User Id DBO

BUG: Database Upgrade May Generate Error #159

BUG: DATETIME Convert May Set NULL to Jan 1, 1900 12:00AM

BUG: Datetime Rounding Up Behavior Undesirable

BUG: DB Maintenance Wizard Does Not Auto-Delete After 7 Days

BUG: DB-Lib Client Apps Access Violation in Ntwdblib.dll

BUG: DB-Lib Unable to Handle Burst of TDS Packets Under TCP/IP

BUG: DB-Library bcp_sendrow() Fails on SQL 7.0

BUG: DB-Library Connections Stop Responding with AfxOleInit

BUG: dbbind Converts char Column w/ Leading Spaces to Zero

BUG: DBCC CHECKTABLE(SYSINDEXES) Hangs SQL Server

BUG: DBCC DBREINDEX Can Fail With Msg 603 After Msg 1105

BUG: DBCC HELP Shows Incorrect Syntax for NEWALLOC

BUG: DBCC MEMUSAGE Is Not Supported in SQL Server 7.0

BUG: DBCC NEWALLOC May Cause AV When Extent Chain Corrupt

BUG: DBCC OPENTRAN Fails to Run on Fallback Server

BUG: DBCC OPENTRAN Reports Incorrect Database Name

BUG: DBCC SHOW_CONTIG May Return Invalid Values

BUG: DBCC SHOWCONTIG Against Invalid Index ID Raises Msg 602

BUG: DBCC SQLPERF(logspace) Returns Incorrect Database Name

BUG: Dbclropt Does Not Reset the DBBUFFER Status

BUG: dbconvert Fails to Convert Strings Other Than '0' or '1'

BUG: dbconvert Not Consistent w/ Transact SQL CONVERT Function

BUG: dbconvert to decimal from Float Fails for Small Values

BUG: DBCOUNT() Returns Zero for sp_sqlexec

BUG: dbcursorbind Documentation Incorrect

BUG: Dbcursorbind with Money Datatype May Hang Application

BUG: dbcursorcolinfo() Returns Invalid Column Types

BUG: dbcursoropen Not Call Handlers for Invalid Table Names

BUG: dbdataready and DBDEAD Return FALSE After spid is Killed

BUG: dberrhandle() Not Called Due to Network Error

BUG: dbinit() Will Cause GP Fault if thousand_sep Set to Null

BUG: DBLIB Stops When Multiple Threads Handle An Error

BUG: DBO Cannot Run DBCC Newalloc Command

BUG: dbprocerrhandle Does Not Get Fired For Error 10029

BUG: Dbprocerrhandle or Dbprocmsghandle Unexpectedly Returns NUL

BUG: Dbreadtext Incorrectly Processes All Result Sets

BUG: dbrettype Return Values Differ from Documentation

BUG: dbrpcparam SQLCHAR and Sending Null for Datetime Variable

BUG: Dbsqlexec

BUG: DBSQLEXEC() Returns Fail When RAISERROR Is Called

BUG: DDL in Stored Procedure Can Cause Access Violation

BUG: Deadlocks Can Cause Tables to Be Stranded in tempdb

BUG: Declare Cursor May Be Ignored With Correlated Subquery

BUG: Declare Cursor May Fail with Memory Error 702

BUG: DECLARE CURSOR on View with DISTINCT Causes AV

BUG: DECLARE Dynamic Cursor w/ ORDER BY Causes Access Violation

BUG: Default Constraints May Be Ignored When Inserting Data

BUG: Default Converts @@dbts to int May Cause Access Violation

BUG: Default of @@DBTS Causes Access Violation When Using BCP

BUG: Default Query Timeout for Replication Tasks Incorrect

BUG: Deferred Updates, Triggers and READ UNCOMMITTED Leak Memory

BUG: Design Table in SEM Does Not Preserve NOT FOR REPLICATION

BUG: Desktop Exception on Connects with Server Name

BUG: Direct SPX Connection May Fail from Win16 Client

BUG: Disabled Importing File DTS Import CMD Dialog Box

BUG: Disabling Level May Cause Error When Designing Aggregation

BUG: Disk Dumps May Cause Handled AV When Space Is Low

BUG: Dist Task Ignores Errors on Pre-creation Commands

BUG: Dist. Task Fails w/Invalid Cursor State Error If Batch = 1

BUG: Distinct Subquery in Stored Proc Causes Access Violation

BUG: Distributed Query Predicate not Remoted

BUG: Distribution Task Fails to Synchronize Access .MDB with Err

BUG: Distribution Task Fails with 'Incorrect syntax near '{''

BUG: Distribution Task Fails with Dupe Key Error at Subscriber

BUG: DMO BCP Fails with Mixed Security and Trusted Connection

BUG: DMO BulkCopy Leaves File Locks When Format File Is Missing

BUG: DMO Script() Method Generates GO Following CREATE INDEX

BUG: DOC Error: DNR and Compilation Section Incorrect

BUG: DOC: Primary Filegroup Cannot be Read-Only

BUG: DOC: DB_OWNER Roles Cannot Administer All Jobs

BUG: DOC: DOC: SQL Books Online Doc Error for CHECKCATALOG

BUG: DOC: IGNORE_DUP_ROW and Tables with Text Data

BUG: DOC: Info on Manual Replication for Sync Task Incorrect

BUG: DOC: Information About Nonlogged vs. Logged BCP Incorrect

BUG: DOC: Information on Default Memory Config Incorrect

BUG: DOC: OLAP Sample Code Is Incorrect

BUG: DOC: SKIP/NOSKIP Options Are Invalid with LOAD DATABASE

BUG: DOC: Update Statistics Example to Update All Tables Wrong

BUG: DOC: Variable Arguments not Refreshed After Cursor Declared

BUG: DOCERR: Adding a Multiple-Column Measure to a Cube

BUG: DocErr: Books Online for Mixed Security Has Wrong Graphic

BUG: DocErr: Books Online Missing Concatenation Operator (+)

BUG: DOCERR: Books Online Says That Binding Causes Re-Resolution

BUG: DocErr: CUR_FORWARD Scroll Option is Not Documented

BUG: DocErr: IS NULL Now Supports TEXT and IMAGE Columns

BUG: DocErr: Syntax for SET DEADLOCK_PRIORITY Statement

BUG: DocErr: Unattended Setup INI File in Books Online

BUG: DocError Books Online for sp_resetstatus/sp_marksuspect

BUG: Documentation Error in Dimension Interface Example

BUG: Documentation Error on Hiding SQL Server on the Network

BUG: Domain Credentials Inappropriately Requested

BUG: Double Back-slash (\\) in C Can Cause ESQL for C Errors

BUG: Double Precision Synonym Mapped to REAL Instead of FLOAT

BUG: Double Quotes in ESQL for C Can Cause C Compiler Errors

BUG: Drop Table on Referencing Table After Restarting Fails

BUG: DTC May Return Msg 8503 or Msg 8522

BUG: DTC Transaction IDs and Isolation Levels Not Captured

BUG: DTS - Error Creating File Mapping View

BUG: DTS Fails When Importing Table with a Timestamp Column

BUG: DTS Import/Export Wizard Does Not Display Scheduling

BUG: DTS OLAP Processing Task Fails if Package Stored in Reposit

BUG: DTS Package Creator/Owner Name Does Not Change

BUG: DTS Packages Stored in the Repository Are Not Listed

BUG: DTS Query Builder Problem with Inline Comment

BUG: DTS Stops Responding w/ Blank Column Headers in Source File

BUG: DTS Transfer Not Reporting Err if Text Qualifier is Missing

BUG: DTS: Default Scheduling Information Displayed

BUG: DTS: Table Transfers Incorrectly if Using Char or Varchar

BUG: DTS: Two or More Columns with the Same Name Cannot Transfer

BUG: Dump Database Logs flush_cache Errors and Does Not Complete

BUG: Dump DB with INIT/UNLOAD May Fail to Execute in a Batch

BUG: Dump DB/Trans Permission Denied When User Not in DB

BUG: DUMP Fails Without Error Using VOLUME

BUG: Dump to Tape with Init Ignored in Stored Procedure

BUG: DUMP TRAN May Fail with No Error to the User

BUG: Dump/Load Within Stored Proc Using Parameters Causes AV

BUG: Dumps to Multiple Tapes/Disks May Cause Unresponsiveness

BUG: Dupe Timestamp Values After Installing Alpha 4.21a SP3/4

BUG: Dynamic Cursor Inside a SP Using ISNULL() or Date Function

BUG: Dynamic Cursor w/ NOLOCK Hint Causes Assertions in Err Log

BUG: Dynamic Execution with Long Comments May Fail with AV

BUG: Dynamic Sysprocesses Cursor May Cause Error 616

BUG: Edit Database Shows Incorrect Values w/Log Size Over 2 GB

BUG: EM Err: Unable to Construct Column Clause for Article View

BUG: Enabling Callback Functions in SQLTEST3.EXE

BUG: English Query MFC Sample Gives AV on Win98

BUG: Enterprise Manager Scripts Repl_subscriber Login/User

BUG: Enterprise Manager: Err Msg: 'Too many columns defined ..'

BUG: Entries for Deleted Trusted Users Are Not Fully Removed

BUG: ERR 107 Occurs when Alias Name of Derived Table not Found

BUG: ERR 18456 when Configuring Publishing w/ Remote Distributor

BUG: Err 2085 w/ SP Having NULLIF or COALESCE w/ Subquery

BUG: ERR 21776 Running Wizard Against Table not Owned by DBO

BUG: Err 511: Stored Proc w/ANSI_NULL_DFLT_ON Creates Perm Tbl

BUG: Err Msg 549 When Adding Foreign Key on Primary Key Column

BUG: Erroneous Message from CREATE TRIGGER Inside EXEC

BUG: Error 'Unexpected EOF' May Occur Under Dbmsrpc3.dll

BUG: Error -19104 If Column/Table/Alias Name Starts with CURRENT

BUG: Error 15211 from sp_password if SET ANSI_NULLS Is On

BUG: Error 16928 Encountered When Using 'For Update of' Cursor

BUG: Error 16929, 'Cursor Is Read Only' for Cursor w/OpenQuery()

BUG: Error 18009 If Call xp_readmail w/ @suppress_attach Param

BUG: Error 206 Calling Procedure with SQL_DEFAULT_PARAM

BUG: Error 208: Create Trigger Statement Fails in SEM

BUG: Error 21770 Adding Login in SEM and User with SP_ADDUSER

BUG: Error 221 Fetching from Keyset Cursor Using Outer Join

BUG: Error 225 When Using ALTER TABLE in a Batch

BUG: Error 3307 Creating sproc or view with Existing Name

BUG: Error 4028 Does Not Report the Correct Volume Label

BUG: Error 403 or 602 on Table Insert of UNION of Views

BUG: Error 403: UNKNOWN TOKEN on SELECT with Subquery

BUG: Error 4601 When DBO Assigns Permissions for a View

BUG: Error 5105 if Disk Init Reuses vdevno

BUG: Error 513 on Update/Insert on Join When No Rows Affected

BUG: Error 515 w/Concatenated NULLs in WHERE Clause and ORDER BY

BUG: Error 530 When Selecting NULL CHAR() Local Variables

BUG: Error 602 When Using Server Side Cursors

BUG: Error 602 While Fetching from a Cursor Defined on a View

BUG: Error 610 When a Query Generates More than 15 Worktables

BUG: Error 7102 with Keyset-Driven Cursors on Table w/ Text Col.

BUG: Error 7113 When Selecting into a Table

BUG: Error 7124 Documents Incorrect Size for ntext Data Columns

BUG: Error 7356 When Using SQL 7.0 to Select From a SQL 6.5 View

BUG: Error 924 When Cross-DB Query Run from DB in Single User

BUG: Error 924 When Cursor is Executed in DB in Single-User Mode

BUG: Error Browsing When 'All Caption' Name Matches Level Name

BUG: Error Creating Data Source Name (DSN) in OLAP Manager

BUG: Error Handler Not Called by RAISERROR if NOCOUNT Set ON

BUG: Error Message '8624 - Internal SQL Server Error'

BUG: Error Msg 2595 Running Spaceused syslogs,@updateusage=tr

BUG: Error Not Returned on Dbconvert Failure (Truncation)

BUG: Error When Inserting NULL into Timestamp with ANSI_NULLS

BUG: Error: 7109 While Processing TEXT Data in a DELETE Trigger

BUG: Errors 2714 and 267 on INSERT INTO Global Temp Table

BUG: Errors 603, 3313 and 3414 May Mark Database as Suspect

BUG: Errors When Creating View Using WITH CHECK OPTION in SEM

BUG: ESQL for C Precompiler /BIND Option Builds on SELECT

BUG: ESQL for C Precompiler /BIND Option Ignored

BUG: ESQL Precomp Generates #define, Causing Warning Message

BUG: ESQL-C Precompiler Generates Syntax Errors on Cursors

BUG: ESQL-C: #include Directives Can Cause Precompile Errors

BUG: ESQL-C: Divisor in Parentheses May Cause AV in NSQLPREP

BUG: ESQL-C: Error 'Division by Zero' During Precompilation

BUG: ESQL-C: Nested C Structures May Cause Precompile Errors

BUG: ESQL-C: Precompiler Doesn't Generate Correct #Line Number

BUG: ESQL: AV Using Void * for Fost Variable for Binary Datatype

BUG: ESQLC Unhandled AV in Sqlakw32.dll Connecting to SQL Server

BUG: Example of Sp_addtype Is Unclear in the Documentation

BUG: EXAMPLE8.C in Prog. Ref. Does Not Match Sample Program

BUG: Exceeding Max Error Value in BCP Can Give Unhandled AV

BUG: Exclusive Table Lock when Using Insert Select with ORDER BY

BUG: EXEC Long @string w/o Paran. Can Hang Server/Cause AV

BUG: Executing Stored Proc. w/ Cursor Fails with Perm. Violation

BUG: Executing Two or More xp_logevents Causes Server Hang

BUG: Execution of IS_MEMBER May Cause AV When Many Roles Exist

BUG: Execution of Non-Existent Procedure May Trap Server

BUG: Existing Connection Combo Box Displays Wrong Connection

BUG: Exiting the Upgrade Wizard During Validation Causes Errors

BUG: Extended Stored Proc Call May Generate a Thread AV

BUG: Extra

BUG: Extraneous 'go' Commands in Grouped Stored Proc Scripts

BUG: Extraneous Extent Locks Obtained During Data Modification

BUG: Extraneous Locks During UPDATE on Table w/

BUG: Fail and Break Out to UPDATE of a Cursor with WHERE Clause

BUG: Failed SQL Server RPC Call Results in Batch Termination

BUG: Fallback to Primary Server May Not Move All Databases Back

BUG: Fetch From Cursor on Stored Procedure May Cause 1203 Err

BUG: FETCH INTO Multiple Variables Sets Wrong Variable

BUG: Fetching from a Cursor with Existence Clause May Cause AV

BUG: FILLFACTOR on Published Table Makes Merge Replication Fail

BUG: Filtered Stored Procedures for Horizontal Partitioning

BUG: Float Data May Cause Data-Conversion Overflow in ISQL/w

BUG: FORCEPLAN Does Not Control Join Order in UPDATE Statement

BUG: French Client Sets Incorrect Registry Key for ANSI/OEM Conv

BUG: French version of SQL Server Writes SQL Performance Monitor

BUG: Full Text Search Fails w/ Unique Index on Multiple Columns

BUG: Fully Qualified Names Required for System SPs in SPs

BUG: Fully Qualified Table Names Causes dbcursoropen() to Hang

BUG: Function dbuse() Returns FAIL

BUG: Generating Scripts to Multiple Files May Yield Error 20524

BUG: Global WinNT Groups List Empty in French Security Manager

BUG: GPF When Expanding Stored Procedure Icon in SEM

BUG: Grant or Revoke Statements Fail When Used in an SP

BUG: Handled AV Running INSERT EXEC

BUG: Handler Function Prototypes Incorrect for C++

BUG: HDR Hangs Sending Decimal Data to SQL DateTime Column w BCP

BUG: Heap Memory Corruption and AV in kill_proc May Occur

BUG: Heavy Full Text Query Activity Results in Timeout Errors

BUG: Heterogeneous Query Showplan May Not Display Site Name

BUG: IDENTITY Out of Sync If Server Is Shut Down w/o Checkpoint

BUG: If RPC Is Used, SQL Server ODBC Driver Converts in Place

BUG: IF Statement with Two EXISTS Separated by OR Clause

BUG: IF UPDATE() Returns False for Col Ref'd by FK Constraint

BUG: IF UPDATED Returns TRUE in a Trigger

BUG: Immediate Updating Subscriber Builds Trigger Incorrectly

BUG: Import Wizard Fails if Excel File Open During Import/Export

BUG: Improper Load of Master Hangs SQL Server

BUG: IN Subquery Reformats and Is Slower Than an Equivalent Join

BUG: Incomplete Display of Some System Roles

BUG: Inconsistent Behavior with Global Temporary Tables

BUG: Inconsistent Timestamp Behavior in Stored Procedure

BUG: Incorrect dbgetuserdata Function Prototype

BUG: Incorrect Parameter Numbers Returned by srv_paramnumber()

BUG: Incorrect SqlState on Constraint Violation

BUG: Index Not Used on Temp Table Created Inside Procedure

BUG: Inefficient Access Plan When Using Index for ORDER BY

BUG: Insert .. Exec Fails in a Procedure with Error 702

BUG: INSERT EXECUTE Statement May Fail with Error 213

BUG: Insert Floppy Disk Error Running SQL Server on Alpha

BUG: Insert from Linked-Server to Table w/ BIT Field Causes AV

BUG: INSERT INTO EXECUTE and Xp_cmdshell May Cause Error 3601

BUG: INSERT INTO SELECT From Derived Table Causes 803 Error

BUG: Insert Text w/ More Than 1800 Bytes May Cause Error 7113

BUG: Insert Trigger that Issues a Rollback May Cause Error 1203

BUG: INSERT w/ SELECTs and UNION w/ Msg 512 Cause Handled AV

BUG: INSERT...EXEC of TEXT/IMAGE value may cause 702

BUG: INSERT/SELECT with Union into Table with Nullable DATETIME

BUG: Inserting Data into Temporary Table's Identity Column Fails

BUG: Inserting to a 255-byte String w/ Embedded quot

BUG: Inserts Can Cause Error Message 1203 to Occur

BUG: instdist.sql Script Fails From SEM on Alternate Pipe Name

BUG: Internal Query Proc. Err Msg 8630 Processing View w/ Union

BUG: International Settings Ignored

BUG: Invalid and Irrelevant TCP/IP Keepalive Registry Entries

BUG: Invalid Syntax on SQLNumResultCols After Update Proc

BUG: IP Address for OLAP Data Source Connection Property--

BUG: ISQL Fails with Mixed Security from a Trusted Domain User

BUG: ISQL Problems with PRINT in Stored Procedures

BUG: Isql.exe Fails to Execute a Script Generated by SEM

BUG: Joins Via Dynamic Cursor Execute Slower Than Other Cursors

BUG: KILL Fail to Terminate Orphan BCP Process on Banyan Vines

BUG: Large Number of Procedure Plans in Cache for Subprocedures

BUG: Large SQC Files That Contain Structures Cause NSQLPREP AV

BUG: LEFT OUTER JOIN Tables May Cause Handled Access Violation

BUG: Linked Table Shows Incorrect Field Size

BUG: LOAD HEADERONLY Does Not Report Spanned Dumps

BUG: LOAD HEADERONLY Does Not Report the Correct Size of Dumps

BUG: LOAD HEADERONLY Does Not Return @@rowcount

BUG: LOAD HEADERONLY from 4 mm DAT Fails with Various Errors

BUG: LOAD HEADERONLY from Tape Causes Unnamed Tape Message

BUG: Load Master DB Can Fail After Master.Dat is Rebuilt

BUG: Load Table May Fail If Created with Different ANSI_PADDING

BUG: Loading Database Dumps Spanning Tapes Fails

BUG: Locks Held Using Optimistic Concurrency w/ No Unique Index

BUG: Locks May Be Held Longer Than Necessary with Subqueries

BUG: Login/Logout Causes 'Max User Connections Connected' Error

BUG: LogReader Generates AV on DELETE/INSERT of Text Columns

BUG: Logreader Replicates a Combination of a Delete/Insert

BUG: Logreader Reports Timeout Error on Sp_repldone or Sp_replcm

BUG: Long Comments Can Break Object Code

BUG: Long Database Names Can Cause AV in the Distribution Task

BUG: Low LE Threshold Maximum Can Cause 1203, 216

BUG: Low Open Databases Value May Cause Logreader Failure

BUG: Mac ODBC App Via TCP/IP May Cause Connections to Hang

BUG: Many Failed Login Attempts Can Cause Error 17809

BUG: Many ISNULLs Within an Expression May Cause AV

BUG: Many Objects May Cause Error 703 in DBCC

BUG: Many UNIONs in One Query May Cause a 702 Error

BUG: Many WRITETEXT Calls Causes DB-Library Error 10005

BUG: Mapped Binary Data in ESQL-C Truncates Data After 0x00

BUG: Members of Server Role Setupadmin Cannot Add/Drop/Configure

BUG: Memory Can Be Reduced After Installing Replication

BUG: Memory Error During Bulk Load Not Rollback Last Batch

BUG: Memory Leak with Xp_sendmail Using Attachments

BUG: Merge Agent Fails During Synch of Rollup Subscriber

BUG: Merge Snapshot Fails 'Line 1: Incorrect syntax near ' ''

BUG: Merge Subscriptions w/ NOSYNC Option Show Inconsistent Data

BUG: Merge System Tables not Dropped When Restoring DB

BUG: Message 511 After Running Stored Procedure

BUG: Mips BCP Utility Gives Application Error w/o Password

BUG: Misleading Error Message About Ambiguous Table

BUG: Misleading Message 4613 When Trying to REVOKE Permission

BUG: Missing Log Device Causes Access Violation at Startup

BUG: Misspelled OLE DB DataSource Property Names in OLAP Help

BUG: Mmc.exe Application Error Closing Script Generation Dialog

BUG: Modifying SQL 6.5 Logreader on SQL 7.0 Distributor Fails

BUG: Modifying Tasks Containing Encrypted Text AVs on Win95

BUG: Money Values Incorrectly Use Thousand Separator

BUG: MS DTC Is Removed If SQL Server Registry Rebuild Is Run

BUG: MS-DOS Date Order Localization Might Not Work Properly

BUG: MSDB Database May Not Be Created During Installation

BUG: MSDTC Fails to Start if Different Drives/Paths Are Chosen

BUG: MSG 15417 Trying to Change Compatibility Level of Master DB

BUG: Msg 16916 and AV If Cursor Is Declared but Not Opened

BUG: Msg 170 While Creating View with * and an Expression

BUG: Msg 229 on UPDATETEXT If Source Table Lacks Permission

BUG: Msg 257 When Inserting NULL values by RPC

BUG: Msg 924 When Running Stored Procedure

BUG: Multi-Protocol Connection Fails with SQL 6.5

BUG: Multi-protocol Netlib Causes Event ID 322

BUG: Multiple Calls to bcp_colfmt Fail to Free Memory

BUG: Multiple Cursors Inside Explicit Trans. Can Cause AV

BUG: Multiple Result Set Reported When GROUP BY Clause Is Used

BUG: Multiple TDS Packets Cause 'Bad Token' Error for DBLIB

BUG: NC Index Range Scans Generate Excessive Data Page Reads

BUG: Negative Zero on Some Multiplications of Decimal or Numeric

BUG: Nested Stored Procedures with same owner fail with error

BUG: Nested STUFF() Functions Return NULL

BUG: NIK Fails to Clean Up Orphaned Connections

BUG: No List of AutoStart Stored Procedures in SP_HELPSTARTUP

BUG: No Mechanism for Cleaning Up Merge System Tables

BUG: No Output from BCP if Using Format File to Reorder Columns

BUG: NOCHECK Does Not Allow Modifications to an Fkey Reference

BUG: Non-Indexed Joins May Skip Optimizer's Reformatting Step

BUG: Non-SA CmdExec Task Run on Domain Controller Causes Error

BUG: Not All Database Options Transfer from Model to New DB

BUG: NSQLPREP Substitutes DBCS Object Name with a Null String

BUG: NULL Padding Behavior Different on Subscriber

BUG: Null Parameter for DTS Lookup Causes MMC to Exit

BUG: NULLIF or COALESCE May Generate Access Violation

BUG: Object Manager May Not Display User ID in Lists of Users

BUG: Object Manager Not List Names That Start with MS

BUG: Object Scripting Tool Places a TEXTIMAGE_ON Clause

BUG: OBJECT2.SQL May Fail to Execute the Last Statement

BUG: Objects Created and Stored in DTS Global Variables Released

BUG: ODBC Driver Misses ANSItoOEM with Server Cursors

BUG: ODBC Fails to Obtain the Return Parameter of a Stored Proc.

BUG: ODBC TDS Error Calling Procedure with SQLTrace.

BUG: ODS App. GP Fault when SQL Admin Runs Full DB Properties

BUG: OLAP Manager Cube Browser Unable to Display Data

BUG: OLAP Manager: Error Processing Using Integrated Security

BUG: OLAP Manager: Unable to Select Correct Data Folder

BUG: OLAP Repository Migration Wizard Fails If Empty Repository

BUG: OLAP Services Install in Root Causes Remote Connect Error

BUG: OLAP Setup Fails on Windows NT Server Enterprise Edition

BUG: OLAP: 'Object Does not exist' Error

BUG: Opening a Long-Running View from SQL Server EM ODBC Timeout

BUG: Opening Cursor on a Local Temp Table May Fail with Msg 16

BUG: Opening Cursor When Using ISNULL() Function May Cause AV

BUG: Optimistic Concurrency Error with DYNAMIC Cursors

BUG: Optimizer Chooses Inefficient Clustered Index on Query

BUG: Optimizer Chooses Table Scan Instead of Index Seek

BUG: Optimizer May Ignore Index on Decimal or Numeric Column

BUG: Optimizer May Not Choose Correct Index

BUG: Optimizer Picks Table Scan for IF EXISTS Subquery w/BETWEEN

BUG: ORDER BY and DISTINCT Do Not Eliminate Duplicate Rows

BUG: ORDER BY Queries May Truncate Trailing Spaces of Columns

BUG: Orphaned Connection Processes Are Not Cleared

BUG: Orphaned Temporary Tables After Error 1105 in Tempdb

BUG: Other Users Can See Your Registered SQL Servers in SQL EM

BUG: Outer Join VIEW with UNION ALL May Fail with AV

BUG: Ownership Problem Across Databases When SA Is the DBO

BUG: Package Execution Can Fail if Target Table Has an Identity

BUG: Page Fault Statement in Admin Companion Is Incorrect

BUG: Page Faults when Performance Monitor Counters Enabled

BUG: Parallel Sort May Be Slower Than Non-Parallel Sort

BUG: Pass Invalid LOGINREC * to dbopen() May GP Fault Server

BUG: Permission Denied When USE TEMPDB Issued from SQL

BUG: Permissions Granted Improperly on New Columns

BUG: Permissions Not Changed Correctly Using SQL Enterprise Mgr.

BUG: Permissions Problem with Stored Procedure and Table

BUG: Poor Performance with Inner Join with Multiple LIKE Clauses

BUG: Possible Handled AV w/ Sub-query Using NOT IN and '

BUG: Precision and Scale Change with SUM or AVG Functions

BUG: Premature Query Timeout Under Dbmssoc3.dll

BUG: Primary Key Can Be Dropped if Table is Published

BUG: Primary Key Can Incorrectly Include a Nullable Column

BUG: Print Database Properties from SQL Admin Mixes Results

BUG: Problem Changing Account Information for SQL Cluster

BUG: Problem Connecting to an Unnamed Server with Sqlmaint.exe

BUG: Problem Using 'Create Table' When Transaction Log Is Full

BUG: Problem with Selecting Text Data into a Local Char or Var

BUG: Problems Inserting NULL Text Data Using BCP API

BUG: Problems Opening Cursor on Global Temporary Table

BUG: Processing a Cube Fails Without a Specific Error Message

BUG: Processing of a Cube May Fail with Error 210

BUG: Programmer's Toolkit Setup Requires 256 Colors

BUG: QA: No Exec Plan for DECLARE CURSOR

BUG: Qualifying Table Name in Query Results in More I/O Op.

BUG: Query Against Sysprocesses May Fail with Message 1105

BUG: Query UPDATE Fails with IGNORE_DUP_KEY Set

BUG: Query w/ CUBE and Duplicate Column in GROUP BY Gen. AV

BUG: Query w/ Group by All Can Take Too Long to Complete

BUG: Query Window Focus Inactivates 'Generate Scripts' Option

BUG: Query with Join in Subselect May Cause Handled Exception

BUG: Query with Joins, Aggregate, Concatenation May Cause AV

BUG: Rebuild Master Fails if Setup Cannot Connect to SQL Server

BUG: Recreating a Table Causes sysdepends to Become Invalid

BUG: Ref. Constr. Are Not Getting Applied to Filtered Subscr.

BUG: Reformat w/ TEXT Col Can Cause Errors 7114, 813, 814, 806

BUG: RegistryRebuild Option of Setup Is Not Documented

BUG: Regr: Msg 515 When Doing UPDATE w/ISNULL, Agg.

BUG: Remote Setup Removes \sql\binn;\sql\dll From Path

BUG: Remote Upgrade Fails if MASTER.DAT Is on Different Drive

BUG: Remote Upgrade Fails to Generate SQL Server 6.5 Icons

BUG: Remote Upgrade Generates Wrong Novell Bindery Service Name

BUG: Removing Upgraded SQL Server 6.5 Leaves Program Group

BUG: Rename Column Causes Error 207 After Trigger Re-resolution

BUG: Repeated Deadlocks May Cause Error 925

BUG: Repeated Fetch With Dynamic Cursors and OR Clause

BUG: Repl Cleanup Does Not Remove MSjobs/MSjob_commands Info

BUG: Repl w/ Immediate-Updating Subscribers Fails w/ Err 21082

BUG: Restore From DLT Tape Fails w/ Errors 603 or 3104

BUG: Retention Change Not Updated on Cleanup Task

BUG: Right Align Numerics Has No Effect on the Grid Result

BUG: ROLAP Cube Processing Fails w/ Big Numbers in Measures Col.

BUG: ROUND Function with NULL Length Returns TDS Error

BUG: RPC from VB Application May Fail with Error 8006

BUG: RPC May Cause SQL Server to Generate Access Violation

BUG: RPC w/ Execute That Changes Database Causes Error 7222

BUG: RPC with Execute that Changes Database Causes Error 7222

BUG: Running SQL Trace with RPC Calls and sp_OA May Cause AV

BUG: Running SQLDIAG.EXE Produces an Internal Error

BUG: S1093 Error on SQLDescribeParam of System Stored Procedure

BUG: Sample Code VBADOSimple on SQL Server 7.0 CD has Error

BUG: Scheduled Backup Near Midnight Does Not Occur

BUG: Scheduled Table Refresh May Fail Using Truncate Option

BUG: Scheduled Tape Dumps Fail w/ Error Unknown

BUG: Schema Generate Does Not Include NOT NULL on Some Columns

BUG: Schema Generate Does Not Include Statement Permissions

BUG: Schema Generate Does Not Produce Aliases

BUG: SCM.EXE Command Line Arguments Not Documented in SQL 7 BOL

BUG: Sec. Mgr. Adds Wrong Grp When Local/Global Have Same Name

BUG: Security Information Not Persistent for Conn. Obj.

BUG: Security Manager Fails to Expand User Group

BUG: Security Manager Fails With Error 1332 Granting Logins

BUG: Security Manager May Incorrectly Identify Orphans

BUG: Security Manager Not Remove Aliases When Revoking Logins

BUG: Select From a View Involving Outer Joins May Cause AV

BUG: SELECT from More Than 224 Columns Fails w/Column Permission

BUG: SELECT from Multiple Unjoined Tables Can Cause AV

BUG: Select from View with ANSI-Style Joins Causes Error 403

BUG: SELECT from View with UNION ALL and Aggregate Function AVs

BUG: Select Into Creates Table w/ Incorrect Precision

BUG: SELECT INTO Does Not Raise Error with No Column Name

BUG: SELECT INTO from a View May Cause Extra Error Messages

BUG: SELECT INTO Including UNION with Trace Flag 5302 Causes Acc

BUG: SELECT INTO with Fixed Memory May Cause Err 802 and 17803

BUG: SELECT INTO with Many UNION Clauses Returns Error 702

BUG: SELECT on Cross-Database Views Causes Error 702

BUG: Select Query with GROUP BY and Outer Join Causes Handled Ac

BUG: SELECT Statements With UNION May Cause Error 8618

BUG: Select Using 'or' From View Defined w/ '

BUG: Select w/ ANSI Joins Against View w/ Union Operator Fails

BUG: SELECT w/ Correlated Subquery Can Result in Error 403

BUG: SELECT w/ UNION ALL of Two Views Causes GPF in Sqlsrv32.dll

BUG: SELECT with CASE Can Cause Parser Error 403

BUG: SELECT with Many Columns Causes Handled AV in Optimizer

BUG: SELECT with More than 125 SUM Columns Can GP Fault Server

BUG: Select/Into Another Database Changes Timestamp Datatype

BUG: SEM 7.0 Login Failed Msg When Editing or Running DTS

BUG: SEM Allows You to Subscribe Without Specifying DB Name

BUG: SEM Does Not Allow User of Database That is DBO Use Only

BUG: SEM Does Not Display Error When Changing Config Values

BUG: SEM Encounters Unhandled Exception When Creating New Task

BUG: SEM Fails to Reset DB Option to Single User If

BUG: SEM Generates SQL-DMO Error for DBO Updating Permissions

BUG: SEM Generates SQL-DMO Error When Adding an ODBC Subscriber

BUG: SEM Incorrectly Reports 4601 on Same-Named Objects

BUG: SEM May AV When Changing Size of a Pane in Design View

BUG: SEM Says Sync'ed/Auto With NO SYNC Option in Sync Task

BUG: SEM script generation order not proper

BUG: SEM Scripts Are Null for Niladic Functs. Used as Defaults

BUG: SEM Scripts of User Table Permissions Do Not Have Owner

BUG: SEM Unusable If Database Is Created with Quoted Identifier

BUG: SEM/SQL-DMO Abnormally Terminates w/ Large Objects

BUG: SEM: Incorrect Space Used/Available in Graphical Display

BUG: SEM: Remove/Add Primary Key w/ Manage Tables Dialog Box

BUG: SEM: Saving Scripting File Behaves Differently on Alpha

BUG: Server Side Cursor Called Through RPC Can Cause Error 925

BUG: Server to Server RPC Fails Using COMPUTE and COMPUTE BY

BUG: Service Pack 1 Setup Requires Default Named-Pipe Name

BUG: Service Pack 5 and 5a Setup May Fail Depending on SQLPath

BUG: Service Pack Install Fails If QUOTED_IDENTIFIER Option On

BUG: Set FIPS_FLAGGER Fails to Warn of SELECT Extensions

BUG: Set Query Timeout Fails w/ Named Pipes, TCP/IP, IPX/SPX

BUG: Setup Fails with Insufficient Space Message on Large Drives

BUG: Setup on Windows 2000 Fails Through Terminal Client

BUG: SetupAdmin Member Not Allowed to Add Linked Server in SEM

BUG: SH_PAGE Locks When Executing Sproc w/READ UNCOMMITTED

BUG: Show Distribution Under Manage Indexes Menu Hangs SEM

BUG: Showplan Does Not Show Information About Worktables

BUG: SIGN( ) on Null Values Can Cause an Access Violation

BUG: Skipped Cols in Format File Can Cause Unhandled AV in BCP

BUG: Slow Performance Using Cursor Positioned Update If No PK

BUG: Slow Synchronization on New Subscriptions

BUG: Slow TCP/IP Connection to SQL Server from NT

BUG: Snapshot Replication Requires Primary Key Constraint

BUG: SNMP Agent Message Causes Event ID 322

BUG: Some Calculated Members Do Not Work on Asynchronous Queries

BUG: Sort Pages Option of 511 May Cause 702 Error on Non-Intel

BUG: sp_addsubscription Fails with Error 14096 When Subscribing

BUG: sp_addtype Does Not Allow Owner Qualified Object Names

BUG: sp_articleview May Generate an Arithmetic Overflow

BUG: Sp_certify_removable Db_name, Auto Fails If Case Sensitive

BUG: Sp_columns Gives Incorrect Precision for View Substring

BUG: sp_create_removeable Fails with Error 5104

BUG: Sp_cursor: The Parameter 'Table' Is Invalid w/Long DB Names

BUG: Sp_Cursoropen Returns Error for a UNION Query

BUG: SP_Depends Does Not List Triggers

BUG: sp_dropdevice Gives Redundant and Incorrect Information

BUG: sp_droppublisher Does Not Clear 'pub' Server Option

BUG: Sp_help on a User-Defined varbinary Data Type

BUG: sp_helpindex Does Not Identify UNIQUE KEY Correctly

BUG: sp_helprotect May Give Redundant Information

BUG: sp_MSbackup_now Fails on Scheduled Dumps to Same Device

BUG: Sp_OA Procedures May Produce 'Bad Variable Type' Error

BUG: sp_OAMethod Does Not Connect If Parameter Is a NULL Value

BUG: Sp_processmail Returns Datatype Error Message

BUG: sp_renamedb Does Not Update dbname Column in Syslogins

BUG: Sp_replcmds Does Not Read the Replicated Command

BUG: sp_sqlexec with Two Selects Causes Bad Token Error

BUG: SP2 Regr:Many-Column SELECT, JOINs, ORDER BY May Disconnect

BUG: SP5 Setup Fails if Folder Containing Setup.exe Has a Space

BUG: Space Used Not Accurate After Text/Image Inserts

BUG: SPs w/ Aggregate Functions in HAVING Clause can Cause AVs

BUG: SQL 6.5 DMO GetItemByOrd And GetItemByName Cause 4K Leak

BUG: SQL 6.5 Security Manager Incorrectly Maps Users

BUG: SQL 6.5 SP5 Setup Fails if Setup Path Has a DBCS Character

BUG: SQL 7.0 Desktop Ed. Install on Windows 95/98 Fails

BUG: SQL Admin GP Faults Opening Scripts Larger than 100K

BUG: SQL Admin Menu Database Dump Fails in Mixed Security

BUG: SQL Admin Not Remove Aliases When Dropping a System Login

BUG: SQL Admin Query Window Does Not Timeout as Configured

BUG: SQL Admin Reports SQL Monitor Not Started

BUG: SQL Admin Unable to Load Tape Dump with Different Names

BUG: SQL Admin. Displays Partial DB List if rowcount Is Active

BUG: SQL Admin. Will Not Drop Logins w/ Single User Databases

BUG: SQL Administrator

BUG: SQL Administrator Can Cause Access Violation on Tape Dump

BUG: SQL Cluster Setup Fails When TEMPDB in RAM

BUG: SQL Cluster Setup Wizard Fails When Path Contains Spaces

BUG: SQL Counters Not Available Under Integrated Security

BUG: SQL Enterprise Manager AVs on Copy of Large SQL Script

BUG: SQL Enterprise Manager Displays Negative or 0 Database Size

BUG: SQL Enterprise Manager Has Invalid Configuration Option

BUG: SQL Enterprise Manager May Show Incorrect Permissions

BUG: SQL Enterprise Mgr Limits Mirror Name To 29 Characters

BUG: SQL Exec Fills Event Log w/ Errors After Dr. Watson Entry

BUG: SQL Executive Alerts Using SNMP Traps Stop Working

BUG: SQL Executive Does Not Recognize the Date 2/29/2000

BUG: SQL Monitor Parameters and NETSQL.EXE

BUG: SQL Object Manager Not Allow Foreign Key on Same Table

BUG: SQL Security Mgr. Grants Privileges for Wrong Domain Grps

BUG: SQL Server 6.5 Message 5161 has Severity 1

BUG: SQL Server Does Not Start with Five Missing Mirror Files

BUG: SQL Server Err 'Specified column precision 38 is ...'

BUG: SQL Server May Fail to Listen On DecNet

BUG: SQL Server May Stop Without Any Information by BULK INSERT

BUG: SQL Server Perf. Counters Don't Work on WinNT Server 4.0

BUG: SQL Server PTK Setup Fails with

BUG: SQL Server Setup Does Not Allow Install to Drives Y or Z

BUG: SQL Server Setup May Stop Responding on a Very Fast Drive

BUG: SQL Server Web Assistant Causes Stack Overflow

BUG: SQL Server's ODBC Function SQLConnect is Not Thread Safe

BUG: SQL Service Manager Is Monochrome When Colors Are

BUG: SQL Setup Doesn't Change Security and Network Support w/SVS

BUG: SQL Setup Fails If Non-NIC Hardware Profile Is Used

BUG: SQL Transfer Manager Does Not Transfer Aliases

BUG: SQL Transfer Manager Error with DBO Login

BUG: SQL-DMO ::GetMemUsage Method Returns Empty String

BUG: SQL-DMO BulkCopy Object IncludeIdentityValues Property Fail

BUG: SQL-DMO Call GetObjectByName May Cause GPF Under VBA

BUG: SQL-DMO Does Not Create an Identity Prop on Dec/Num Cols

BUG: SQL-DMO Scripting Does Not Add Identity Property

BUG: SQL-DMO's ::ImportData Method Does Not Function Properly

BUG: SQL-DMO: ExportData Method Causes VB Run-time Error

BUG: SQL_COPT_SS_PERF_QUERY_INTERVAL Is in Seconds

BUG: SQLColAttribute Reports Base Type on Aggregate Function

BUG: sqlcursorfetch AVs on Select w/ 'Order By,' No Join

BUG: SQLCursorFetch Generates DB-Lib Error 1101

BUG: SQLDMO - .Login and .Password Properties are Ignored

BUG: SQLDMO - Query Analyzer May Fail to Connect

BUG: SQLExec Account

BUG: SQLExecutive Fills Win NT App Event Log w/ Event ID 108

BUG: SQLExecutive, CmdExec Task Output Is Not Properly Reported

BUG: SQLMaint May Get 'Error: The System Cannot Find the Path'

BUG: Sqlmaint.exe Command Line Parameters

BUG: SQLMonitor Might Cause Access Violation As a Console App

BUG: SQLOLE_STARTSRV_TYPE Datatypes Fail When Using StartMode

BUG: SQLPrepare SQL_ERROR If SQL_AUTOCOMIT_OFF and SHOWPLAN ON

BUG: SQLRowCount Does Not Return Number of Affected Rows in SP

BUG: SqlRpcParam Fails for Some Binary Values

BUG: SqlRpcParam%() Failed with 'YYYY/MM/DD HH:MM' Parameter

BUG: SQLServerAgent May Not Respond to CTRL+C Correctly

BUG: SQLSetPos(SQL_ADD) Error 2750 on Keyset Cursor

BUG: SQLState 07006 if Procedure Returns an Output Parameter

BUG: srv_paramset Not Return Multiple Ouput Parameters in XP

BUG: srv_pfield Not Return Null if Field Length Is 30 Char.

BUG: srv_pfield Returns Unprintable String for SRV_LIBVERS

BUG: srv_revert_to_self Does Not Revert Multi-Protocol Connects

BUG: St. Proc. Behavior Inconsistent When Grouping by a Bit Col.

BUG: Stack Overflow Running CHECKDB Against DB With Many Objects

BUG: Startup of MS DTC Admin Components Fails on Client

BUG: Startup Procedure Fails Selecting TEXT/IMAGE Data

BUG: Startup Stored Procedure Using sp_OACreate Fails

BUG: Statistics Are Printed Twice with Statistics Time On

BUG: Statistics I/O Always Returns 0 for Total Writes

BUG: Stored Proc Can Cause Thread-Level AV After Dump/Load

BUG: Stored Proc Can Fail w/ Msg 1203 Using READ UNCOMMITTED

BUG: Stored Proc Insert Into View May Cause AV or CPU Spin

BUG: Stored Proc Script Generation Has 'GO' in Middle

BUG: Stored Proc. Generates Access Violation with Bound Rule

BUG: Stored Proc. Generates Erroneous 515 Errors w/ Bound Rule

BUG: Stored Procedure Execution Fails with Msg 202

BUG: Stored Procedure Holds EX_lock on a Table

BUG: Stored Procedure Is Truncated in Enterprise Manager

BUG: Stored Procedure May Fail with Error 264

BUG: Stored Procedure Names Starting with 'go' Cause Syntax Erro

BUG: Stored Procedure Remains After Deleting Web Wizard File

BUG: Stored Procedure Remains After Execution by Sp_makewebtask

BUG: Stored Procedure Tree May Grow After Restarting Server

BUG: Stored Procedure with Multiple Cursors May Cause Error 2805

BUG: STR() Inconsistent with Exact Numeric Data

BUG: Strings Returned by srv_symbol Have \r\n at the End

BUG: Subquery for Char Non-null Col Returns Less Rows

BUG: Subquery in IN Clause with DISTINCT and JOINs May Cause AV

BUG: SUM in Subquery Has NULL Precision and Scale

BUG: Syntax Error on SQLNumResultCols on GROUP BY in Subquery

BUG: Syntax Error Using ESQLC DESCRIBE and SQLDA

BUG: Syscolumns.prec Has Incorrect Value For Some Integers

BUG: Sysprocedures Deadlocks Using Views After Database Load

BUG: System SPs Give Errors if 'Select Into' False for Tempdb

BUG: T-SQL Tasks Do Not Run After Restarting SQL Server

BUG: Table Creation Deadlocks in Tempdb Leave Stray Tables

BUG: Table Designer 'Table and Index Properties' Button Fails

BUG: Table Designer Cannot Create a Bit Column Which Allows NULL

BUG: Table Designer Does Not Allow Apostrophe in Column Name

BUG: Table Designer Error with Single Quote in a Table Name

BUG: Table Designer Gives an Error with Quotes in a Column Name

BUG: Table Names Enclosed in Double Quotes When Transferred

BUG: Table Populated With Zeros in the Identity Column

BUG: Table Transfer Fails with Msg That Table Does Not Exist

BUG: Tablealias.Column in FOR UPDATE Causes Error 16928

BUG: Tables Not Displayed in SEM After Backing Up Table

BUG: Tape DUMP/LOAD Timeouts Have No Effect

BUG: Tape Problem Results in Access Violation with Alt/Cr DB

BUG: Task Management in EntMan Uses Case Sensitive Login

BUG: Tasks Scheduled for Every N Days Runs Daily

BUG: Tasks Scheduled Weekly Execute Out of Schedule

BUG: Test Button Fails if DTS Transform Has No Destination Cols.

BUG: Text And Image Can Be Parameters for Stored Procedures

BUG: TEXT Columns Truncated to 127 Characters in Query Window

BUG: The Replication Initialize Method Causes Handle Leak

BUG: Timeout Setting Ignored with Keyset-Driven Server Cursor

BUG: Trans Mgr Gives Errors When St Proc Has Only 1 Dependency

BUG: Transfer from Sybase System10 to SQL Server 6.5

BUG: Transfer Manager Does Not Transfer Object Permissions

BUG: Transfer Manager Encrypts Passwords Twice

BUG: Transfer Manager May Generate Scripts for Check Constraints

BUG: Transfer Manager May Not Transfer Some Logins

BUG: Trusted RPCs from NT to OS/2 Fail with Error 7221

BUG: UI Problems Running SQL Server on Korean Windows NT 3.51

BUG: Unable to Drop a Constraint with a Period in the Name

BUG: Unable to Reload Master DB After Upgrading SQL Server

BUG: Undetected Deadlock on System Catalogs During Dump

BUG: Unhandled AV in BCP Using -e Option and Bad Import Data

BUG: Unhandled AV w/ User Connections Configured

BUG: Unhandled AV with Executive If Cmdexec Output Format Char

BUG: Unhandled Exception in SQL Server Using Keyset Cursors

BUG: Unhandled Exception w/Executive If Return Code Not in Range

BUG: Uninstall Does Not Remove All Replication Files

BUG: Uninstalling SQL 6.5 After Upgrade to 7.0 Removes 7.0 Files

BUG: UNION with Local Variables GP Faults Server

BUG: Unsuccessfully Renamed User Table Shows in SEM

BUG: UPDATE Causes 306

BUG: Update Fails Through a View but the Column Has Permission

BUG: Update of Real with Float May Cause EXCEPTION_FLT_UNDERFLOW

BUG: UPDATE of Table Column with FK Constraint Fails w/ Msg 8623

BUG: Update of Text Field Using CASE Can Generate AV

BUG: UPDATE on Cursor Without Unique Index Fails w/ Msg 16934

BUG: Update on View to Multiple Rows in Fetch Buffer Fails

BUG: Update Statement Conflicts with Foreign Key Constraint

BUG: Update Syntax Allows Ambiguous Tablenames/Aliases

BUG: Update to View with Column Name Alias Fails Using Cursor

BUG: UPDATE to View with Cursor May Cause Handled AV

BUG: UPDATE Using Aggregate and Arithmetic Operator Causes AV

BUG: Update Using Subquery with Aggregate Functions

BUG: Upgrade Fails if Not Enough Space on Master for Tempdb

BUG: Upgrade Fails if SQL Server Pipe Is Not Set to Default

BUG: Upgrade Fails on Server with Suspect Database

BUG: Upgrade/Install Fails if Model DB is Larger Than Msdb

BUG: Use

BUG: Use of Sp_dboption by an Aliased DBO Fails with Error 15244

BUG: User's Role Not Updated Instantly in Multiple Sessions

BUG: User-defined Comments May Cause Syn Errors in Obj Scripts

BUG: Using Col Name Input to index_col Causes Alignment Fault

BUG: Using Defaults Within a Trigger Results in Access Violation

BUG: Using Multi Protocol Connections Elevate SQL Thread Counts

BUG: Using PINTABLE on SYSOBJECTS May Cause Memory Starvation

BUG: Using SEM to Change Security Options Changes Space Syntax

BUG: Using Subquery on MIPS Can Cause Thread Level AV

BUG: Using Table Manager to Add Columns Unbinds Defaults

BUG: Variable in Cursor Declaration Can Cause Client AV

BUG: VBDSOWriteEnableCube: Debug Assertion Caused by a Data Type

BUG: Vines Clients Unresponsive When Querying ODS Apps

BUG: Vsrvsvc.exe Causes Exception If Registry Keys Are Missing

BUG: Vsrvsvc.exe Causes Memory Exception on SMS Helper Servers

BUG: W3DBVER Generates Errors in Debug Windows 3.1

BUG: Web Assistant Stored Procedure Requires an Output Parameter

BUG: Web Assistant: Can Only Save File with .sql Extension

BUG: Weekly Tasks May Fail to Run on the 1st Day of the Month

BUG: Weekly Tasks May Ignore Scheduled Interval

BUG: Win16 DB-Library DLL May Incorrectly Load NWIPXSPX.DLL

BUG: WITH RECOMPILE Not Working for Temporary Tables

BUG: Wrong Error# Trying to Connect Client to Paused SQL Svr

BUG: Wrong Synchronization Status Displayed

BUG: XferMgr Does Not Preserve Nullability of User-Defined Data

BUG: xp_findnextmsg Followed by xp_readmail May Cause Error 3590

BUG: Xp_grantlogin Has a Memory Leak

BUG: Xp_logininfo Returns Error 8198

BUG: xp_sendmail Causes 17969 Error

BUG: Xp_sendmail Sends Text Data in 4 KB Chunks

BUG: xp_sendmail With @query Leaves Temporary Files on Server

BUG: Xp_sendmail with Large Query Results Causes Error 35909

BUG: Xp_sendmail with Large Row Results May Cause Error 35909

BUG: Yield Problems with Win16 Multiprotocol Net-Library

BUG: Zero May Be Negative, Depending on the Numeric Scale

BUG:8623 Err w/ INSERT-SELECT if Nullable Clustered Keys not Ref

BUG:After ALTER TABLE to Add Identity Col, type_name Incorrect

BUG:AutoTranslate, UseProcForPrepare

BUG:Creating New Database User from EM May Fail with Error 16916

BUG:Cube Metadata Does Not Indicate Cube Needs to Be Reprocessed

BUG:DTC Commit/Abort Operation may Leave Suspended Worker Thread

BUG:DTS:Preview Shows Col. Headers as Data if Invoked Many Times

BUG:Immediate Updating Subscriber May Fail if Text Col Before PK

BUG:Incorrect Error Messages from DTS Addin when Processing Cube

BUG:LogReader Can Fail to Insert Jobs if Sync Task is Running

BUG:Optimizer Uses Scan w/ Multiple OR Clauses on Composite Indx

BUG:Part of Defined Check Constraint May Not Be Visible in SEM

BUG:Perfmon Errs Logged in Event Log when SQL Server Not Running

BUG:SBS 4.5 Installs of SQL Server 7.0 do not Install Repl. DLLs

BUG:SEM Client Stops When Copying Preview Generate Sql Scripts

BUG:SQLDMO:Invalid DBCC Command Occurs w/ SQLDMOShrink_EmptyFile

BUG:Structural Changes to Shared Dimension Fail to Write-Disable

BUG:Table-Level Default Constraint in CREATE TABLE Gives Error

BUG:Upgrade Wizard Fails w/ 'Backup 6.x Devices - phase II' Err

BUG:Users Cannot Access OLAP Cube from Clients After SP1 Install

Cannot Install Site Server 3.0 on SQL Server 6.5 Enterprise...

CnPool.exe Test Connection Pooling with Tempdb Objects

DOC: Cannot Call a Stored Procedure to Populate a Local Cube

DOCBUG: Mode Value Incorrect in Unattended Installation Script

DOCBUG: Nested SPs Can Use Temp Tables Created by Parent

English Query Error When Importing Tables with GUID

FIX: 'IF UPDATE' Functionality Broken in SQL Server 6.5 SP5, 5a

FIX: BCP IN w/ Format File Into NUMERIC/DECIMAL Column Fails

FIX: 'CREATE INDEX' in Form Causes ASC or DESC to be Removed

FIX: 'Out of Memory' Error with Bulk Insert

FIX: #Deleted After Microsoft Access Sorts a SQL Server Table

FIX: 'Load Tran' May Cause 806, 605, 2620, or 6902 with IRL on

FIX: 'Unspecified Error' Message Returns Placing a NULL in a Col

FIX: @@IDENTITY Returns NULL If Trigger Inserts into Tbl w/o ID

FIX: @@language Value Can Be Truncated After Changing Value

FIX: 100% CPU Spin Opening Cursor on a RECOMPILE proc..

FIX: 1108 Errors with Heavy Tempdb Activity

FIX: 1203 If Attentions During Maintenance to Nonclustered Index

FIX: 16-bit TCP/IP Fails to Connect With Long DNS Names

FIX: 16933 Error on View Updated Through Server Cursor

FIX: 702 Error on Update with Over 132 ANDs

FIX: A Cursor in a St. Procedure Can Cause an Access Violation

FIX: A Derived Table in the Group By Clause Causes Handled AV

FIX: A Derived Table Using a Group By May Cause Error 8158

FIX: A Full Outer Join with the Same Table May Cause an AV

FIX: A Join Returning a NULL in a Smallint Column May Cause AV

FIX: A SELECT with a Large GROUP BY Clause May Return Error 614

FIX: A Stored Procedure or Trigger May Cause Error 707 or an AV

FIX: A View With an Outer Join Can Cause An Access Violation

FIX: Access to TEXT Column of Temp Table Inside SP May Cause AV

FIX: Access Violation During the Load of a Read-Only Database

FIX: Access Violation if Fully Qualified View Name Is Large

FIX: Access Violation in a UNION Operation on a View with a NOT

FIX: Access Violation May Occur During a LOAD TRANSACTION

FIX: Access Violation may Occur with BCP when Skipping a Column

FIX: Access Violation on SELECT Statement with UNION ALL

FIX: Access Violation Selecting Linked Table

FIX: Access Violation Under High Cursor Stress

FIX: Access Violation When Using UNIONs in Transact-SQL Cursors

FIX: Access Violation with Extra SELECT in Aggregate Function

FIX: Access Violation With Natural ANSI Join with View

FIX: Access Violation with Some Cursors on Derived Table

FIX: Add Constraint Causes Identity-Column Inserts to Fail

FIX: Add New Task in Task Manager Does Not Allow Date 2/29/2000

FIX: Adding Database Files During Upgrade May Cause Errors

FIX: Adding Merge Subscription Fails with Error 8115

FIX: Address Book in Send Mail Task Adds Only First Address

FIX: Alpha: AVs When Executing Query Plans the First Time

FIX: Alpha: SELECT INTO with Kills Can Cause Process Hangs

FIX: ALTER TABLE ADD PK May Take a Long Time Even With No Data

FIX: ALTER TABLE Allows Nulls in PRIMARY KEY

FIX: An INSERT SELECT into a Table with IRL May Cause Error 818

FIX: ANSI Join in Exists Clause Causes Parser Error 403

FIX: ANSI SQL JOIN May Fail With AV Joining VIEW With Table

FIX: ANSI Style Outer Join Can Fail w/ Error #301

FIX: Attempt to Delete a Row May Raise Error 631

FIX: Attentions During Reformatting May Cause Err 1108 in Tempdb

FIX: Auto-Start Stored Procedure w/ WAITFOR Causes 100% CPU Use

FIX: Automatic SQL Cluster Failover Doesn't Work w/WinNT 4.0 SP4

FIX: AV Assigning Decimal from VIEW to OUTPUT Parameter

FIX: AV Caused by View with Distinct and Correlated Subquery

FIX: AV Creating View With ANSI JOINS

FIX: AV Declaring a Cursor Involving Conversion to Bit

FIX: AV Error Using Temp Table and Cursor in Stored Procedure

FIX: AV from View with Group By and Incorrect Column List

FIX: AV if 4 or More Correlated Subqueries with Self-Join

FIX: AV If Extended Cursor Opens SP Without Execute Permission

FIX: AV if Subquery GROUP BY and HAVING with ROUND()

FIX: AV in Cursoropen() If Using 'WHERE CURRENT OF' and Cancel

FIX: AV in Query w/Subselect on View w/JOIN and FORCEPLAN Is On

FIX: AV in Update Mode When Script Is Run Twice

FIX: AV Joining a Table with a Rowsize Over 1,962 Bytes

FIX: AV on Cursor Declare Ssing Select on View w/ ORDER BY

FIX: AV on INSERT of UNIONed SELECTs to Table With DEFAULTs

FIX: AV on Stored Procedure Inserting or Updating Table w/ Rules

FIX: AV or Error 632 on Update w/ Select Count(distinct) Subqu

FIX: AV Querying a View w/ CASE WHEN EXISTS and FORCEPLAN Is ON

FIX: AV Selecting from VIEW with DISTINCT and Join

FIX: AV Selecting View with Aggregate Subquery and Outer Join

FIX: AV When Creating Reformat Plan of SP Containing Join

FIX: AV With Outer Join and Convert to Char Column

FIX: Bad Token or AV If Sp_cursoropen After Dropping Index

FIX: BCP Import with Extended Char as a Column Delimiter Fails

FIX: BCP IN with 4GB or Larger File Fails with Unexpected E

FIX: Bcp_batch Stops Responding After Interleaved Bcp_sendrow

FIX: BEGIN TRAN After OPEN CURSOR May Not Commit

FIX: Blocking Lock Remains or Server Stops After Heavy Deadlock

FIX: Broken Connection Does Not Terminate Blocked SPID

FIX: Browse Mode Updates with Check Constraint Causes Exception

FIX: BUG: Disproportional Data File Filling

FIX: Build Errors From ODS ODBC Sample Resource DLLs

FIX: BULK INSERT w/ BATCHSIZE Disregards LASTROW Parameter

FIX: Can't Properly Add IPX/SPX Address to Server Network Util.

FIX: Cancelled Creation of Stored Procedure May Cause Error 707

FIX: Cannot Create a Qualified Table With a Check Constraint

FIX: Cannot Insert BLOB Data Larger Than 128k w/ SQLSetParam

FIX: Cannot Link OLAP Servers in SQL Enterprise Linked Server

FIX: Cannot Load a Table If the Owner Is Not SA or DBO

FIX: Cannot Rename a Column With a Quoted Identifier

FIX: Cannot Run Automated Install of SQL 7.0 Using File Images

FIX: Cannot Upgrade Client Win98 Computer Containing OFF2000

FIX: Carriage Return/Line Feed Incorrect in Errorlog

FIX: CASE Expression in WHERE Clause of SELECT May Cause AV

FIX: Character Mode BCP Causes a Memory Leak in SQL Executive

FIX: Checkpoint Process Access Violation when Log Fills

FIX: Checkpoint Process Deadlock Results in Errors 603, 3314

FIX: Client Disconnects May Cause Instability w/

FIX: Cluster Install Fails When SVS Name Contains Special Chars.

FIX: CmdExec May Cause Exception Violation on Scheduled Tasks

FIX: Column Mismatch on SELECT-UNION in INSERT Causes Srv GPF

FIX: COMMIT TRAN Statement May Fail with Msg 602

FIX: Compatible Tape Drives May Not Read SQL Server Dumps

FIX: Complex Query Containing Redundant Logic May Cause AV

FIX: Complex Query May Cause 1521 Error

FIX: Complex T-SQL Batch May Hang During Query Plan Generation

FIX: Concurrent CREATE TABLE

FIX: Concurrent Create/Drop of Stored Procedures May Cause 707

FIX: Concurrent Distribution Tasks May Cause an Unhandled Error

FIX: Concurrent Execution of Keyset Cursors Cause Errors

FIX: Concurrent Xp_makewebtask May Cause an Access Violation

FIX: Configuration Fails Pasting Dist. DB Name w/a Leading Space

FIX: Connections May Result in Handle Leak If SQLTRACE Enabled

FIX: Const. Violation Using INSERT INTO EXEC Gets SPID -1

FIX: Conversion Errors to VAX Floating Point

FIX: Convert to Text Function w/ NULL Input Returns Blank String

FIX: Copied Cubes with Private Dimensions May Fail to Paste

FIX: Correlated Subquery and ISNULL May Cause Disconnect

FIX: Correlated Subquery Can Fail With Trace Flag 204 Enabled

FIX: Correlated Subquery for a Large Table Causes Error 403

FIX: Correlated Subquery in Select List w/ ANSI JOIN Causes AV

FIX: Correlated Subquery Nested 3+ Levels May Give Error 403

FIX: Correlated Subquery on Datetime Col May Cause Client AV

FIX: Count(*) May Not Return Result Set

FIX: Create DB Wizard Incorrectly Sets Trans. Log File Growth

FIX: CREATE INDEX Aborts with Error 1509 or 632

FIX: Create Nonclustered Index Blocks Selects from Table

FIX: CREATE TABLE in Stored Procedure May Fail With Error 1750

FIX: Create View with Nested SELECT in CASE Causes Error 206

FIX: Create Worktable for Oversized Table Can Stop the Server

FIX: Cross-Database INSERTS May Fail with Error 229

FIX: Cursor Declaration In a Stored Procedure Causes Client AV

FIX: Cursor Overhead Higher on SQL 7.0 for Small Result Sets

FIX: Cursor Using Stored Proc After LOAD DB May Get 225 Error

FIX: Cursor w/ Union May Cause Errors if Not First in Batch

FIX: Cursor with UPDLOCK Hint May Leave Object in Open State

FIX: Database Dumps May Be Overwritable Despite Options

FIX: Database Fallback May Cause Dbid to Change

FIX: Database Usage Count Does Not Return to Zero

FIX: Datalength Function Returns 0 for NULL Text Columns

FIX: DATALENGTH Function Returns 0 on 256 Byte Text Parameter

FIX: DB-Library Version 4.20.50 FixList and README.TXT

FIX: DBCC CHECKCATALOG May Incorrectly Report Error 2513

FIX: DBCC Checkident Always Reports the Seed Value as Current

FIX: DBCC DBREINDEX May Cause a LOAD TRAN to Fail w/ Error 1511

FIX: DBCC DBREINDEX on a Table That has no Indexes Creates Error

FIX: DBCC NEWALLOC Does Not Use the Read Ahead Manager

FIX: DBCC NEWALLOC May Cause Incorrect Database Usage Count

FIX: DBCC NEWALLOC May Not Detect TEXT Extent Inconsistencies

FIX: DBCC OPENTRAN Does Not Report Replication Information

FIX: DBCC Shrinkdb Fails with Error 7991

FIX: DBCC SQLPERF(THREADS) Fails w/ AV on 6.0 SP 1

FIX: dbcc Stackdump or CTRL+C + D Causes Fatal Exception

FIX: DBCC TEXTALLOC May Cause SQL Server to Stop Responding

FIX: DBCC Traceon(3604,4031) Causes Unhandled Access Violation

FIX: dbcursorfetchex() Can Cause Blocking in DB-Library

FIX: dbcursorfetchex/dbcursorfetch Do Not Return Error 10086

FIX: DBMSSOC3 Prevents Multiple Connections Across App

FIX: dbopen Memory Leak of 32K On Failed Login Attempt

FIX: Deadlock During Cursor Update Causes CPU Spin and Spinloop

FIX: Deadlock Loop Causes Stack Overflow Unhandled Exception

FIX: Deadlock on Table with Text/Image Column May Cause Errors

FIX: Deadlocks Leave Orphaned Temp Tables, Generate 2540 Errors

FIX: Declare Cursor With Comments May Cause Error #707

FIX: Delay Between Responses Fails for Perf Condition Alert

FIX: DELETE Statement May Cause Server to Become Unresponsive

FIX: Delete Where Current of Cursor Causes Server Instability

FIX: Delete with EXISTS/NOT EXISTS and Subquery Doesn't Escalate

FIX: Delete/Insert on Table with Text/Image May Cause Error 38

FIX: Delete/Rollback May Cause AV on Table w/Text Col

FIX: Denial of Service Attack with Appropriate NULL Bytes in TDS

FIX: Derived Table Generation May Cause Error 206

FIX: Desc. Index Scans May Block with High Transaction Isolation

FIX: Dimension Wizard: Cannot Browse Table w/ a Space in Name

FIX: Direct Update Gets 2 update_page Locks

FIX: Distribution Agent Ignores Error on Pre-Creation Command

FIX: DMO Transfer Methods Does Not Do Code Page Conversion

FIX: DocErr- Code for sp_movedevice Leaves 'allow updates' On

FIX: DocErr: Incorrect Regarding Comparison Operators w/ NULL

FIX: DocErr: Incorrect w/ Respect to Valid Login ID Characters

FIX: DocErr: Recovering Master DB and Expanding MSDB Devices

FIX: Double-Byte Character Set Insertion May Fail w/ Error 2627

FIX: Drop Procedure Gives 3702 Error if Cursor Not Deallocated

FIX: Dropped Net Session Not Detected During Long Query

FIX: DTS 'Execute SQL Task' Terminates Prematurely

FIX: DTS Can't Save a Package to Repository w/ Login

FIX: DTS Designer Fails with Unspecified Error When Adding Table

FIX: DTS Query Designer Does Nothing When ENTER Key Is Pressed

FIX: DTS Wizard New DB Errors When Target Server Is SQL 6.5

FIX: DTSRun: Package Reports False Success with User Password

FIX: DTSWIZ /? Shows /r as an Option but it Does Not Exist

FIX: Dump Aborts if PG_DMPTRLR Bit Set (MSG 3220)

FIX: DUMP DATABASE w/ Variable Device Name in SP May Cause AV

FIX: Dump File Handle Not Released After Error on Load Table

FIX: Dump or Load w/Tape Devices Results in Errors, AVs

FIX: DUMP or LOAD with Tape May Fail on Windows NT 3.51

FIX: Dump to Tape Causes AV Using Adaptec 154x SCSI Adapter

FIX: Dump to Tape Fails Without Error in Errorlog

FIX: Dump/Load May Fail to Work with Older Tape Drives and SCSI

FIX: Dumping to a DLT Tape Drive May Fail to Span Tapes

FIX: DUMPs May Halt Queries That Have Triggers

FIX: Duplicate Hash Keys Created for Two Distinct Index Keys

FIX: Duplicate Jobs Added to the MSjobs Tables

FIX: Dynamic Cursor Fails to Delete a Record

FIX: DYNAMIC Cursor Fails to Release Sh_Page Lock

FIX: Enterprise Manager Displays 'SQL Server Standard'

FIX: Err 107 Creating VIEW with a UNION

FIX: Err 1203 If Deadlock Occurs During Concurrent ORDER BY DESC

FIX: Err 1203 Running Dynamic Cursor in a Stored Procedure

FIX: Err 16943 When Dropping Pull Subscription w/ 'ALL' Param.

FIX: Err 21770 if Trying to Manage Permissions For User-Owned SP

FIX: Err 511: Stored Proc w/ANSI_NULL_DFLT_ON Creates Temp Tbl

FIX: Err 7130 Reports Incorrect Database for Cross-DB Writetext

FIX: Err 7134 w/ Text/Image Col. Update Using 'Where Current Of'

FIX: Err Msg 'Unknown Token Received from SQL Server'

FIX: Error 'Cannot find NETAPI.DLL' When Running ISQL/W

FIX: Error 107 When Creating a View with a UNION Clause

FIX: Error 1105 on Default Segment When Running DBCC DBREINDEX

FIX: Error 1203 Occurs whenTtrigger Fires on Insert

FIX: Error 1203 Occurs with Trace Flag 5302

FIX: Error 1203 Using Dynamic Cursor Within Transaction

FIX: Error 15224 Renaming Column to 1 Character with Sp_rename

FIX: Error 16934 If Sp_cursor Update on Sproc After Dump/Load

FIX: Error 21761 When Binding Non-DBO Default

FIX: Error 2610 on Insert into Table with Multiple Indexes

FIX: Error 3201 Does Not Log a Message to the Errorlog

FIX: Error 3307 After Canceling Large UPDATE Statement

FIX: Error 3307 Running UPDATE STATS After 1105 Error

FIX: Error 3307 with NOLOCK Joins in a Cursor Declaration

FIX: Error 403 on Select w/ Nested Subqueries, Sums, and Groups

FIX: Error 4409 Generated When Using Multiple Database Views

FIX: Error 701/Server Unresponsive on Cursor Queries w/UPDATE

FIX: Error 803 on INSERT into Table with Multiple Indexes

FIX: Error 8104 When DBO Tries to Run SET IDENTITY_INSERT ON

FIX: Error 8115 on Conversion from NUMERIC Constant to REAL

FIX: Error 8158 Caused by Create View Statement

FIX: Error Message Should Be Clearer When Multiple SELECTs in SP

FIX: Error Msg 1007 Occurs While Inserting Value

FIX: Error Msg 201 Incorrectly Returned Twice

FIX: Error Spawning Thread Not Handled Correctly by SQL

FIX: Errors with Procedures Containing Aggregates and HAVING

FIX: Example for EXEC to Change DB Context in TSQL Ref Invalid

FIX: EXECUTE Command w/ a Local Variable Can Cause Thread AV

FIX: Existing Fill Factor Changed w/ Rebuild of Clustered Index

FIX: Expired Dump Media Cannot Be Overwritten After 12/31/99

FIX: Explicit Insert of Identity Value in SP Can Cause AV

FIX: Fail to Pass NULLs as Char/Varchar When Invoking a SProc

FIX: Failed RPC Call from SQL Server Generates Error 18481

FIX: Failed Sp_prepare Incorrectly Closes Transaction

FIX: False Error 512 on Subqueries with Version 4.21.006

FIX: Fetching from an Asynchronous Cursor May Stop SQL Server

FIX: Filtered Stored Procedures Cannot Reference Multiple Tables

FIX: Five-way Table Join w/OR May Cause Handled Exception

FIX: Fixed Length Dates Cause Syntax Errors in srv_convert()

FIX: Fkey NOT FOR REPLICATION Doesn't Work Correctly

FIX: Floating-point Exception Generating Query Plan on Alpha

FIX: Force Index Option Fails with Temporary Tables in St. Procs

FIX: Forward Only and Dynamic Cursors May Infinitely Loop

FIX: French BOL Table of Contents Missing Four Topics

FIX: FT Wizard Fails with WinNT Authentication and Not Sysadmin

FIX: Full Memory and Cursors Cause AVs, 707, 706, and Spins

FIX: Full-Text Search Performance Improved via Support for TOP

FIX: Getdate() Returns Wrong Value w/ System Time Year

FIX: GetExecutionErrorInfo and OnError May NotReturn All Errors

FIX: GRANT ALL Fails to Give Permissions on Stored Procedures

FIX: GROUP BY ALL on a View Shows Columns Not in View

FIX: GROUP BY Clause without Index Executes More Slowly

FIX: GUI Tools Using Query Window Don't Retain Text Formatting

FIX: Handled Access Violation Caused by Mac Client and SQL Trace

FIX: Handled AV If Many Users Dropping/Creating Tables

FIX: Handled AV in SQL Server with Low Memory

FIX: Handled Exception Error Caused by Server Side Cursors

FIX: Heavy Stress on Tempdb w/ Multi-CPU Computer May Cause AVs

FIX: Heavy TEXT/IMAGE Inserts May Lead to Error 611

FIX: HOLDLOCK on READTEXT Causes Error 7134

FIX: How to Obtain SQL Server 4.21a Service Pack 4

FIX: IE 5.0 Hinders SQL 7.0 Wizards and Tabbed Dialogs on Win9x

FIX: If ANSI_DEFAULTS On, Join Sequences in St. Procs Cause AV

FIX: IN Condition with More Than 15 Values May Fail

FIX: Incorrect Results from Sysprocesses with SQL 7 ODBC Driver

FIX: Increasing the Size of Tempdb in RAM Fails

FIX: Index Tuning Fails on Unicode Named Tables

FIX: Index Tuning Wizard Recommends Dropping Indexes

FIX: Infinite Loop When UPDATE of a Cursor with WHERE CURRENT OF

FIX: Infrequent Access Violation During LOAD TRANSACTION

FIX: Insert into Text Column with Trigger Causes Error 711

FIX: INSERT Into w/ IDENTITY Col Inside Trigger Causes AV

FIX: INSERT SELECT Statement Does Not Release Shared Intent Lock

FIX: Insert Through View May Cause Duplicated Identity Value

FIX: Insert View with DEFAULT VALUES Causes AV

FIX: INSERT..EXEC with RPC May Cause Access Violation, Msg 806

FIX: INSERT..SELECT with IGNORE_DUP_ROW on Clustered Index Stops

FIX: Insert/Select May Cause Error 818 If IRL Is Enabled

FIX: Insert/Select/(NOLOCK) w/ Rollback May Cause Error 3307

FIX: Insert/Update May Cause Client to Stop Responding

FIX: Inserting NULL into NOT NULL Column May Cause AV

FIX: Inserts into Table with IRL Turned On May Cause Error 826

FIX: INSERTs into Temp Tables w/Identity May Cause Deadlock

FIX: Inserts on SMP Computer Can Cause Error Message 1203

FIX: Insufficient Tempdb Space During Sort May Cause an AV

FIX: INT Divide by Zero Exception Error When Running a Query

FIX: Internal Error 998 Reported from Profiler

FIX: Intstdist.sql Updates MSjob_commands Incorrectly

FIX: Invalid Column in Subquery May Result in Handled AV

FIX: Invalid Text Handle Errors May Occur in Transactions

FIX: IRL can cause 3307, OS error 6, unhandled server level AV

FIX: ISQL Does Not Return Errors in Last Batch Using -b Switch

FIX: Issuing KILL on Running SQL Web Task Stops SQL Server

FIX: Killing Running Query May Cause an Access Violation

FIX: Large Number of Client Disconnects May Cause AV in ODS

FIX: Large Numbers of AND Conditions May Cause Stack Overflow

FIX: Large Query Text from Socket Client May Cause ODS AV

FIX: Lazy Writer Process May Cause an Access Violation

FIX: Lazywriter Access Violation During DUMP Activity

FIX: LE Threshold Config. Values Do Not Take Effect Immediately

FIX: Load and Recovery of a Read-Only Database May Cause AV

FIX: LOAD DATABASE Fails with Error 603

FIX: LOAD HEADERONLY Doesn't Report Files Cont on Another Tape

FIX: LOAD TRAN May Fail With Error 1511

FIX: LOAD TRAN May Fail With Handled AV

FIX: Local Connections Delayed After Running DBCC Checkdb

FIX: Lock Conversion Processing Fails to Wakeup Lock Waiter

FIX: Lock Escalation w/ Parallel Query May Cause 1203 Error

FIX: LockMgr Message on Open of Static Cursor

FIX: Logging Large Error Messages May Generate Access Violation

FIX: LogReader Can Fail On sp_repldone After Unsubscribing

FIX: LogReader Can Fail On sp_repldone Using Partitioning

FIX: Logreader Fails to Replicate Updating Non-NULL Text Fields

FIX: Logreader Fails when Using XCALL Syntax with Text or Image

FIX: LogReader Fails with Error 14151 or Error 624

FIX: Logreader Failure with TEXT/IMAGE Data Inserted Through BCP

FIX: Logreader Tasks Not Upgraded from SQL Server 6.5 to 7.0

FIX: Long Comment in .SQC File May Cause AV in Nsqlprep.exe

FIX: Losing DTC Service May Leave Orphaned Transactions

FIX: Malformed RPC TDS Packet Causes Various AVs

FIX: Managing Permissions Fails w/Err 21770 w/ User-Owned Tables

FIX: Memory Leak in NTWDBLIB.DLL on Failed dbopen()

FIX: Memory Leak with DB-Library Connection Using TCP/IP

FIX: Memory Leak with xp_sendmail Using Attachments

FIX: Merge Initial Sync w/ Dynamic Filters Takes Long Time

FIX: Message 2 After Issuing ROLLBACK TRANSACTION Command

FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

FIX: Mirror Enabled After Losing Primary Device

FIX: Mmc.exe Remains in Task List After Closing Console Window

FIX: Monthly Scheduled Backup Skips Alternate Months

FIX: MS Query Hangs Trying to Overwrite Existing Local Cube File

FIX: Msdb..Syshistory Rows May Be Incorrectly Deleted

FIX: Msg 1203

FIX: Msg 267 and 202 on Stored Proc If Table Dropped/Re-created

FIX: MSG 550 Occurs When Inserting into View 'WITH CHECK OPTION'

FIX: Msg. 116 Doing Correlated Updates in a Stored Procedure

FIX: Multi-Protocol Encrypted Connection Fails with Error 1749

FIX: Multi-Session DBCC OUTPUTBUFFER Under Stress Causes AV

FIX: Multiple 'LEFT OUTER JOIN' in FROM Clause May Cause Error

FIX: Multiple Attachments not Sent Correctly Using xp_sendm

FIX: Multiple Datasources Deletes Client Config Utility Advanced

FIX: Multiple ORDER BY DESC May Cause 614 Errors

FIX: Multiplying Numeric Datatypes May Yield Lower Precision

FIX: Names May Collide with Creation of Temp Stored Procedures

FIX: Nested Cursors Can Cause a Handled Access Violation

FIX: No Data in ODBC Performance Log If Stopped/Restarted

FIX: No Errors When Trying to Find Null Values in NOT NULL Col

FIX: No Information Returned by xp_logininfo

FIX: NO SYNC on Snapshot Allows Transactions To Be Distributed

FIX: Non-Clustered Fillfactor Reset When Clustered Index Created

FIX: Non-Conflicting Column Updates May Cause Erroneous Conflict

FIX: Non-convergence Problem with Merge Replication

FIX: Non-Optimal Performance for Views Defined with a Subquery

FIX: Nonclustered Index Not Chosen with Varchar and LIKE Clause

FIX: Numeric and Decimal Datatypes Do Not Always Use an Index

FIX: Numeric Column in Oracle Causes Error 7354

FIX: Numeric Datatype in Stored Proc Causes Connection Broken

FIX: ODBC Clients Show as Sleeping but Command Is EXECUTE

FIX: ODBC Driver Cannot Execute sp_helpalert Without Params

FIX: ODBC Only Uses Named Pipes if Non-Admin Win NT Account

FIX: ODS Errors During ATTN May Cause a Hang of SQL Server

FIX: ODS Function Srv_describe May Fail on Certain Type Conv.

FIX: OLAP MDX Application Gives Application Error in VB IDE

FIX: Open Cursor Statement in SP Sets Variables to NULL

FIX: OPENDSNT.DLL Makes Thread AV Server-Wide

FIX: Optimizer Does Not Consider Anti Semi Join for NOT IN Query

FIX: Optimizer Hint for Index Name Fails in View

FIX: Optimizer Hint UPDLOCK Results in Two Pages Being Locked

FIX: Optimizer May Incorrectly Choose Reformat Strategy

FIX: ORDER BY DESC Queries May Cause High Logical Reads

FIX: ORDER BY DESC Query After Update Brings Error 1203

FIX: ORDER BY Queries May Remove Spaces from ANSI_PADDING Tables

FIX: OrigFillFactor Reports Wrong Value for Non-Clustered Index

FIX: OS/2 DB-Library Will Return a Timeout Only Once

FIX: Password Dangling and Decrypted When Changing Security

FIX: Perfmon Terminates While Monitoring SQL Procedure Cache

FIX: Performance Monitor SQL Server-Log Object Corrupt

FIX: Permission Denied Error 229 Updating Table in Another DB

FIX: Permission Denied Error 229 Updating Table with DBID

FIX: Permission Denied Error Message 229 When Updating a Table

FIX: Permissions Denied on Certain Columns After Revoking One

FIX: Permissions Shown Incorrectly in SQL Enterprise Manager

FIX: Pintable, NOLOCK, and JOIN Cause LRU/LazyWriter Errors

FIX: Poor Perf with In Clause, Mult Correlated Union Subqueries

FIX: Prefetching Rows by Bookmark Lookup May Not Release Locks

FIX: Primary Key Violation Causes AV, Text Field Involved

FIX: Problem Using Xp_readerrorlog When Reading Large Errorlog

FIX: Problem With the Code Sample SQLCURS.C

FIX: Problems in Managing OLAP Cube Roles on French Versions

FIX: Problems Using the KILL Command with a Stored Procedure

FIX: Problems with Network Error During dbwritetext/dbmoretext

FIX: Problems with Server Cursors on a Stored Procedure

FIX: Procedure for Repl. Can Fail When Referencing NCI

FIX: Progress Indicators Not Shown When Transferring Data w/ DTS

FIX: Queries Using Derived Tables or GROUP BY May Cause an AV

FIX: Query Analyzer Truncates COMPUTE Clause Output at Six Chars

FIX: Query Cancellation May Fail If No Delay After Query

FIX: Query Plan Inconsistent If Search Value

FIX: Query Slow w/ ORDER BY DESC on Table w/ Composite Index

FIX: Query Timeout of Replication Tasks Not In Seconds

FIX: Query Times Out Too Early Under Multiprotocol Net-Library

FIX: Query w/ Multiple Aggregate Functions

FIX: Query with Complex View Hierarchy May Be Slow to Compile

FIX: RAISERROR Does Not Work with SQLOLEDB Provider

FIX: READTEXT After SELECT with HOLDLOCK Causes Error 1203

FIX: READTEXT May Fail w/ Msg 7134 If Hard Coding Text Pointer

FIX: Rebuilding Indexes w/ SQLMaint May Cause Incorrect Database

FIX: Recovery May Fail w/Error 6902 and Mark Database as Suspect

FIX: Regr: INSERT-EXEC rpc Generates 3307 on Constraint Viol

FIX: Regression Old Syntax Outer Join May Produce Error 613

FIX: REGRESSION: Cluster: SQL Resource Longer to Take Offli

FIX: Remote Backups and xp_loginconfig Fail With Access Denied

FIX: Repeated DBCC DBREINDEX Causes Stack Overflow Error

FIX: Repetitive Connect/Disconnect May Shut Down SQL Server

FIX: Repl w/ Ext Chars on Non-ANSI Char Sets May Fail

FIX: Replicated UPDATE to Char Column May Cause Error 803

FIX: Replication Error: 14262 Specified @job_id Not Found

FIX: Replication Filter Stored Procedures Not Upgraded to 6.5

FIX: Replication Log Reader Task Causes Memory Leak

FIX: Replication Merge JOIN Filters Not Completely Evaluated

FIX: Replication of Japanese DBCS Character Fails

FIX: Replication Problems Mapping Chars to DB2 OLEDB Subscribers

FIX: Replication Tasks Affect Query Timeout for Other SQLExec

FIX: Restore to New Server Causes Transactions to Remain in Log

FIX: ROLLBACK Causes Errs 6902, 602, OS Error 6, or Handled AV

FIX: Rollback in Single User Database Causes Msg 3307 and AV

FIX: Rollback in Trigger Does Not Terminate Batch

FIX: ROLLBACK of TRUNCATE TABLE May Cause Error 3301, AV

FIX: ROLLUP and CUBE Return Incorrect Summary Values

FIX: RPC from Sybase SQL Server to Microsoft SQL Server Fails

FIX: RPC Returns Error 7222 When Re-executed After Canceled RPC

FIX: RPC Using SQL_PARAM_OUTPUT

FIX: RPC w/ Text/Image Parameters May Cause Handled AV

FIX: Running a Global Temporary Stored Procedure May Cause AV

FIX: Runtime Error in Trigger from RPC Causes Server to Hang

FIX: Scheduled Backups May Hang w/ Unexpired Tapes

FIX: Scheduled Backups Stop Working After 4/14/93

FIX: Script Generation Overlooks Rule Bindings

FIX: Script Generation Using SEM Overlooks Default Bindings

FIX: Scripts for Indexes on 16 Cols Contain Extra Characters

FIX: Second LOAD DB of 4.2x DUMP May Corrupt New System Tables

FIX: Security Mgr w/ Long Group Names Can Cause SQL Shutdown

FIX: SELECT * Misleading if char or varchar Field is NULL

FIX: SELECT DISTINCT Using Negative Int in WHERE Can Cause

FIX: SELECT During UPDATE STATISTICS Can Terminate w/ Msg 814

FIX: SELECT from Table with

FIX: SELECT INTO Does Not Return Statistics IO Information

FIX: SELECT INTO From a ALTERed TABLE Cannot be Performed

FIX: SELECT INTO From Table w/ IDENTITY Col Causes Handled AV

FIX: SELECT INTO Inside a Temp Sproc Causes Client to Hang

FIX: SELECT INTO Locking Behavior

FIX: SELECT INTO Temp Tables w/Identity Columns May Cause Errors

FIX: SELECT Into Variable with NO_BROWSETABLE Fails

FIX: SELECT INTO w/ Correlated Subqueries May Cause AV

FIX: SELECT INTO with TEXT/IMAGE Is Not a Non-Logged Operation

FIX: SELECT MAX from INT Column May Cause Access Violation

FIX: Select on a View May Generate Error 4409

FIX: SELECT Query with Bit Datatype Slower on SQL 7.0 than 6.5

FIX: Select Statement Can Cause Arithmetic Overflow

FIX: SELECT TEXT Columns with FOR BROWSE Holds sh_page Locks

FIX: SELECT w/ IN Clause Causes AV w/ Subquery SELECT NULL

FIX: SELECT w/WHERE Clause from UNION of SELECT Stmts. Uses Scan

FIX: Select with CASE Statement Inside View Can Cause Client AV

FIX: SELECT with ORDER BY on an Oversized Table Fails

FIX: Selecting From Views With Nested Select Causes Errors

FIX: Selecting Text or Image Field Using Table Owner's Name Errs

FIX: Selecting TEXT/IMAGE with Insensitive Cursor May Disconnect

FIX: SELECTs from SYSPROCESSES Result in Access Violation

FIX: SEM - Edit Devices Dialog Displays Negative Device Size

FIX: SEM Can Take Excessive Time to Generate a Script

FIX: SEM Generates Handled Exception Reading the Errorlog

FIX: SERIALIZABLE Isolation Fails When Using Aggregate Func

FIX: Server Out of Memory when Inserting into Text/Image Fields

FIX: Server Stops/AV on Client Disconnect w/ an Open Transaction

FIX: Server Unresponsive After Deadlocks Under Tempdb Stress

FIX: SET ANSI_WARNINGS ON Option Does Not Generate Warnings

FIX: SET ARITHABORT ON Inadvertently Causes an Insert to Fail

FIX: SH_PAGE Lock Not Released After Fetch Operation

FIX: SH_PAGE Locks Held on Text or Image Data in Service Pack 1

FIX: SH_PAGE Locks May Be Held on Inner Tables of JOINs

FIX: Shared Intent Lock Acquired by READTEXT Are Not Released

FIX: Shared Intent Locks Held After Validating Constraint

FIX: Slow Query Performance Using Correlated Subquery

FIX: Smalldatetime Conversion Error Stops Batch Jobs

FIX: SNMP Extended Stored Procedures May Leak Memory

FIX: Sp_[un]bindrule and sp_[un]bindefault Problems for Db_owner

FIX: sp_addtype Ignores NULL For the nulltype Parameter

FIX: Sp_columns Returns More Than One Row for a Column

FIX: Sp_Cursor Positioned Update Causes Access Violation

FIX: Sp_cursorfetch May Cause Errors 614 and 605

FIX: Sp_cursorfetch: No Error Reported With Incorrect Datatype

FIX: Sp_cursoropen Causes AV on the Initial Exec After LOAD

FIX: Sp_cursoropen Error With More Than One Parameter Marker

FIX: sp_OA Procedures Cause Memory Leak in SQLSERVR.EXE

FIX: sp_OAGetProperty May Fail With Inherited Interface

FIX: sp_processmail Will Only Process One Query per Execution

FIX: Sp_replcounters with INSERT..EXEC May Cause Server Hang

FIX: sp_statistics May Return Incorrect Results

FIX: SP4 Hotfix Performance Problem on Alpha Version

FIX: SP5a Regression: Access Violations with Tempdb Deadlocking

FIX: SpaceAvailableInMB Property Returns Used Space Instead

FIX: SPID Hangs w/Mult. Connections in Same DTC Transact Context

FIX: Spid Missing with Trace Flag 4032 on RPC Events

FIX: Sproc Created but No Code in Syscomments

FIX: SPs Created from Other SPs Have no Entry in Syscomments

FIX: SQL 6.0 Upgrade Fails if SA Default DB is Not Master

FIX: SQL 6.5 Does Not Allow Updates to a View If Grant Specified

FIX: SQL 7.0 Slower than 6.5 on Join with View Containing CASE

FIX: SQL 7.0 Slower than 6.5 on UNIONed Left Outer Join and View

FIX: SQL 7.0 Slower than SQL 6.5 on Multiple Left Outer Join

FIX: SQL Admin: Actual Startup Time for Scheduled Backups

FIX: SQL Cluster: Error 'Port 1433 in Use' on Alpha Platform

FIX: SQL Executive Service Becomes Unstable While Replicating

FIX: SQL Performance Counters May Cause Handle Leak in WinLogon

FIX: SQL Profiler May Cause Divide By Zero Exception

FIX: SQL Server 4.21a Service Pack 4 Fixlist

FIX: SQL Server 6.0 Service Pack 1 Fixlist

FIX: SQL Server 6.0 Service Pack 2 Fixlist

FIX: SQL Server 6.0 Service Pack 3 Fixlist

FIX: SQL Server 6.5 Service Pack 1 Fixlist

FIX: SQL Server 6.5 Service Pack 2 Fixlist (Part 1 of 3)

FIX: SQL Server 6.5 Service Pack 2 Fixlist (Part 2 of 3)

FIX: SQL Server 6.5 Service Pack 2 Fixlist (Part 3 of 3)

FIX: SQL Server 6.5 Service Pack 3 Fixlist

FIX: SQL Server 6.5 Service Pack 4 Fixlist

FIX: SQL Server 6.5 Service Pack 5a Fixlist

FIX: SQL Server Cluster Setup May Fail on Third-Party Disk Drive

FIX: SQL Server Does Not Properly Inform DTC of Aborted Trans.

FIX: SQL Server Error 613 Does Not Show Supplemental Msg Info

FIX: SQL Server Fixlist 4.20aK8

FIX: SQL Server Service Stopped When IsAlive Fails to Connect

FIX: SQL Server SP5 Client Setup Does Not Install Sqlgui32.dll

FIX: SQL Server Stops Responding After an INSERT/SELECT

FIX: SQL Server Stops Responding When Canceling Tape Backup

FIX: SQL Terminates on Delete Table with 15 Self-References

FIX: SQL Terminates on Repeated Cursor Calls w/ ODS Handlers

FIX: SQL Trace May Cause Heap Corruption After Handled Exce

FIX: SQL Web Assistant Cannot Schedule Page Creation After 1999

FIX: SQL-DMO::EnumQueuedTasks May Cause Memory Leak

FIX: SQLBindParameter Fails Under Simplified Chinese Windows95

FIX: SQLDMO - Setting BULKCOPY.SuspendIndexing = True May Fail

FIX: SQLGetData Fails on Multiple Active Statement Handles

FIX: SQLOLEDB Resends Prepared Commands with Client Cursors

FIX: SQLPrepare() Returns Incorrect Error on FOR UPDATE

FIX: SQLTrace May Cause Error 17803 on a Server

FIX: Sqltrace.dll May Cause Heap Corruption w/0-Length RPC Param

FIX: Srv_message_handler Text Limit

FIX: Stack Overflow If a SELECT Statement Is Killed

FIX: Stored Procedure Can't Be Upgraded

FIX: Stored Procedure Creation Gets Garbled Entry in Syscomments

FIX: Stored Procedure Invocation Returns 'Protocol Error in TDS'

FIX: Stranded Compile Time Table Created by a Failed SELECT INTO

FIX: Stranded Tables After Deadlocks on System Tables

FIX: Stress of Lock Limit Threshold Causes Bufwait Error Message

FIX: Striped Dump to 7 or More Devices is Not Logged

FIX: Striped Dumps May Cause Error 18001

FIX: Switching Order of Tables in FROM Clause Changes Optimizer

FIX: SYBASE CT-Library Clients Cannot Connect to SQL Server

FIX: Syntax Error in SELECT List May Cause Handled AV

FIX: Syntax Error on Negative Parm Value in Grouped Procedure

FIX: Syntax Error Reporting Disabled w/ St Proc

FIX: T-SQL Cursors Ignore NOCOUNT Query Option

FIX: Table Lock Escalation in Service Pack 1 Causes Error 1203

FIX: Taking tempdb Out of RAM Can Cause Error 1808

FIX: Tape Backup May Cause Error 3201 Device Offline

FIX: Temp Table Stranded If Deadlock in Stored Proc. w/ Cursor

FIX: Temporary Dump Devices May Be Created with the Wrong Name

FIX: Temporary Tables Not Dropped When Tempdb Is Full

FIX: Terminating Clients with TSQL KILL May Cause ODS AV

FIX: Text Col. Update Through Cursor

FIX: TEXT Operations Can AV During DUMP DATABASE

FIX: Thread AV in SP1 Using a Cursor Defined w/Constant and View

FIX: Thread Deadlock Causes Checkpoint to Hang in tempdb

FIX: Timestamp Col of Temp Table Set to 0 When Inserting Row

FIX: Trace Flag 1211 Does Not Work Properly

FIX: Transfer Manager Does Not Transfer Triggers

FIX: Transfer Manager Leaves Open Connection in Source DB

FIX: Two-Phase Commit build_xact_string Documentation

FIX: Unable to Grant Logins from Global Group with SQL Security

FIX: Unable to Truncate a Table That Had a Constraint Defined

FIX: Undetected Deadlock with Checkpoint and SELECT INTO

FIX: Unexpected Behavior During Object Resolution

FIX: Unexpected Results Using OBJECT_ID()

FIX: Unexpected Vines IPC Msg Can Cause CPU Spin or Exception

FIX: Unhandled Access Violation with Temporary Procedure

FIX: Unhandled AV During Concurrent DUMP DATABASE Commands

FIX: Unhandled Exception During Upgrade When Excluding Database

FIX: Unhandled Exception When Running DBCC Checkdb

FIX: UNION in Views Maintains Duplicate Rows If Table Has Bit

FIX: UPDATE May Fail With Error 107

FIX: Update of BLOB Data w/SQL Server 2.65.0201 Driver Stops

FIX: Update of Primary Key Causes Repl Custom St. Proc to Fail

FIX: Update on View-based Cursor Fails to Modify Row

FIX: Update View with Inner Join from Cursor Causes AV

FIX: UPDATE with FORCEPLAN ON May Cause Error 806 in Tempdb

FIX: Updates in Browse Mode Applications Can Cause AVs

FIX: Updates to Tables w/Text on SP2 Cols May Result in Errors

FIX: Updates with Foreign Key Constraint Cause Exception Error

FIX: Updating a Record w/ NULL Text Field Can Cause 2574 Error

FIX: Updating a Text Column Results in a Table Scan

FIX: UPDLOCK Locking Option Sets Only Shared Lock with sp_cursor

FIX: Upgrade to SQL Server Fails When MSDE Installed from MOD

FIX: Use of 25 Different Tables in a Query May Raise Error

FIX: Use of the RIGHT Function Within an ANSI Join Fails

FIX: User-Defined System Stored Procedures Must Be In Master

FIX: Users Added via WinNT Groups Not Able to View Table List

FIX: Users Blocking With No Locks Displayed in sp_lock

FIX: Using a Derived Table in the HAVING Clause May Cause AV

FIX: Using a WHERE IN Clause on a Selected UNION May Fail

FIX: Using Srv_paramsetoutput to Set Output Param. to NULL Fails

FIX: Views Containing a UNION Resolve with Materializing Model

FIX: WAITFOR Variable in Stored Proc May Cause Handled AV

FIX: Weekly Tasks Skip a Day if Interval + End Times

FIX: Wildcard Operator '%' w/ LIKE Causes Erratic Row Patterns

FIX: Win16 DBLIB Does Not Restrict Packet Size to 512 for SPX

FIX: Writelog Timeout When Replicating Cross-DB Transactions

FIX: Wrong Index Chosen if Query Ref. Values Beyond Statistics

FIX: Wrong Join Plan Selected That Causes Excessive Reads

FIX: Xp_cmdshell Run by Non-SA Causes Error 1326

FIX: Xp_makewebtask Procedure May Cause Access Violation

FIX: xp_readmail Fails on MIPS Computers

FIX: xp_sendmail Unable to Login to SQL Server Version 4.21a

FIX:Bulk Insert Inserts Records if FIRSTROW Greater Than LASTROW

FIX:DECLARE CURSOR on Temp Table with FOR UPDATE Causes AV

FIX:Impllcit Conversion with Aggregate Functions Causes Overflow

FIX:Lvl 16 Error on Temp Tbl From SP w/

FIX:OLAP:DSO Role Update May Return 'Key Already Associated' Err

FIX:Recovery May Not Reset IDENTITY Value After TRUNCATE TABLE

FIX:Repeated Temp Table Creation/Access Can Cause Errs 208/267

FIX:Upgrade Wizard GUI Allows Adding of New File Groups to Model

How to Install SQL 7.0 Desktop Edition on SBS 4.5 Clients

How to Obtain Embedded SQL for C Version 6.5 Patch

How to Obtain SQL Server 6.5 Service Pack 4

How to Obtain SQL Server v6.0 Service Pack 3

How to Search for SQL Server Articles by Article Topic

HOWTO: Allow an English Query to Interact with non-SQL7 Data

HOWTO: Alter Default Network Library w/o Client Network Utility

HOWTO: Back Up an MSDE Database with T-SQL

HOWTO: Import FileSystem Data Using DTS and Index Server

HOWTO: Put Stored Procedures Under Source Control in Visual Inte

HOWTO: Retrieving Calculated Fields from SQL Server 7.0

HOWTO: SQL Server 7 Distributed Query with OLAP Server

HOWTO: Using SQL DMO to Print Date in Regional Format

INF : How to Set the Day/Month/Year Date Format in SQL Server

INF: 'DBCC TRACEON (208)' Messages in Error Log Using MSQuery

INF: 'OR' Clause Prohibits the Use of Merge or Hash Algorithms

INF: -T3640 Flag May Block Updates to an ODBC Application

INF: @@TRANCOUNT Global Variable Detects Rollback

INF: 6.5 SEM Cannot Detect State of SQLMail on 6.0 Servers

INF: A Stored Procedure to Display Trigger Information

INF: Accessing LAN Manager from SQL Server for Windows NT

INF: Additional Fallback Considerations

INF: Addressing Access Conformance Errors in the SQL ODBC Drvr

INF: Administering SQL Server 6.x and 7.0 From a Single Computer

INF: Advanced Debugging of SQL Server Procedures

INF: Aggregates and SET Clause in UPDATE Statement

INF: Alerts and Tasks Can Occur When SQL Server Is Not Running

INF: Altering Database to Add Multiple Log Devices

INF: Analyzing and Avoiding Deadlocks in SQL Server

INF: Appending Data from Access Table to SQL Table

INF: ARITHABORT and ARITHIGNORE Behave Different on 6.5 and 7.0

INF: Assessing Query Performance Degradation

INF: Asynchronous Query Execution Using VBSQL

INF: Automatic Transaction Log Dumping via Performance Monitor

INF: Backing Up and Recovering Databases

INF: Backup of Logins with Integrated and Mixed Security

INF: Backup Strategies and Tips Before Upgrading SQL Server

INF: Backup with INIT or FORMAT Is Documented in Error Log

INF: Basic Guidelines for Installing SQL Server Version 6.5

INF: BCP and Formatting of MONEY Data Type

INF: BCP and NULL Values

INF: BCP and Transaction Logging

INF: bcp_exec API Requires User Error Handler

INF: BCPing in Just the Date of Datetime Column

INF: Behavior if Both ARITHABORT

INF: Behavior of ANSI_PADDING

INF: Behavior of Cascading Triggers with Recursive Calls

INF: Boundaries of Implicit Transactions

INF: Branching Within Static Batch in Embedded SQL for COBOL

INF: Building an ODS Application with MFC

INF: Building Apps with Visual Basic Library for SQL Server

INF: Bypass (Emergency) Mode and DUMP TRANSACTION WITH NO_LOG

INF: Calculating Space for the Storage of NULL Values

INF: Calling DLLs from Extended Stored Procedures

INF: Calls to Extended Stored Procedures Are Case Sensitive

INF: Canceled Transaction in a Temp Table Causes X and U Locks

INF: Cannot Restore Transaction Log from SQL Server 6.0 to 6.5

INF: Cannot See Actual Data Values for Columns in Enterpris

INF: Cannot SELECT DISTINCT * on a Table w/ Text/Image Column

INF: Cannot Set Certain DB Options with SQL Enterprise Mgr.

INF: Cannot SQLPrepare() the Creation of Temporary Objects

INF: Cannot Turn Off Transaction Logging

INF: Cascading Deletes and Updates of Primary Keys

INF: Case-Sensitive Query Results w/ Case-Insensitive Sort Order

INF: Causes of SQL Transaction Log Filling Up

INF: Change Network Support Option Unavailable in Setup

INF: Changes to SQL Server 6.0 That May Affect 4.2x Apps

INF: Changes to SQL Server 6.5 That Affect 6.0 Apps

INF: Changes to SQL-DMO Objects in SQL Server 7.0

INF: Changing Clustered SQL Server Network IP Addresses

INF: Changing Configuration Values When SQL Server Won't Start

INF: Changing the Fonts Used by SQL GUI Tools

INF: CHECKALLOC/NEWALLOC

INF: Checking Results of Stored Procedures with RAISERROR

INF: Client Config. Util. Indicates Unusual DB-Library Date

INF: Client Effects on SQL Server Throughput

INF: Clustered SQL 7.0 Servers and Rolling Operating System

INF: COBLIB: .EXE Calling .GNT Files with ESQL for COBOL

INF: Collisions During Multiple-User Updates

INF: Common Connectivity Errors on Novell Networks

INF: Common SQL-DMO C/C++ Programming Issues

INF: Commonly Asked BCP Utility Questions in SQL

INF: Compaq IDA-2 Controller and SQL Data Corruption

INF: Comparison of Join Techniques

INF: Comparison of Strings Containing Trailing Spaces

INF: Complexity of WHERE Clauses in SQL Server

INF: COMPUTE and the Microsoft SQL Server ODBC driver

INF: Concurrency and Consistency and SQL Server Alternatives

INF: Conditions for Stored Procedure Recompilation

INF: Conditions When Stored Procedures Are Recompiled by SQL

INF: Configuring ODS Servers for Alternate Pipes Under NT

INF: Connecting to SQL Server from NetWare Clients

INF: Connecting to Standalone SQL Server Using 16-bit Apps.

INF: Conventions dbconvert() Uses to Convert FLOAT to CHAR

INF: Conversion of Floating Point Values to Character Strings

INF: Converting SQL CHAR Values into DATETIME Values

INF: Copying SQL Database Files for Backup/Restore Purposes

INF: Correctly Parsing Quotation Marks in FTS Queries

INF: Create Clustered Index with SORTED_DATA Option

INF: Creating

INF: Creating .GNT Files with Embedded SQL for COBOL

INF: Creating a Duplicate SQL Database

INF: Creating a Four-Byte User-Defined DATE Data Type

INF: Creating a Log Device If 'Log Full' Error Occurs

INF: Creating NOT NULL Character Fields Without Padded Blanks

INF: Cursor Not Accept Temp Tables in ESQL for COBOL

INF: Cursors Remain Open when CURSOR_CLOSE_ON_COMMIT Set OFF

INF: Customizing SQL/MSDE Unattended Installation Files

INF: Data Conversion Sample Program in Embedded SQL for COBOL

INF: Data Page Cache Management in SQL Server

INF: Data Transformation Services and Logged Loads

INF: Database Creation and Backup Operations Use Parallelism

INF: Database Device File Image Backup and sp_dboption

INF: Database Property Sheet Displayed Incorrectly

INF: DB Maintenance Wizard Warns About Use on Large Databases

INF: DB-LIB and Floating Point

INF: DB-Library In Extended Stored Procedures

INF: DB-Library Reentrancy and User-Defined Error Handlers

INF: DB-Library Version 4.20.50 Enhancements

INF: DB2 Gateway for SQL Server

INF: DBCC SQLPERF(LRUSTATS) Reports Some Irrelevant Info.

INF: dbcursorclose Documentation Incorrect

INF: DBMSSOC.EXE Not Supported w/ TCP/IP-32 in WFW

INF: dbnextrow Does Not Return Fail on Deadlock

INF: dbwritetext Sample Code Documentation Incorrect

INF: Deadlock Scenarios and Avoidance in SQL

INF: Deadlocks and Timeouts

INF: Deadlocks and Two-Phase Commit

INF: Deferred Constraints and Disable_Def_Cnst_Chk

INF: Definition of Sysprocesses Waittype and Lastwaittype Fields

INF: Description of DBCC PAGE Command

INF: Description of sysindexes and sp_spaceused

INF: Description of the DBCC PGLINKAGE Command

INF: Desktop Version Is Configured for Local Access Only

INF: Details and Strategies for Using DBCCs

INF: Detecting Deadlocks

INF: Determining If a Row Has Been Changed in Browse Mode

INF: Determining the Oldest Open Transaction

INF: Determining User Segments from Segmap Values

INF: Determining When Unattended SQL 7.0/MSDE 1.0 Setup Finishes

INF: Diagnostic Tips for the Microsoft SQL Server ODBC Driver

INF: DIFFERENCE() and SOUNDEX() Functions in Transact-SQL

INF: Differences Between BCP Format Files Versions 1.x and 4.2

INF: Differences in Column Nullability

INF: Differences in SQL Behavior Between ODBC and ISQL

INF: Differential Backup Time Considerations

INF: Differentiating Between Timestamp and Varbinary Types

INF: Disabling Logreader and Distribution 'Autostart' Tasks

INF: Disaster Recovery Planning for SQL Server

INF: Disk Dump Device Size in SYSDEVICES

INF: Display Chinese|Japanese in ISQL/W in English NT 4.0

INF: Display Limitations for TEXT or IMAGE Columns

INF: Distribution of SQL-DMO (Distributed Database Objects)

INF: DocErr: The Real Meaning of 'dpub'

INF: DTS Package Development, Deployment and Performance

INF: DTS Transfer SQL Server Objects Fails Transferring Table

INF: DTS/Replication Licensing for Desktop SQL Server 7.0

INF: Dump File Size Not Updated During Dump Database

INF: Dump Point Flag in the Transaction Log of SQL Server

INF: Dump SQL DB to a Novell File Server

INF: Dynamically Altering Table Definitions in SQL Server

INF: Effect of Permissions Additions/Deletions on SYSPROTECTS

INF: Effect of SET ROWCOUNT on SELECT with ORDER BY

INF: Effective Use of Trace Flag 204 for ANSI Non-standard Ext

INF: Emulating the iif() Function in Transact-SQL

INF: Enabling DLL-based COM Object Execution Outside SQL Server

INF: Enhancement to Trace Flag 1140

INF: Err Msg 'Cannot Obtain Server's Start Directory From ..'

INF: Err Msg: Cannot Connect to that Server Op. Sys. Platform

INF: Error Handling in Transact-SQL

INF: Error Message List for NIK and SQL Bridge for OS/2

INF: ESQL-C Long Strings No Longer Cause Compiler Errors

INF: ESQL: How to Handle Binary Data in ESQL

INF: Estimating the Initial SQL Server Memory Setting

INF: Example Active Server Page to Access OLAP Services

INF: Example of Using Nested Triggers

INF: Examples of Sp_OA Procedure Use and SQLOLE.Transfer Object

INF: Executing SQL Server Stored Procedures from Excel

INF: Explanation of Cache Column in Sysobjects

INF: Explanation of Error Message 16929, Cursor Is Read-Only

INF: Explanation of Index ID's Found in SYSINDEXES

INF: Explanation of Open Objects in SQL Server

INF: Extended Procedure Error: 'Cannot find the DLL 'xxx.dll''

INF: Extended Stored Procedures from C++ Require extern 'C'

INF: Extended Stored Procedures: What Everyone Should Know

INF: Extracting Month and Year from ASCII File with BCP

INF: Fast Query to Return Number of Rows in a Table

INF: Finding Length of SQL IMAGE Fields While Using DB-Library

INF: Finding Names of Columns That Comprise the Key of a Table

INF: Fixed-Length Versus Variable-Length Index Entries

INF: Forcing Update by Overriding Timestamp Protection

INF: Frequently Asked Questions - Conversion

INF: Frequently Asked Questions - Failover

INF: Frequently Asked Questions - Replication

INF: Frequently Asked Questions - Server

INF: Frequently Asked Questions - SQL Setup

INF: Function dbretname() Returns NULL

INF: Getting Started with Data Transformation Services (DTS)

INF: Getting Started with Microsoft SQL Server Replication

INF: Grant or Revoke Permissions for ESQL Stored Procedures

INF: Guest Access to SQL Server on Windows NT Advanced Server

INF: Handling Deadlock Conditions

INF: Handling ODBC Errors in Remote SQL Server Setups

INF: Handling of NULLs, Null Strings, and Blanks in SQL Server

INF: Handling sp_server_info Language Events in ODS Apps

INF: Handling Subscriber Schema Changes with Replication

INF: Handling Timeouts Correctly in DB-Library

INF: How and Where to Place VBSQL.VBX

INF: How DATALENGTH Determines the Length of Text Fields

INF: How Grant and Revoke work in SQL Server 6.5.

INF: How Scheduled Data Transfer Works

INF: How Sorting Works in OLAP Services

INF: How Sp_OA Procedures Extension to SQL Server Is Implemented

INF: How SQL Monitor Locates SQL Server's Errorlog

INF: How SQL Server 7.0 Autostats Work

INF: How to Access SQL Server Within Active Server Pages

INF: How to Archive More Than Six SQL Server Errorlogs

INF: How to Automate Replication over a Dial-Up Connection

INF: How to Automate SQL Trace by Means of Scheduled Tasks

INF: How to BCP in Datetime Values in Nondefault Format

INF: How to Benefit From Autoexec Stored Procedures

INF: How to Bulk Copy Out All the Tables in a Database

INF: How to Calculate the Product of a Field

INF: How to Calculate the Virtual Device Number

INF: How to Change the Sleep Value Used by Dbdataready

INF: How to Check Permissions for Every Table, View,

INF: How to Configure NWLink to Run SQL Srv with Multiple NICs

INF: How to Control the SQL Server Services on Windows 95/98

INF: How to Convert an Access Database to SQL Server

INF: How to Correlate Spid, Kpid, and Thread Instance

INF: How to Create a Custom Sort Order Definition File

INF: How to Create Dynamic Table Names in SQL Server

INF: How to Create Extended Stored Proc for a Pager Notification

INF: How to Debug 'Service State Indeterminate' in SEM

INF: How to Debug an Extended Stored Procedure

INF: How to Debug Direct Connections to SQL Srv over IPX/SPX

INF: How to Debug SQL Server Connectivity Problems Over RAS

INF: How to Detect and Compare File Differences

INF: How to Determine if DBNMPIPE.EXE Is Loaded from C Program

INF: How to Determine Number of Rows of Every Table in Database

INF: How to Determine SQL Server 6.x Service Pack Installed

INF: How to Determine Tempdb Size Required by DBCC CHECKDB

INF: How to Determine the Current Settings for @@options

INF: How to Determine When SQL Server Causes a WinNT Blue Screen

INF: How to Differentiate SQL 7.0 Standard and Developer Edition

INF: How to Disable Domain Authentication Boxes

INF: How to Downgrade From SQL Server 6.5 Service Pack 5 or 5a

INF: How to Dynamically Number Rows in a Select Statement

INF: How to Enable Logging for SQL Server Cluster Wizard

INF: How To Handle Errors in DTS Package and Step Objects

INF: How to Identify Which Edition of SQL Server 7.0 Is Running

INF: How to Improve DBCC Performance on SQL Server

INF: How to Include Other MMCs in SQL Enterprise Manager MMC

INF: How to Increase the Number of SQL Server Error Logs

INF: How to Insert DBCS Data in SQL Server from English Windows

INF: How To Install DTS Event Handlers In Visual Basic

INF: How to Install Only the SQL Server Books Online

INF: How to Install SQL Server on Computers Using a Hyphen

INF: How to Manipulate DBCS Data in a Text Field

INF: How to Manually Remove Replication

INF: How to Monitor Free Space in a User Database with PerfMon

INF: How to Move a Device to Another Location

INF: How to Move Tempdb to a Different Device

INF: How to Obtain a List of DTS Packages

INF: How to Obtain French SQL Server 6.5 Service Pack 2

INF: How to Obtain German SQL Server 6.5 Service Pack 1

INF: How to Obtain German SQL Server 6.5 Service Pack 2

INF: How to Obtain SQL 6.5 Programmer's Toolkit and Vbsql.ocx

INF: How to Obtain SQL Server 6.5 Service Pack 1

INF: How to Obtain SQL Server 6.5 Service Pack 2

INF: How to Obtain SQL Server 6.5 Service Pack 3

INF: How to Obtain SQL Server 6.5 Service Pack 5a

INF: How to Obtain SQL Server 7.0 Service Pack 1

INF: How to Perform Replication with the Timestamp Datatype

INF: How to Process Results in an ESQL Application

INF: How to Profile T-SQL Code in Stored Procedures and Triggers

INF: How to Rebuild the Repository in SQL Server 7.0

INF: How to Remove Duplicate Rows From a Table

INF: How to Remove the Default Mapping of WinNT Admins to SQL SA

INF: How to Restrict the Inner Table of an ANSI Outer Join

INF: How to Return Multiple Columns in a DTS Lookup Query

INF: How to Rotate a Table in SQL Server

INF: How to Run NetMon Based on a Specific Error Occurring

INF: How to Scan SQL Errorlog or DBCC Output for Errors

INF: How To Schedule Recurring Tasks To Run At Night

INF: How to Set Up Replication on Tables with an Identity Column

INF: How to Set Up Security for Linked Server to OLAP Services

INF: How to Set Up SQL Performance Monitor Database Alerts

INF: How to Set Up SQL Server for Access Through Proxy Server

INF: How to Set Up the ProcSrv ODS Server Application

INF: How To Setup an Alternate Console Pipe

INF: How to Transfer Korean Double Byte Character Set Chars

INF: How to Troubleshoot Communication Error 17824

INF: How to Troubleshoot Long Recovery on Databases

INF: How to Troubleshoot Message 701 and Server Cursors

INF: How to Troubleshoot Orphaned Connections in SQL Server

INF: How to Troubleshoot SQL Server Communication Error 17832

INF: How to Troubleshoot SQL Server Tape Read/Write Errors

INF: How to Use Connectable Objects in SQL-DMO

INF: How to Use DBBCMD to Enable BCP IN Through an ODS Gateway

INF: How to Use Editbin to Adjust SQL Server Thread Stack Size

INF: How to Use ListIndexedColumns in SQL-DMO in Visual Basic

INF: How to Use the SQL Server DMO Objects from VBScript

INF: How to Use Unaligned Data Reference on Alpha Platforms

INF: How to Write a Variance Query in SQL Server

INF: How Tunable Lock Escalation Works

INF: Identifying SPID Responsible for Lock Chain

INF: Ignoring INSCAT.sql Comment About Updating spt_server_info

INF: IIS Queries to SQL Server Generate Error 1326

INF: Implementing a Unique, Increasing Key Value

INF: Implementing DUMP and LOAD to PIPE Devices

INF: Implementing Password Expiration of SQL Server Login IDs

INF: Implicit Rollbacks of Transactions in SQL Server

INF: Improper Usage of dbclose() Can Cause Disconnect Message

INF: Improved KILL Statement for DBCC CHECKDB

INF: Improving Performance in Views with Aggregate Functions

INF: Incorrect dpages Error When Creating an Index

INF: Incorrect Versions of Odbcint.dll Can Affect Components

INF: Indexes Use Distribution Page Statistics

INF: Information on CPU and Physical_io Columns of Sysprocesses

INF: Information on DBCC 1204 (Deadlock) Output

INF: INSERT EXEC of Text/Image/Ntext from XP Is Not Supported

INF: Installation Order: Cluster Server Support for SQL or MSMQ

INF: Installing a DBCS Code Page for SQL Server

INF: Installing Additional Languages on SQL Server

INF: Interpretation of SET STATISTICS TIME ON Results

INF: Interpreting BINARY Data w/ Visual Basic Library for SQL

INF: Interpreting Msg 4305 'Specified File Is Out of Sequence'

INF: Interpreting Return Status Values from Stored Procedures

INF: Interrupting the Display of SQL Server Output

INF: Invalid Use of dbwritetext Can Cause 806 Errors

INF: Invoking an Editor from ISQL or OSQL

INF: Invoking Stored Procedures from Embedded SQL for COBOL

INF: ISQL Does Not Send Carriage Returns to SQL Server

INF: ISQL Is Faster When Output Is Sent to Disk File

INF: ISQL or OSQL Lines That Have Already Been Typed in Can Be E

INF: ISQL Output to a Text File Will Wrap Lines Longer Than 733

INF: Issues With Shrinking SQL Server Databases

INF: Issuing an Update in Browse Mode

INF: Iterating Through a Results Set Using Transact-SQL

INF: Known Problems Running SQL Server 6.5 on Windows 2000

INF: Linking Embedded SQL for COBOL MS-DOS Apps with COBLIB

INF: List of Version Numbers of ODBC Driver Manager

INF: Listening on Multi-Protocol Fails on Startup

INF: Loading Version 1.x Databases When Installing Version 4.2

INF: Location of Deleted and Inserted Tables

INF: Location of Odbcss.h

INF: Lock Escalation Does Not Block If a Wait Is Required

INF: Locking Behavior of Cursors on SQL Server Version 6.0

INF: Locking Behavior of Updates and Deletes in SQL Server

INF: Locking Multiple Tables in SQL Server

INF: Log Space Used Appears to Grow After Restoring from Backup

INF: Logging and Data Storage Algorithms Extend Data Reliability

INF: Logins Aliased to Databases Users Cannot Be Viewed from SQL

INF: Macintosh Connectivity to SQL Sever for OS/2

INF: Manual Decompression of SQL Server Files

INF: Manual Installation of Sort Orders

INF: Manual Replication Setup w/ A Remote Distributor

INF: Manually Removing SQL 6.5 After Failed Install

INF: Max Async IO Configuration Parameter

INF: Max Number of Concurrent DB-Library Tasks in SQLExec

INF: Maximum Size for DBTEXTLIMIT Option

INF: Meaning of 'Uninitialized Pages' Message During DUMP

INF: Meaning of USER ATTENTION SIGNAL Error

INF: Memory Overhead for Connections, Objects, Locks, and DBs

INF: Message in Errorlog When Physical Dump File Absent

INF: Messages Generated by the SQL Server 6.0 Eval Version

INF: Microsoft Open Data Services ODBC Driver

INF: Microsoft Products That Include the SQL Server Product

INF: Microsoft SQL Server DB-Library Has Limited Extensibility

INF: Microsoft SQL Server ODBC Driver Versions

INF: MIN and MAX Should Not Be Used on Timestamp Column

INF: Missing System Errors in Books Online for SQL Server 6.5

INF: Mix of Aggregate Functions

INF: Modifying BCP Format File to Load into Specific Columns

INF: Movement of Keyset in a Mixed Cursor

INF: Moving Databases Between Servers Using DUMP/LOAD

INF: Moving Extended Stored Procedures Out Of Process

INF: Moving SQL Server 7.0 Databases to a New Location

INF: Multiple Active Microsoft SQL Server Statements

INF: Multiple Named Pipes Connections May Cause Error 17832

INF: Multithreaded Reentrancy and DB-Library

INF: Named Pipes Connectivity in an OS/2 2.1 MS-DOS Box

INF: Named Pipes Connectivity Unstable on Windows NT 3.5

INF: Native Mode BCP to Mis-Defined Table Loads Incorrectly

INF: Need to Init. New Dump Device When Backing Up From Srv

INF: Net-Library Reports OS and Network Errors

INF: Network Encryption Available Using Multi-Protocol NetLib

INF: Network-Independent Way to Shut Down ODS Application

INF: New Parameter Options for Service Pack Setup

INF: New RPC Connect Error Messages

INF: New Server Message 8113 Introduced in SQL 4.21a

INF: No Conflicts Between DBO and Aliased DBO in SQL Server

INF: No Results From SQLDescribeParam or SQLProcedureColumns

INF: No Timestamp Is Returned by dbtsnewval() If Update Fails

INF: NOLOCK or READ UNCOMMITTED Causes Error 605

INF: Novell NET.CFG Parameters

INF: Number of Connections for SQL Server 6.5 Win16 Clients

INF: Object Names Cannot be Variables in TRANSACT-SQL

INF: ODBC ANSI Upgrade Changes From SQL Server 6.0 to 6.5

INF: ODBC Catalog Functions in Static Cursors

INF: ODBC Connections to Sybase SQL Servers

INF: ODBC Messages on SQL Server Connections

INF: ODBC ODS DSN

INF: ODBC SQL Server Connection Parameters

INF: ODBC SQL Server Driver Server Messages

INF: ODBC/OLEDB Connect Options not Seen When Tracing Connection

INF: ODBCPING.EXE to Verify ODBC Connectivity to SQL Server

INF: ODS Gateway Sample Application Does Not Support BCP

INF: OLAP Services Not Supported on a Domain Controller

INF: OLAP: How to Index Star/Snowflake Schema Data

INF: OLAP: MSSQLServerOLAPService Should Use Domain Account

INF: Open Data Services for OS/2 Unsupported on Windows NT

INF: Operating System Commands, Control of Flow in ISQL or OSQL

INF: Optimizer Index Selection with Stored Procedures

INF: Optimizing Comparisons with Numeric, Integer, and Others

INF: Optimizing Distributed Query with Numeric Predicates

INF: Optimizing Microsoft SQL Server Performance

INF: Order of Installation for SQL Server 7.0 Clustering Setup

INF: Output Parameters, Return Codes and the ODBC Driver

INF: Overview of SQL Server, ODBC, and DB-Library Cursors

INF: Page Locks of Large Insert Trans Not Promote Table Lock

INF: Parameters and Execution Options for SQL Monitor

INF: Permission Needed for Administering an OLAP Server

INF: Placing SQL Error

INF: Priority Plus Database Server Support Offering

INF: Procedure for Testing Named Pipes

INF: Processing DBCC Commands in ODBC applications

INF: Processing Procedures and Batches with Multiple SELECTS

INF: Processing Time for Update/Delete Transactions

INF: Programming 32-bit OS/2 DB-Library Applications

INF: Programming DB-Library TSR with MS-DOS Extenders

INF: Proper SQL Server Configuration Settings

INF: Proper Use for DB-Library Err Handler Return Code INT_EXIT

INF: Proper Use of the COLUMNS_UPDATED() Function

INF: Protocol Error in TDS Stream Causes Function Sequence Error

INF: Providing Application Security Through Triggers in SQL

INF: Purpose of TRUNCATE TABLE

INF: Q+E and MS Query Can Cause Long-Term Page Lock

INF: Quick Method for Reinstalling SQL Server

INF: QUOTED_IDENTIFIER and Strings with Single Quotation Marks

INF: RAISERROR, PRINT, and the MS SQL Server ODBC Driver

INF: Reading ODBC SQL Server Driver Network Messages

INF: Readme.txt for SQL Server 6.5 Service Pack 5a

INF: Readme.txt for SQL Server 7.0 Service Pack 1

INF: Readme.txt for SQL Server 7.0 SP2 Beta

INF: Readpipe Return Codes

INF: Reasons Why SQL Transaction Log Is Not Being Truncated

INF: Rebuilding the MSDB Database in SQL Server 6.0 and 6.5

INF: Rebuilding the Pubs Database

INF: Recommended SQL Server for WinNT Memory Configurations

INF: Recoverability and Transaction Log Dumps

INF: Recovering a Full Master Database

INF: Recovering from Media Failure in SQL Server

INF: Reducing Lock Contention in SQL Server

INF: Registering SQL 6.0 Servers from a 6.5 SEM Workstation

INF: Relationship of the ODBC Driver to INSTCAT.SQL

INF: Remote Procedure Calls with Sybase SQL Servers

INF: Remote Sites and OS/2 Threads

INF: Removing Duplicate Rows from an Existing Table in SQL

INF: Removing SVS From Node SQL Server Was Not Installed On

INF: Renaming SP, View or Trigger Does Not Update SYSCOMMENTS

INF: Replication and SQL Server Versions

INF: Replication and Windows NT Server Network Configuration

INF: Replication Setup Over a Firewall

INF: Replication: Cleanup Task Takes a Long Time to Complete

INF: Replication: How to Rebuild the Distribution Database

INF: Resolving Client-Side VINES Connectivity Errors w/ SQL

INF: Resolving Deadlocks With Distributed Transactions

INF: Resolving Server-Side Vines Connectivity Errors w/ SQL

INF: Restoration of a Database from Transaction Dumps

INF: Restricting Access to Master Database in SQL Server

INF: Restrictions for Multi-Table Outer Joins

INF: Restrictions on the Use of Xp_sqlinventory

INF: Result Processing for SQL Server

INF: Retrieving Current Timestamp from Data Row

INF: Retrieving IDENTITY Value for Referential Integrity

INF: Return Value Precedence in Stored Procedures

INF: Rollback from Within Triggers

INF: RPCs from NT SQL Server to Sybase UNIX SQL Server

INF: Run English SQL with Code Page 950 on English Windows NT

INF: Run Task May Cause 1722 Error

INF: Running MS-DOS/Windows DB-Lib Applications in Lanserver

INF: Running SQL Server 6.5 INSTCAT.SQL on SQL Server 6.0.

INF: Running SQL Server on DEC Pathworks

INF: Running SQL Versions 6.0 and 4.21 Side by Side

INF: Sample of SQL-DMO Connection Point Interface

INF: Scoping of Temporary Objects with EXEC

INF: ScriptPkg Tool Generates DTS Object Model Code

INF: Search Arguments That Determine Distribution Page Usage

INF: SELECT INTO or Trans Mgr Can Unexpectedly Update NULL Col

INF: Selectively Disabling Logging

INF: Server Configurations Transferred During 7.0 Upgrade

INF: SET SHOWLPLAN and the MS SQL Server ODBC Driver

INF: SET STATISTICS and the Microsoft SQL Server ODBC Driver

INF: Setting Application Name

INF: Setting Packet Size Using VBSQL

INF: Setting up Bidirectional Replication

INF: Setting Up RPCs Between Sybase and SQL Server for OS/2

INF: Setting Up Servers to Use Remote Procedure Calls

INF: Setting Up SQL Srv to Listen on Banyan VINES Net-Library

INF: Shared Access to Modified Data

INF: Size Restrictions for dbsqlexec(), dbcmd(), and dbfcmd()

INF: Sizing Considerations for SQL Databases

INF: Small Business Server 4.5 SQL Server 7.0 Limitations

INF: Small Windows DB-Library Sample Application

INF: SMS 2.0 Evaluation and SQL Server 7.0 Evaluation

INF: Sorting Data Out of SQL Server

INF: Sorting Dimension Members in OLAP Services

INF: sp_configure Parameters Affect Memory Usage by SQL Server

INF: sp_dbcmptlevel 'master' is not Allowed

INF: Sp_fkeys Does Not List Keys Identified by Sp_foreignkey

INF: Sp_foreignkey Does Not Automatically Create a Common Key

INF: Specifying Connection String for an Alternate Pipe

INF: Specifying Priority for Deadlock Victim Selection

INF: SPs

INF: SQL 7.0 Remote Unattended Install

INF: SQL Access Permissions and Trigger Execution

INF: SQL Administrator Drop Command Drops Databases

INF: SQL Clustered and Non-Clustered Index Sort Work Area

INF: SQL Communication Errors 17832, 17824, 1608, 232, and 109

INF: SQL Logs 17832 with Multiple TCP\IP Connection Requests

INF: SQL NT Thread Pooling

INF: SQL Server 6.0 ODBC Driver Changes Tempdb Usage

INF: SQL Server 6.5 Performance Analysis

INF: SQL Server 6.5 SP2: Distribution Task Name Changes

INF: SQL Server 7.0 BCP and Code Page Conversion

INF: SQL Server 7.0 Books Online Points to Personal Support Page

INF: SQL Server 7.0 Service Pack 1 Fixlist

INF: SQL Server 7.0 Startup Parameters

INF: SQL Server and Caching Disk Controllers

INF: SQL Server and ODS for OS/2 Do Not Use DBNMPP.DLL

INF: SQL Server and ODS Sample Gateway on One Machine

INF: SQL Server Client Memory Required for Open Connection

INF: SQL Server Code Pages and AutoAnsiToOem Behavior

INF: SQL Server Databases Not Supported on Compressed Volumes

INF: SQL Server DTS and the Microsoft Repository

INF: SQL Server Extent Allocation Information

INF: SQL Server Issues Related to SMS

INF: SQL Server Knowledge Base Articles Available as Help File

INF: SQL Server May Not Be Detected as Windows NT Version

INF: SQL Server ODBC Driver Performance Analysis Tools

INF: SQL Server Performance Analysis

INF: SQL Server RPC Uses Make/Break Connections

INF: SQL Server SELECT with HOLDLOCK Transaction Information

INF: SQL Server Setup Requires 4MB Where Master.dat Is Located

INF: SQL Server Shuts Down When Master Database Is Reloaded

INF: SQL Server Support for OS/2 Version 2.1

INF: SQL Server Support for the Euro Currency Symbol

INF: SQL Server Tools Save Files in OEM Format

INF: SQL Server Truncates Program Name and Host Name

INF: SQL Server Truncation of a DBCS String

INF: SQL Server Update Transaction Log Information

INF: SQL Small Business: Licensing, Connections, Limitations

INF: SQL Troubleshooters Available on the Web

INF: SQL70IOStress Utility to Stress Disk Subsystem

INF: SqlCursorClose Documentation Incorrect

INF: SQLDescribeParam Not Supported in Queries with Union Clause

INF: Sqldiag.exe Can be Included in an MSDE Custom Setup

INF: SQLGetInfo Returned with SQL_PRESERVE_CURSORS

INF: SQLMail Concurrency and the Kill Command

INF: SQLPrepare and Temporary Stored Procedures in SQL Server

INF: SQLProfiler From Command Line Parameters to Temp File Usage

INF: SQLSTRES-Sample DB-Library Application for Windows NT

INF: Starting SQL Server Remotely from the NT Command Prompt

INF: Starting with Minimal Configuration Removes Tempdb Fragment

INF: Storage of SQL Server's Error Log on Stand-Alone Server

INF: Stored Proc to Remove Replication Info

INF: Stored Procedures Can Be Nested 16 Levels Deep

INF: Stored Procedures, Transactions, and Error 266

INF: Storing a Dir. Tree and Maintaining a Full Path w/ Triggers

INF: Storing UTF-8 Data in SQL Server

INF: Subquery Column Can Be Resolved as Outer Query Column

INF: Support for Network Database Files

INF: Support for Referential Integrity in SQL Server

INF: Support of Page and Table Locking in SQL Server

INF: Support Users' Groups and Prof. Associates

INF: Supported Windows Versions for SQL Server

INF: SYSPROCESSES Table to Display Resource Information

INF: System Configuration Changes Seem to Not Take Effect

INF: Sytos Tape Errors Returned by SQL Server for OS/2

INF: Table Alias Syntax Checking in SQL 6; Now ANSI Compliant

INF: Table Locking De-Escalation

INF: Temporary Tables and Cursors

INF: Temporary Tables and Logging

INF: Testing Methods for SQL Server Tape Dumps or Loads

INF: Text/Image Data Page Calculation Formula Is Wrong

INF: The 'I/O - Transactions/sec' Counter in SQL Perf Monitor

INF: Timestamps and Their Uses

INF: Tips for Debugging Stored Procedures from VC++

INF: Tips for Debugging Stored Procedures from Visual Basic 5.0

INF: Tips for Setting Up NIK on Novell NetWare Networks

INF: Trace Flag 8816 to Help Year 2000 Conversion

INF: Trace Flag to Replicate UPDATE as DELETE/INSERT Pair

INF: Tracing SQL Generated by MS SQL Server ODBC Driver

INF: Transaction Log Still Full After DUMP TRAN WITH NO_LOG

INF: Transferring Tables and Data from Paradox to SQL Server

INF: Translating DBMONEY Datatype into Actual Dollar Amount

INF: Trapping Error Messages Sent to Clients from a SQL Server

INF: Trigger Execute Even if No Rows Affected by SQL Statement

INF: Troubleshooting Scheduled Backups

INF: Troubleshooting SQL Executive and Task Scheduling

INF: Troubleshooting SQL Security Manager Messages

INF: Troubleshooting SQLMail with Microsoft Exchange Server

INF: Troubleshooting SQLMail with Post Offices

INF: Two-Phase and Three-Phase Commit Information

INF: Understanding and Resolving SQL Server Blocking Problems

INF: Understanding Bufwait and Writelog Timeout Messages

INF: Understanding How the Transact-SQL KILL Command Works

INF: Understanding Microsoft Repository

INF: Understanding MSscheduled_Backups Entries

INF: Understanding Page Estimates

INF: Understanding Worktables Used by Server Side Cursors

INF: Unicode String Constants in SQL Server Require N Prefix

INF: Unsubscribe/Delete Publication Takes Too Long or Deadlocks

INF: Update Methods Used in SQL Server 6.0

INF: Update Statistics Causes Shared Table Lock

INF: UPDATETEXT Must Be Run in the Published Database

INF: Updating a Row a Second Time in Browse Mode

INF: Updating Column in One Table w/ Column from Another Table

INF: Updating Text/Image Columns With Cursors

INF: Updating Values in Columns Used by dbqual in Browse Mode

INF: Upgrading From SQL Server 7.0 Evaluation to Retail Version

INF: Use of DBCC GAMINIT

INF: Use of Multiple Unique Indexes by dbqual in Browse Mode

INF: Use of sp_fixindex

INF: Use of Thread Local Storage in an Ext. Stored Procedure

INF: Use User-Defined Data Type to Extract Current Time

INF: User-Defined Counters Do Not Show Up Correctly in Perfmon

INF: Using a Prepared Cursor in Embedded SQL for COBOL

INF: Using a Stored DATETIME Key for Data Retrieval

INF: Using a Stored Procedure in a Cursor Definition

INF: Using Banyan VINES Common Login with SQL Server

INF: Using Batch Sizes with the BCP Utility

INF: Using BCP

INF: Using BCP to Import Image Data into SQL Server

INF: Using BCP to Import NULL Values into Datetime Columns

INF: Using BCP to Load Data into SQL Table with Unique Index

INF: Using BCP When Data is in Quotation Marks

INF: Using BCP When Data Is Within Quotation Marks

INF: Using Browse Mode in DB-Library

INF: Using Cursors to Return Results in Embedded SQL for COBOL

INF: Using DB-Library Functions From a Windows DLL

INF: Using DB-Library with Borland C++

INF: Using DB-Library with C++

INF: Using DB-Library with Visual C++

INF: Using DBCC BUFCOUNT to Configure HASH BUCKETS

INF: Using DBCC FIX_AL

INF: Using dbdata() Versus dbbind()

INF: Using DBLIBRARY in a threaded application

INF: Using Disk Drive Caching with SQL Server

INF: Using Double-byte Character Sets with SQL Server

INF: Using ESQL in a Threaded Application

INF: Using FOR BROWSE on a View in SQL Server

INF: Using Hard Disk Controller Caching with SQL Server

INF: Using Return Codes with xp_cmdshell Stored Procedure

INF: Using Separate Connections for Update in Browse Mode

INF: Using Smart Pointers to Simplify SQL-DMO

INF: Using SQL Db-Lib Calls in Multithreaded Programming

INF: Using SQL Server 6.5 DMO Against a SQL Server 6.0 Server

INF: Using SQL Server Web Assistant's 'When Data Changes' Option

INF: Using SQL Transfer Manager Against a Sybase NLM

INF: Using SQLMail with a NetWare Post Office

INF: Using Substring to Parse

INF: Using Sytos Plus for Backup

INF: Using TCP/IP Socket Net-Library in Windows for Workgroups

INF: Using Temporary Tables with Stored Procedures/Triggers

INF: Using the '*=' and '=*' (Outer Join) Operators

INF: Using the DTS Wizard to Insert into Identity Columns

INF: Using the NUMERIC_ROUNDABORT SET Option

INF: Using the WITH MOVE Option with the RESTORE Statement

INF: Using Transact-SQL SET Options in DB-Library Application

INF: Using Version 3.6 Microsoft SQL Server ODBC Driver

INF: Using Windows Global Heap Buffers

INF: VB .DEP Files not Available for SQL 7.0 Redist. Components

INF: Verify Registration of SQL Servers in NetWare Binderies

INF: Views Cannot Be Used in Browse Mode

INF: WAITFOR ERROREXIT/PROCESSEXIT Wake-Up Conditions

INF: Waiting for Access to Modified Data

INF: What Happens When UPDATE Performs INSERT/DELETE

INF: When and How to Use dbcancel() or sqlcancel()

INF: When Dirty Cache Pages Are Flushed to Disk

INF: When to Use Tempdb in RAM

INF: Why dbqual() Returns Null WHERE Clause in Browse Mode

INF: Why SHOWPLAN Shows Query Using 'Dynamic Index'

INF: Why Syslogs Has Exclusive Table Lock During Dumps

INF: Writing Efficient Queries and Stored Procedures

INF: xp_cmdshell Does Not Retrieve User Input

INF: xp_enum_oledb_providers Enumerates the OLE DB Providers

INF: xp_param Sample Requires SQL 7.0 Srv.h File to Compile

INF:Foreign Key Constraint Behavior of Nullable Composite Keys

INF:How to Move, Copy

INF:Listing the Results of a SELECT Query on Table Using SQL-DMO

INF:Setting up SQL Server 6.5 for Integrated Security in Cluster

INFO: Connecting to SQL Server from TCP/IP Sockets Clients

INFO: Converting Binary Data to Hexadecimal String

INFO: Frequently Asked Questions About Microsoft SQL Server

INFO: How to Schedule Backup

INFO: MDAC 2.1 Sets Session Pooling ON by Default

INFO: Network Database Devices Unsupported

INFO: New NO_INDEX Option for SQL Server for Windows NT

INFO: OS/2 SQL Server Run-Time and OS Error Codes

INFO: SQL Row Size Limited to 1962 Characters

INFO: SQL Server and Windows NT Thread Scheduling

INFO: SQL Server Driver May Return Fractional Truncation Msg.

INFO: SQLMonitor Service Terminates if SA Password Changes

PRB: 'Cannot Open Default Database

PRB: 'Event ID (1001) in Source (SQLCTR70) Could Not Be Found'

PRB: 'Login Incorrect' Error from Q+E under NetWare NIK

PRB: 'Network Not Started' Error in SQL Administrator

PRB: 'Out of Memory' Error When Using VBQUERY Sample App

PRB: 'Record Has Been Changed' Error After Upsizing

PRB: 'Unknown Reference' Error with OLAP Sample Projects

PRB: #deleted Seen When Opening SQL Server 7.0 Tables

PRB: 'Temp_db' Device Causes Problems Starting SQL Server

PRB: 'Unable to Connect' Message with SEM Object Transfer

PRB: @@error Not Set After Overflow or Divide-by-Zero Error

PRB: 16-bit Installer May Create Bad ODBCINST.INI

PRB: 6.0 Transfer Manager With Dependencies Causes Error 145

PRB: 6.5 SP4 May Affect Replication Performance

PRB: ANSI_NULLS OFF Behavior in SQL Server 6.x and 7.0

PRB: Anti-virus Program May Cause Named Pipes Connection Problem

PRB: Assignment of NULL Value to Local Variable in SQL

PRB: Autostart Task Fails and Does Not Restart Automatically

PRB: BACKUP with NO_TRUNCATE Not Possible with Missing .MDF File

PRB: BCP Default of smalldatetime Uses Jun 8, 1932

PRB: BCP Ignores Rules and Triggers

PRB: BCP Out Does Not Allow Columns to Be Skipped

PRB: BCP Truncates Data when Data Length Is Too Long

PRB: bcp_sendrow Will Not Time-out

PRB: Building Clustered Index on Empty Table Does Not Move

PRB: Calculating Memory Used By Locks in SQL Server

PRB: Calling dbnullbind With No dbbind Causes Error 1044

PRB: Can Not Alter TEMPDB When in RAM

PRB: Cannot Administer SP1 OLAP Server from RTM OLAP Manager

PRB: Cannot Call W3DBLIB.DLL Functions from Macro Languages

PRB: Cannot Change SA Password in Enterprise Manager

PRB: Cannot Create FK Relationship Using Design Table Interface

PRB: Cannot Insert Money/Float Larger Than 2147483647

PRB: Cannot Install Enterprise Edition on Windows NT Server

PRB: Cannot Install SQL Server 7.0 EE on WinNT Server 4.0 EE

PRB: Cannot Perform Remote Upgrades on OS/2 SQL Server

PRB: Cannot Register Server if Password Exceeds 60 Characters

PRB: Cannot Register Server in SEM Due to Insufficient Memory

PRB: Cannot Reinstall SQL Server After Deleting Files Manually

PRB: Cannot Use /Zp Compiler Option With DB-Library

PRB: Cannot Use dbclose() or dbexit() in an OS/2 Exit Routine

PRB: Changing Ownership of a Database

PRB: Changing Registry Key Causes Evaluation Copy Error MSG

PRB: Cleanup Takes Too Much Resources, Cannot Run Multiple Times

PRB: Client Login Does Not Time Out If the Server Is Offline

PRB: Cluster Group Containing SQL Server and MS DTC Moves Slowly

PRB: Common Problems Using dbfcmd

PRB: Connect to SQL on NT 3.5 from WFW 3.11 via Named Pipes

PRB: Connection Problems from NT Clients via IPX/SPX

PRB: Connectivity Problems Using 16-Bit Multiprotocol Net-Lib

PRB: Constraint Violation Not Detected If Update with Same Data

PRB: CONVERTing Character to an Integer Causes Syntax Error

PRB: CPPOlapDemo: Olap.h File Not Included in Sample

PRB: CREATE TABLE Appears to Ignore IF Statements

PRB: Current Activity in SEM May Not Be Displayed

PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS

PRB: Data Designer Does Not Support CASE Statements in Views

PRB: Database Dumps and Restore May Fill Up MSDB Database

PRB: DATALENGTH Function NULL Argument Documentation Error

PRB: DATEADD Doesn't Work When Using a Variable as a Date

PRB: DB Marked Suspect; Operating System Error 5 (Access Denied)

PRB: DB w/ Separate Log on Same Device Can Result in Msg 4205

PRB: DB-Library Application Exits to Command Prompt

PRB: DBCC Reports Page Count Discrepancy on SYSLOGS Table

PRB: DBCC SQLPERF(LOGSPACE) Limited by sp_configure Parameters

PRB: DBMSSOC3 Fails if TCP Session Setup Takes More Than 5 Sec

PRB: Dbmsspx3.dll Does Not Support Larger TDS Packet Size

PRB: dbopen Error Code Documentation Incorrect

PRB: dbopen() Execution Time Degrades

PRB: dbwritetext Returns SQL Server Message 156

PRB: Deadlock May Be Encountered When Using UPDLOCK Hint

PRB: DECLARE CURSOR on Table Created in Stored Proc Fails

PRB: Deleting More Than 100 Tasks w/Sp_droptask Causes Msg 21003

PRB: Deleting Records Containing NULLs Using DAO

PRB: Differences Between DMO 7.0/DMO 6.5 With ExecuteWithResults

PRB: Dist. Query Involving External Provider Not Supported

PRB: Division by Zero Displays Results in Strange Format

PRB: Documentation for GROUP BY Clause Is Incorrect

PRB: Documentation of sp_configure Devices Incorrect

PRB: Double Quotation Mark Params Error w/ Quoted Identifiers

PRB: Dropping Connections from Sybase TCP/IP Socket Clients

PRB: DTS Does not Copy Identity, Indexes, or Other Constraints

PRB: DTS May Skip More Rows than Specified for Fixed-Length File

PRB: DUMP TRAN Cannot Complete While DBCC NEWALLOC Is Running

PRB: DUMP/LOAD with Tape May Be Slower on Windows NT 4.0

PRB: Dumping to New Dump Device w/ INIT Causes Dbsvolopen Error

PRB: Duplicate Dimension Key 'Product' in VBDSOCreateSmallCube

PRB: E_FAIL Message When Accessing OLAP BobsVid.cub File

PRB: Err 1007: The Number '

PRB: Err: Unable To Get Replication Information...Table %1!d!%

PRB: Error 'Can not find NETAPI.DLL' Under MS Client

PRB: Error 10001: NULL DBPROCESS Pointer Encountered

PRB: Error 1314 Raised By xp_cmdshell When Executed Non-SA User

PRB: Error 17832 Caused by Blocking Timeout in 16-Bit Sockets

PRB: Error 18482: 'Unable to Connect to Site . . .'

PRB: Error 206 While Processing a Large Cube

PRB: Error 601 Occurs When Accessing a Database

PRB: Error 7129 If Concurrent Processes Update Same Text Page

PRB: Error 8104 Occurs w/ Non-Admin Owner w/ Set IDENTITY_INSERT

PRB: Error Attempting to Insert Explicit Values w/ Append Query

PRB: Error C2061 in Visual C++ with Odssamp.dll

PRB: Error Creating Stored Procedure

PRB: Error Log Shows One Transaction Rolled Forward on Startup

PRB: Error While Running SQL Cluster Setup.exe

PRB: ErrorNum 10034 When Calling SqlSetOpt%()

PRB: Errors Creating Recursive Stored Procedures

PRB: ESQL: Error When Compiling COBOL Application in OS/2 2.0

PRB: ESQL: Errors When Linking COBOL Applications for MS-DOS

PRB: ESQL: R6009 - Out of Environment Space

PRB: Extra Insert_page Locks Held on a Page Split with IRL

PRB: Filter on Saved Profiler Trace Replaces Previous File

PRB: Four-Digit Year Expected When Scheduling Tasks or Jobs

PRB: Full-Text Catalog Lost After Restoring Suspect Database

PRB: GO as 1st Word on Line Treated as Batch Terminator

PRB: Guarantee @@IDENTITY Value on a Per Table Basis

PRB: High Column of the Sysdevices Table Used for Dump Devices

PRB: Host_name() Function Returns NULL Value

PRB: How to Use sp_displayoaerrorinfo in the sp_OA Samples

PRB: IF UPDATE Trigger with No Rows Changed

PRB: Improving Response Time When Communicating over Network

PRB: Inconsistent Messages Returned When EXEC Is Run on a Table

PRB: Incorrect Log Size Reported in SEM or Performance Monitor

PRB: Incorrect Registry Permissions Causes Problems w/ Setup

PRB: INSERT INTO EXECUTE Holds EX_PAGE Locks on System Tables

PRB: Install Path w/ Spaces Causes SQLOLE Errors

PRB: Intermittent AV During Message Handling on RPC Calls

PRB: ISQL Without -U Parameter Uses Network User Name

PRB: Issuing RPC to Local Server Executing Sp_sqlexec May Fail

PRB: Keyset Cursor Based Off a Join Not Showing New Records

PRB: Last Distributor JobID

PRB: LOAD HEADERONLY May Fail to Return All Rows

PRB: Loading Transaction Log Dumps into MSDB Fails w/ Error 4306

PRB: LRU List Empty Errors Can Make the Server Stop Responding

PRB: Making DB-Library Calls in a User-Defined DLL

PRB: Maximum TEXTSIZE in OSQL and ISQL

PRB: Message 18456 from a Distributed Query

PRB: Messages Blocked with SQLMail and Exchange Client

PRB: MFC Function May Incorrectly Parse a Date After Year 2000

PRB: Microsoft ESQL for C Generates Compiler Error w/ an Array

PRB: Missing Device Causes Database to Be Marked Suspect

PRB: Moving Fallback DB Back to Primary Svr May Cause Error 913

PRB: MS-DOS Client Cannot Connect If More Than 20 Files Open

PRB: MS-DOS Workstation Fails to Connect with SQL and SQLTESTR

PRB: MSDE Unattended Install Needs Full Path Name of .iss File

PRB: Msg 3201 When Attempting to Dump or Load Database

PRB: Msgs. 20515, 21054, or 20512 w/ Immediate-Updating Subscr.

PRB: MSVCRT20.DLL May Cause SQL Setup to Stop

PRB: New Datasource Configuration Options in SQL Server 6.5

PRB: No Error If UPDATE or DELETE Processes 0 Rows

PRB: No Error Occurs When Adding Trigger That Exists

PRB: No RAISERROR in sp_password

PRB: No Size Change When Dump Overlaid Over Previous Dump

PRB: Non SA CmdExec Task or Xp_cmdshell May Cause Error 1314

PRB: Non-Windows NT Admins May Not See or Save SQLTrace Filters

PRB: ODBC Connection Failed: SQLState: '08001' DBMSSOCN

PRB: ODBC DSN Issue when Browsing Cube Data on OLAP Server

PRB: ODBC Prepared Statement Errors with Temporary Tables

PRB: ODS Does Not Support Bulk Load

PRB: OPTIMIZER LOCK HINTS Error with OpenQuery

PRB: Outgoing SQLMail Messages Blocked and Not Sent

PRB: PRB: Dealing with Locks and Timeouts in DB-Library

PRB: PreBuildServer Error During SQL 7.0 Setup

PRB: Pressing ESC When Modifying SP in SEM Erases Changes

PRB: Problem Creating New Login

PRB: Problems When DBCS Code Page Is Missing in Windows NT

PRB: Problems When W3DBLIB.DLL is Loaded at Run-Time

PRB: Problems with Altering Model Database to Move Syslogs

PRB: Procedures May Fail w/ Msg 2821 After v.6.0 Upgrade

PRB: Process All Results to Find Number of Rows Affected

PRB: Profiler Errors If Connected with SQL Authentication

PRB: Proper Handling of the Escape Sequence \

PRB: Pull Replication Setup May Encounter SQL-DMO Error 21770

PRB: Quick Links from SQL Server 7.0 Support Highlights Page

PRB: Reasons for Error 10008: Bad Token from SQL Server

PRB: Reasons for Receiving Message Numbers 3115 and 3116

PRB: Reformatting Used in Stored Procedure with Temporary Table

PRB: Registry Permission Difference w/ OLAP on Windows 2000

PRB: Remote Stored Procedure Call Fails with Error 7221

PRB: Renaming a Table in Table Designer Gets No Warning Msg

PRB: Repl Logreader Fails on Remote Dist. after Cluster Failover

PRB: Replication Must be Removed Before Applying Service Pack

PRB: Replication Subscribers Unable to Synchronize w/ Pull Sub.

PRB: Replication Tasks Don't Print Full Info on Error/Deadlock

PRB: Replication: Distribution Task Timeout Expired

PRB: Restore Master In Enterprise Manager Generates Error

PRB: Rolling Back Individual Rows from an INSERT Trigger

PRB: Running Multiple DBCC Commands Can Raise Spurious Errors

PRB: Running Out of Log Space When Running Large Bulk Loads

PRB: Select From Database on CD-ROM May Return Error 601

PRB: SELECT INTO Fails Inside a User-Defined Transaction

PRB: SEM Does Not Allow You to Indicate Manual Sync Complete

PRB: SEM Error 'Cannot Start Transaction While in Firehose Mode'

PRB: Server May Stop Responding or Get an AV w/ Low Open Objects

PRB: Service Pack Setup May Fail If Probe Login or User Deleted

PRB: Slow SQL Server Connections Using Named Pipes with Win 95

PRB: Small Business Server and SQL Server Licensing Msg 18458

PRB: Some Database Tables Are Not Available for OLAP Cubes

PRB: Sp_addlinkedserver Does Not Validate the OLE DB Provider

PRB: Sp_helpdevice Shows Multiple Devices with Device_number 0

PRB: sp_helptext Appears to Add

PRB: Sp_makewebtask Truncates Embedded Text Columns

PRB: sp_processmail Gets Ambiguous Recipient Error

PRB: SQL 7.0 Failover Wizard Error when Updating Binaries

PRB: SQL 7.0 Upgrade Fails w/ 'Could not find stored procedure'

PRB: SQL Admin Cannot Display History for Scheduled Dumps

PRB: SQL Admin: Small Unreadable Fonts in Query Window

PRB: SQL Administrator Hangs When Viewing Error Log on Novell

PRB: SQL Directory Is Not in the Service Path Until a Restart

PRB: SQL Distributed Query w/ Oracle 'Could not open table' Err

PRB: SQL Distributed Query with Oracle Needs Oracle Client and N

PRB: SQL Distributed Query with Oracle NUMERIC Column Gives Erro

PRB: SQL Executive Service Fails to Start

PRB: SQL for NT Not Report Time Change Without Restart

PRB: SQL Performance Counters Missing in Performance Monitor

PRB: SQL Performance Monitor Counters Missing

PRB: SQL Performance Monitor Fails to Catch Statistics

PRB: SQL Server and C2 Security

PRB: SQL Server COM Object Persistence Model

PRB: SQL Server Connections Not Closed from Visual Basic

PRB: SQL Server Cursor Type May Change From Dynamic to Keyset

PRB: SQL Server Does Not Detect the Addition of the 33rd Segment

PRB: SQL Server Err 'BackupTapeFile::WriteFileMark: Write...'

PRB: SQL Server Error 1608 in Errorlog

PRB: SQL Server May Appear to Stop Responding Upon Startup

PRB: SQL Server Msg 4002: Login Failed; Login Incorrect

PRB: SQL Server ODBC Driver Converts Language Events to Unicode

PRB: SQL Server Setup Appears to Stop Responding

PRB: SQL Server Won't Start After Setting TEMPDB IN RAM Too High

PRB: SQL Service Manager Shows Indeterminate for Non-Admin User

PRB: SQL Transfer Manager Fails with Destination/Source Error

PRB: SQL-DMO Operations on SQL Server 7.0 Uses More Memory

PRB: SQLDiag Output Incomplete Against Clustered Server

PRB: SQLExecutive Does Not Respond to SCM; Error 2186

PRB: SQLMail Always Saves Sent Mail with Exchange Client

PRB: SQLMail Functions Hang on MAPI Error

PRB: SqlMaxProcs% Documentation Incorrect

PRB: SQLServerAgent Service Does Not Start After Unclustering

PRB: Srv. Mgr. Icon Not Created w/ Install of NT Client Util.

PRB: Stored Procedure Scripts Not Generated in Dependency Order

PRB: SVS Can Not Run on Other Node After Node Rebuilt

PRB: SVS Will Not Report as Online Without Named Pipes

PRB: Syntax Error with Sp_dropkey on SQL Server 6.0

PRB: Syntax Errors When Precompiling ESQL for C

PRB: Tape Backup Fails w/ Error 87 on SQL Server Service Pack 5a

PRB: Tape Backup Is Unsupported on Windows 95/98 Computers

PRB: Temporary Directory Left by InstallShield After Setup

PRB: Too Many User Connections Keep SQL Server from Starting

PRB: Transaction Log Partially Truncated

PRB: Two Digit Year Display of Date Fields in SQL Enterprise Mgr

PRB: Unable to Back Up Database to Network Drive w/o Permissions

PRB: Unable to Connect to Stand-Alone SQL Server

PRB: Unable to See VIEWs w/ Query Builder in DTS Import/Export

PRB: Unresolved Merge Conflicts With Constraints And Triggers

PRB: Updating a Database Sysindexes Table

PRB: Upgrading Beta to Final v6.0 Could Cause AV in SEM

PRB: Upgrading Replication Settings May Fail When Inserting Rows

PRB: Use BUILTIN\Group to Grant Access to Predefined Groups

PRB: Use of Clustered Index Improves Self-Join Performance

PRB: User '_' Not Defined as a Valid User of Trusted Connection

PRB: User Logon and/or Permission Errors After Restoring Dump

PRB: Using a Self-Join to Produce a Cartesian Product

PRB: Using BldMastr to Reset System Configuration

PRB: Using COMPUTE with Converted Columns

PRB: Using DISK REFIT Versus DBCC DROPDB on Damaged Databases

PRB: Using SQL 6.5

PRB: Using WHERE with OR or IN Can Slow Down Performance

PRB: View Created with a Subquery Cannot Be Updated

PRB: View Designer Errors if Query Cannot Display Graphically

PRB: When to Use bcp_columns() and bcp_colfmt()

PRB: Why SQL Server Error Log Contains 'Open Objects' Warnings

PRB: Windows NT Error 2140 When Starting SQL Server

PRB: XP_CMDSHELL Does Not Work with XCOPY

PRB: Xp_sendmail with Query May Cause Deadlocks in SQLMail

PRB: Zero Rows Returned from SQL SELECT Statement

PRB:'Unspecified Error' Executing DTS Pkg Modified Dynamically

PRB:Case-Sensitive Unicode Collating Sequence

PRB:Enterprise Manager Requires Uppercase for Linked Server Name

PRB:Log Segment Moved to Device Incorrectly if Tempdb Expanded

PRB:RebuildM Cannot Find Original Master Database Files for MSDE

PRB:SQLExtendedFetch w/ SQL_FETCH_RELATIVE Fails to Return Recs.

PRB:Transfer Objects Fails if SP Preceded by Multi-line Comment

Q? SQL Server Driver 2.50 is DBCS-Enabled

SAMPLE: Embedcgi.exe CGI Application Using Embedded SQL

SMS: SQL Server Tuning Parameters for Systems Management Server

SQL 7.0 Install on Windows 98 Creates Error 'Assertion Failed '

SQL Server 6.5 Resource Kit Missing Sp_fixlogins Tool

SQL Server Utility Files Available