Troubleshooting Overview
Troubleshooting Planning
Viewing Error Logs
Online Troubleshooters from PSS
Help with Backup and Restore
Help with Connectivity
Help with Data Transformation Services
Help with Distributed Queries
Help with Full-Text Search
Help with Performance
Help with SQL Profiler
Help with Replication
Help with Setup
Help with Startup
Help with SQL Mail
Viewing Online Troubleshooters and other PSS Web-Based Information
Frequently Asked Questions
SQL Server Books Online FAQ
SQL Server Enterprise Manager FAQ
Administration Tools FAQ
Failover Clustering FAQ
Multiple Instance FAQ
Programming FAQ
Replication FAQ
Server FAQ
Setup and Installation FAQ
Upgrading to SQL Server 2000 FAQ
Best Practices
DBCC CHECKDB Recommendations
Distributed Partitioned View Recommendations
Full-Text Search Recommendations
Multiple Instance Recommendations
Parallel Query Recommendations
User-Defined Function Recommendations
Reporting Errors to Your Primary Support Provider
Reproducing Problems
Isolating Connection Problems
Orphaned Sessions
Named Pipes Client Connections
TCP/IP Sockets Client Connections
Troubleshooting SQL Server Setup
Setup Troubleshooting: Checklist
Testing an Installation of SQL Server 2000
Informational Files Created by SQL Server Setup
Error Codes for an Unattended Installation
Troubleshooting the SQL Server Upgrade Wizard
Completing the SQL Server Upgrade Wizard
Upgrade Log Files
Server and Database Troubleshooting
Resetting the Suspect Status
Troubleshooting Alerts
Troubleshooting Backing Up and Restoring
Troubleshooting Orphaned Users
Troubleshooting Data Transformation Services
Troubleshooting Locking
Troubleshooting Deadlocks
Deadlocks Involving Locks
Deadlocks Involving Parallelism
Deadlocks Involving Threads
Troubleshooting MS DTC Transactions
Troubleshooting MSSQLServer or SQLServerAgent Services User Accounts
Troubleshooting Full-Text Search
Troubleshooting the Operating System
Appearance of Internet Connection Dialog Box at Startup of Windows 95 or Windows 98
Thread Pooling
Insufficient Virtual Memory on the Server
Insufficient Resource Space
Determining When SQL Server Causes a Windows NT Blue Screen
Troubleshooting Recovery
Recovery Performance
Insufficient Disk Space
SQL Server Tools Troubleshooting
Troubleshooting the Index Tuning Wizard
Troubleshooting SQL Mail with Exchange Server
Troubleshooting SQL Profiler
Troubleshooting SQL Query Analyzer
Troubleshooting the Web Assistant Wizard
Troubleshooting the Transact-SQL Debugger
Analysis Services Troubleshooting
Troubleshooting Development (Analysis Server)
Troubleshooting Processing (Analysis Server)
Troubleshooting Querying and Browsing (Analysis Server)
Troubleshooting Security (Analysis Server)
Troubleshooting Server (Analysis Server)
Error Messages
Error Message Formats
Error Message Numbers and Descriptions
Error Message Severity Levels
ADO Error Message Format
OLE DB Error Message Format
ODBC Error Message Format
Embedded SQL for C Error Message Format
DB-Library Error Message Format
Messages Returned by SQL Server Utilities
Error Message Descriptions
System Error Messages
Errors 1 - 999
Errors 1000 - 1999
Errors 2000 - 2999
Errors 3000 - 3999
Errors 4000 - 4999
Errors 5000 - 5999
Errors 6000 - 6999
Errors 7000 - 7999
Errors 8000 - 8999
Errors 9000 - 9999
Errors 10000 - 10999
Errors 11000 - 11999
Errors 13000 - 13999
Errors 14000 - 14999
Errors 15000 - 15999
Errors 16000 - 16999
Errors 17000 - 17999
Errors 18000 - 18999
Errors 19000 -19999
Errors 20000 - 20999
Errors 21000 -21999
Resolving System Error Messages
Error 103
Error 107
Error 109
Error 137
Error 156
Error 170
Error 207
Error 208
Error 220
Error 229
Error 245
Error 259
Error 266
Error 268
Error 511
Error 515
Error 544
Error 601
Error 602
Error 605
Error 624
Error 625
Error 644
Error 701
Error 813
Error 822
Error 823
Error 844
Error 845
Error 911
Error 913
Error 924
Error 926
Error 945
Error 1002
Error 1105
Error 1203
Error 1204
Error 1205
Error 1505
Error 1508
Error 1510
Error 1530
Error 1702
Error 1803
Error 1814
Error 1902
Error 1903
Error 1904
Error 1910
Error 1916
Error 2501
Error 2511
Error 2513
Error 2535
Error 2601
Error 2731
Error 2750
Error 2751
Error 2812
Error 3023
Error 3036
Error 3041
Error 3101
Error 3143
Error 3154
Error 3155
Error 3206
Error 3209
Error 3227
Error 3242
Error 3247
Error 3249
Error 3251
Error 3256
Error 3258
Error 3263
Error 3267
Error 3414
Error 3604
Error 3627
Error 4208
Error 4214
Error 4305
Error 4306
Error 4318
Error 5013
Error 5701
Error 5808
Error 6103
Error 6826
Error 7130
Error 7303
Error 7304
Error 7306
Error 7314
Error 7321
Error 7356
Error 7357
Error 7391
Error 7392
Error 7399
Error 7403
Error 7413
Error 8101
Error 8102
Error 8106
Error 8114
Error 8155
Error 8163
Error 8501
Error 8645
Error 8621
Error 8651
Error 8906
Error 8908
Error 8925
Error 8952
Error 8956
Error 8976
Error 8986
Error 9002
Error 17050
Error 18456
Error 18458
Error 18459
Read/Write Error
Error Log Messages
MAPI Error Messages
DB-Library, error messages
DB-Library Error Severities
Error 10008 (DB-Library)
Error 10024 (DB-Library)
Error 10053 (DB-Library)
Error 10054 (DB-Library)
Distributed Queries Error Messages
Embedded SQL for C Error Messages
SQL Server Enterprise Manager Error Messages
<0s> is not supported.
<0s> may not be used in this query type.
A relationship cannot contain more than '<0d>' columns.
Cannot add this expression to the select list.
Error modifying column properties.
Illegal expression list usage.
Information models in the specified Meta Data Services repository database must be updated in order to save this DTS package version
Object <0s> does not exist in the database.
Only one ROWGUIDCOL column is allowed per table.
SQL Verification.
System errors.
The current version of the ODBC driver is not valid.
The outer join operator (+) cannot be used in QBE.
The Query Designer supports no more than one data source for this type of query.
There are not enough columns to match the subquery select list.
Unable to add constraint.
Unable to create index.
Unable to create relationship.
Unable to modify table.
Unable to preserve trigger.
Unnecessary use of CONVERT function.
Unsupported SQL.
XML Error Messages
Errors in Annotated XDR Schemas
Errors in XPath Queries
MSXML Errors Detected During XPath Processing
ODBC Error Messages
Finding Supplemental Error Message Information
Adding User-Defined Error Messages