Msdn Sql Server Error Messages
Contents |
Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual sql server error code Labs Solutions Networking Cloud and Datacenter Security Virtualization Downloads Updates Service Packs Security Bulletins sql server error_number Windows Update Trials Windows Server 2016 System Center 2016 Windows 10 Enterprise SQL Server 2016 See all trials » Related Sites sql server 2014 error codes Microsoft Download Center TechNet Evaluation Center Drivers Windows Sysinternals TechNet Gallery Training Training Expert-led, virtual classes Training Catalog Class Locator Microsoft Virtual Academy Free Windows Server 2012 courses Free Windows 8 courses SQL Server training
Error Number -2147467259 Oracle
Microsoft Official Courses On-Demand Certifications Certification overview MCSA: Windows 10 Windows Server Certification (MCSE) Private Cloud Certification (MCSE) SQL Server Certification (MCSE) Other resources TechNet Events Second shot for certification Born To Learn blog Find technical communities in your area Support Support options For business For developers For IT professionals For technical support Support offerings More support Microsoft Premier Online TechNet Forums MSDN Forums Security Bulletins & Advisories Not an IT sql server errors and solutions pro? Microsoft Customer Support Microsoft Community Forums United States (English) Sign in Home Library Wiki Learn Gallery Downloads Support Forums Blogs We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Technical Reference Errors and Events Reference Database Engine Events and Errors Database Engine Events and Errors System Error Messages System Error Messages System Error Messages Understanding Database Engine Errors 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 12000 - 12999 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 Errors 22000 - 22999 Errors 23000 - 24999 Errors 25000 - 25999 Errors 26000 - 26999 Errors 27000 - 27999 Errors 28000 - 29999 Errors 30000 - 34999 Errors 35000 - 35999 Cause and Resolution of Database Engine Errors TOC Collapse the table of content Expand the table of content Thi
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and sql server severity levels reference Dev centers Samples Retired content We’re sorry. The content you requested
Mssql Error
has been removed. You’ll be auto redirected in 1 second. System Views (Transact-SQL) Catalog Views (Transact-SQL) Messages (for Errors)
T-sql @@error
Catalog Views (Transact-SQL) Messages (for Errors) Catalog Views (Transact-SQL) sys.messages (Transact-SQL) sys.messages (Transact-SQL) sys.messages (Transact-SQL) sys.messages (Transact-SQL) TOC Collapse the table of content Expand the table of content This documentation https://technet.microsoft.com/en-us/library/cc645603(v=sql.105).aspx is archived and is not being maintained. This documentation is archived and is not being maintained. sys.messages (Transact-SQL) Other Versions SQL Server 2012 Updated: June 10, 2016THIS TOPIC APPLIES TO:SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse Contains a row for each message_id or language_id of the error messages in the system, for both system-defined and user-defined https://msdn.microsoft.com/en-us/library/ms187382.aspx messages. For more information, see sp_addmessage (Transact-SQL).Column nameData typeDescriptionmessage_idintID of the message. Is unique across server. Message IDs less than 50000 are system messages.language_idsmallintLanguage ID for which the text in text is used, as defined in syslanguages. This is unique for a specified message_id.severitytinyintSeverity level of the message, between 1 and 25. This is the same for all message languages within a message_id.is_event_loggedbit1 = Message is event-logged when an error is raised. This is the same for all message languages within a message_id.textnvarchar(2048)Text of the message used when the corresponding language_id is active.PermissionsRequires membership in the public role. For more information, see Metadata Visibility Configuration.See AlsoTHROW (Transact-SQL)Catalog Views (Transact-SQL)Messages (for Errors) Catalog Views (Transact-SQL)Exception Message Box ProgrammingError MessagesDatabase Engine Events and Errors Community Additions ADD Show: Inherited Protected Print Export (0) Print Export (0) Share IN THIS ARTICLE Is this page helpful? Yes No Additional feedback? 1500 characters remaining Submit Skip this Thank you! We appreciate your feedback. Dev centers Windows Office Visual Studio Microsoft Azure More... Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators https://msdn.microsoft.com/en-us/library/ms188790.aspx Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers https://msdn.microsoft.com/en-us/library/ms164086.aspx Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Transact-SQL Reference sql server (Database Engine) Built-in Functions (Transact-SQL) System Functions (Transact-SQL) System Functions (Transact-SQL) @@ERROR (Transact-SQL) @@ERROR (Transact-SQL) @@ERROR (Transact-SQL) $PARTITION (Transact-SQL) @@ERROR (Transact-SQL) @@IDENTITY (Transact-SQL) @@PACK_RECEIVED (Transact-SQL) @@ROWCOUNT (Transact-SQL) @@TRANCOUNT (Transact-SQL) BINARY_CHECKSUM (Transact-SQL) CHECKSUM (Transact-SQL) COMPRESS (Transact-SQL) CONNECTIONPROPERTY (Transact-SQL) CONTEXT_INFO (Transact-SQL) CURRENT_REQUEST_ID (Transact-SQL) CURRENT_TRANSACTION_ID sql server error (Transact-SQL) DECOMPRESS (Transact-SQL) ERROR_LINE (Transact-SQL) ERROR_MESSAGE (Transact-SQL) ERROR_NUMBER (Transact-SQL) ERROR_PROCEDURE (Transact-SQL) ERROR_SEVERITY (Transact-SQL) ERROR_STATE (Transact-SQL) FORMATMESSAGE (Transact-SQL) GET_FILESTREAM_TRANSACTION_CONTEXT (Transact-SQL) GETANSINULL (Transact-SQL) HOST_ID (Transact-SQL) HOST_NAME (Transact-SQL) ISNULL (Transact-SQL) ISNUMERIC (Transact-SQL) MIN_ACTIVE_ROWVERSION (Transact-SQL) NEWID (Transact-SQL) NEWSEQUENTIALID (Transact-SQL) ROWCOUNT_BIG (Transact-SQL) SESSION_CONTEXT (Transact-SQL) SESSION_ID (Transact-SQL) XACT_STATE (Transact-SQL) TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. @@ERROR (Transact-SQL) Other Versions SQL Server 2012 THIS TOPIC APPLIES TO: SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse Returns the error number for the last Transact-SQL statement executed. Transact-SQL Syntax ConventionsSyntax Copy -- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse @@ERROR Retur
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Errors and Events Reference Database Engine Events and Errors Understanding Database Engine Errors Understanding Database Engine Errors Database Engine Error Severities Database Engine Error Severities Database Engine Error Severities Database Engine Error Severities TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. Database Engine Error Severities SQL Server 2016 Other Versions SQL Server 2014 SQL Server 2012 Applies To: SQL Server 2016When an error is raised by the SQL Server Database Engine, the severity of the error indicates the type of problem encountered by SQL Server.Levels of SeverityThe following table lists and describes the severity levels of the errors raised by the SQL Server Database Engine.Severity levelDescription0-9Informational messages that return status information or report errors that are not severe. The Database Engine does not raise system errors with severities of 0 through 9.10Informational messages that return status information or report errors that are not severe. For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error information to the calling application.11-16Indicate errors that can be corrected by the user.11Indicates that the given object or entity does not exist.12A special severity for queries that do not use locking because of special query hints. In some cases, read operations performed by these statements could result in inconsistent data, since locks are not taken to guarantee consistency.13Indicates transaction deadlock errors.14Indicates security-related errors, such as permission denied.15Indicates syntax er