Fehlercodes: SQL Server

• 1205Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim (Transaktion als Deadlock-Opfer gewählt)
• 2627Violation of PRIMARY KEY / UNIQUE KEY constraint. Cannot insert duplicate key in object (Verletzung des PRIMARY-KEY-/UNIQUE-KEY-Constraints; doppelter Schlüssel nicht einfügbar)
• 2601Cannot insert duplicate key row in object with unique index. The duplicate key value is ... (doppelte Schlüsselzeile in Objekt mit Unique Index nicht einfügbar)
• 547The INSERT/UPDATE/DELETE statement conflicted with the FOREIGN KEY / CHECK constraint (Statement kollidiert mit FOREIGN-KEY-/CHECK-Constraint)
• 18456Login failed for user (Anmeldung für Benutzer fehlgeschlagen)
• 8152String or binary data would be truncated (String- oder Binärdaten würden abgeschnitten)
• 2628String or binary data would be truncated in table, column ...; truncated value (Daten würden in Tabelle/Spalte abgeschnitten; abgeschnittener Wert)
• 1222Lock request time out period exceeded (Timeout der Sperranforderung überschritten)
• 9002The transaction log for database is full due to ... (Transaktionslog der Datenbank ist voll wegen ...)
• 1105Could not allocate space for object in database because the filegroup is full (kein Platz für Objekt, da die Dateigruppe voll ist)
• 208Invalid object name (ungültiger Objektname)
• 229The SELECT/EXECUTE permission was denied on the object (SELECT-/EXECUTE-Berechtigung für das Objekt verweigert)
• 4060Cannot open database requested by the login. The login failed (vom Login angeforderte Datenbank kann nicht geöffnet werden; Anmeldung fehlgeschlagen)
• 233A connection was successfully established with the server, but then an error occurred (no process is on the other end of the pipe) (Verbindung hergestellt, danach Fehler; kein Prozess am anderen Ende der Pipe)
• 823The operating system returned error to SQL Server during a read/write at offset in file (I/O error) (Betriebssystemfehler beim Lesen/Schreiben der Datei)
• 824SQL Server detected a logical consistency-based I/O error (page corruption) (logischer Konsistenzfehler bei I/O; Seitenkorruption)
• 701There is insufficient system memory in resource pool to run this query (zu wenig Systemspeicher im Resource Pool für diese Abfrage)
• 845Time-out occurred while waiting for buffer latch (Timeout beim Warten auf Buffer Latch)
• 3201Cannot open backup device. Operating system error (backup device error) (Backup-Device kann nicht geöffnet werden)
• 8134Divide by zero error encountered (Fehler: Division durch null)
• 245Conversion failed when converting the value to data type (Konvertierung in den Datentyp fehlgeschlagen)
• 515Cannot insert the value NULL into column (NULL kann nicht in die Spalte eingefügt werden)
• 8115Arithmetic overflow error converting expression to data type (arithmetischer Überlauf bei Konvertierung)
• 512Subquery returned more than 1 value (Unterabfrage lieferte mehr als einen Wert)
• 207Invalid column name (ungültiger Spaltenname)
• 156Incorrect syntax near the keyword (falsche Syntax in der Nähe des Schlüsselworts)
• 2812Could not find stored procedure (Stored Procedure nicht gefunden)
• 8623The query processor ran out of internal resources and could not produce a query plan (Query Processor ohne interne Ressourcen; kein Abfrageplan)
• 4104The multi-part identifier could not be bound (mehrteiliger Identifier nicht bindbar)
• 2714There is already an object named in the database (Objekt mit diesem Namen existiert bereits)
• 601Could not continue scan with NOLOCK due to data movement (Scan mit NOLOCK wegen Datenbewegung abgebrochen)
• 50000Mit RAISERROR ausgelöster benutzerdefinierter Fehler
• 3902The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION (COMMIT ohne zugehöriges BEGIN TRANSACTION)
• 1101Could not allocate a new page because of insufficient disk space in filegroup
• 3729Cannot DROP because it is being referenced by object
• 3961Snapshot isolation transaction failed because the object was modified by a DDL statement
• 1785Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths
• 9421XML parsing: illegal xml character
• 15151Cannot find the object/principal because it does not exist or you do not have permission
• 4834You do not have permission to use the bulk load statement
• 10928Resource limit for the database has been reached (Azure SQL)
• 40544The database has reached its size quota (Azure SQL)
• 40613Database is not currently available (Azure SQL)
• 102Incorrect syntax near 'token'
• 8114Error converting data type X to Y
• 1204The instance of the SQL Server Database Engine cannot obtain a LOCK resource
• 3906Failed to update database because the database is read-only
• 15023User already exists in the current database
• 18452Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
• 605Attempt to fetch logical page belongs to a different allocation unit
• 4922ALTER TABLE ALTER COLUMN failed because one or more objects access this column
• 7202Could not find server 'name' in sys.servers
• 40501The service is currently busy. Retry the request after 10 seconds
• 8645A time out occurred while waiting for memory resources to execute the query
• 8651Could not perform the operation because the requested memory grant was not available
• 5061ALTER DATABASE failed because a lock could not be placed on database
• 3702Cannot drop database because it is currently in use
• 15138The database principal owns a schema in the database, and cannot be dropped
• 1934INSERT/UPDATE failed because the following SET options have incorrect settings
• 468Cannot resolve the collation conflict
• 4864Bulk load data conversion error (Typkonflikt oder ungültiges Zeichen)
• 916The server principal is not able to access the database under the current security context