Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: SystemOutOfMemory EXPLANATION: The result set that the SSMS can show is limited. So you can get this error when the data you …
Read More »Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll
ERROR MESAGGE: “Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147467259 Error message: Unspecified error Error description: …
Read More »The tail of the log for the database “database_name” has not been backed up
ERROR MESSAGE: Msg 3159, Level 16, State 1, Line 2 The tail of the log for the database “TestDB” has not been backed up. …
Read More »The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using ALTER DATABASE.
ERROR MESAGGE: “The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. Use BACKUP DATABASE or change the recovery model using …
Read More »Who Uses Temp Tablespace in Oracle
When you see that there is intense use of temp in a running database, it is necessary to determine who is using a temp …
Read More »The transaction log for database ‘database_name’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
ERROR MESSAGE: “The transaction log for database ‘database_name’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc …
Read More »A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
ERROR MESAGGE: “An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by …
Read More »Mail configuration information could not be read from the database
ERROR MESAGGE: “Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. > System.Data.SqlClient.SqlException: profile name is …
Read More »The backup set holds a backup of a database other than the existing ‘database_name’ database.
ERROR MESSAGE: “System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘database_name’ database. (Microsoft.SqlServer.Smo)” EXPLANATION: If you already have …
Read More »Assign the data on the same line when defining a variable with “Declare”.
In SQL Server 2008, when you define a variable with “Declare”, you can also assign data to that variable in the same row! We …
Read More »