Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “DROP DATABASE statement cannot be used inside a user transaction” EXPLANATION: You may receive this error message when you try to delete …
Read More »The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (YYYY-MM-DDTHH:MM:SS). Exception Message: Could not write to temp attachment file. (There is not enough space on the disk)
ERROR MESAGGE: “The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (YYYY-MM-DDTHH:MM:SS). Exception …
Read More »The database could not be exclusively locked to perform the operation
ERROR MESAGGE: The database could not be exclusively locked to perform the operation. EXPLANATION: When performing an operation in a database (such as changing …
Read More »SystemOutOfMemory On SQL Server Management Studio
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 »