Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. …
Read More »MSSQL
SQL Server Alert List(sys.messages)
You can capture errors that occur on SQL Server with the help of the following query. You can generate alerts using any of these …
Read More »Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.
ERROR MESAGGE: “Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.” EXPLANATION: If you try to delete the contents of a …
Read More »The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log backup that includes LSN (xxx)
ERROR MESAGGE: “The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log …
Read More »Arithmetic overflow error converting numeric to data type numeric.
ERROR MESAGGE: “Arithmetic overflow error converting numeric to data type numeric.” EXPLANATION: You may receive this error message when you are using data types …
Read More »The server principal “login_name” is not able to access the database “database_name” under the current security context.
ERROR MESAGGE: “The server principal “login_name” is not able to access the database “database_name” under the current security context.” EXPLANATION: You receive this error …
Read More »Error: Action “LaunchLocalBootstrapAction” threw an exception during execution.
ERROR MESAGGE: “Error: Action “LaunchLocalBootstrapAction” threw an exception during execution.” EXPLANATION: On a system where Microsoft Cluster Services is installed, you may experience this …
Read More »Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.
ERROR MESAGGE: “Arithmetic overflow error converting IDENTITY to data type smallint. Arithmetic overflow occurred.” EXPLANATION: You may experience this error when you try to …
Read More »Agent XPs’ component is turned off as part of the security configuration for this server.
ERROR MESAGGE: “‘Agent XPs’ component is turned off as part of the security configuration for this server. A system administrator can enable the use …
Read More »System.data.sqlclient.sqlerror: Restore detected an error on page (x:x:) in database “database_name” as read from the backup set. (Microsoft.sqlserver.smo)
ERROR MESAGGE: “System.data.sqlclient.sqlerror: Restore detected an error on page (0:0:) in database “veritabanı_adı” as read from the backup set. (Microsoft.sqlserver.smo)” EXPLANATION: You may experience …
Read More »