Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Procedure expects parameter ‘@statement’ of type ‘ntext/nchar/nvarchar’.” EXPLANATION: You may see this error message when you run the command in a variable …
Read More »MSSQL
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.
ERROR MESAGGE: “One or more files do not match the primary file of the database. If you are attempting to attach a database, retry …
Read More »Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online
ERROR MESAGGE: “Could not backup database: The backup of full-text catalog ‘index_name’ is not permitted because it is not online. Check errorlog file for …
Read More »Cannot drop full-text catalog ‘catalog_name’ because it contains a full-text index
ERROR MESAGGE: “Cannot drop full-text catalog ‘catalog_name’ because it contains a full-text index.” EXPLANATION: You may receive this error when you try to delete …
Read More »Dedicated administrator connections are not supported. (ObjectExplorer)
ERROR MESAGGE: “Dedicated administrator connections are not supported. (ObjectExplorer)” EXPLANATION: When you use the Object Explorer in SSMS to connect to SQL Server using …
Read More »Exclusive access could not be obtained because the database is in use
ERROR MESAGGE: “Exclusive access could not be obtained because the database is in use.” EXPLANATION: You can get this error because you can’t put …
Read More »DROP DATABASE statement cannot be used inside a user transaction
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 »