Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Unable to start service SQLAGENT$ on server. Access denied (ObjectExplorer)” EXPLANATION: We are experiencing new problems due to the security of the …
Read More »MSSQL
CREATE DATABASE failed. Some file names listed could not be created.(Cannot create file ” because it already exists. )
ERROR MESAGGE: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file ‘C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\DATA\<file_name>’ because …
Read More »SQL Server Service can not start because of antivirus program
ERROR MESAGGES: “Could not start the network library because of an internal error in the network library. To determine the cause, review the errors …
Read More »Mirror Backup On SQL Server(Multiple Copies of a Backup)
You may want to import a database backup on multiple disks as multiple copies. For example, suppose you have a storage that you use …
Read More »The index “Index_name” (partition ) on table “Table_name” cannot be reorganized because page level locking is disabled
ERROR MESAGGE: “The index “Index_name” (partition ) on table “Table_name” cannot be reorganized because page level locking is disabled” EXPLANATION: If the Index in which …
Read More »An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that
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 »Length of LOB data (xxxxx) to be replicated exceeds configured maximum 65536. The statement has been terminated.
ERROR MESAGGE: “Length of LOB data (xxxxx) to be replicated exceeds configured maximum 65536. The statement has been terminated.” EXPLANATION: You may experience such …
Read More »Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203
ERROR MESAGGE: “Msg 14684, Level 14, State 1, Procedure sp_syscollector_create_collection_set, Line 203 Caught error#: 2627, Level: 14, State: 1, in Procedure: sp_syscollector_create_collection_set, Line: 137, …
Read More »Random Data Selection(TABLESAMPLE)
Did you know that TABLESAMPLE can be used after FROM to select random data from a table? For example you can use the following: …
Read More »How To Find SQL Server Database Compatibility Level
In this article I will share the information of finding database compatibility level. If may want to read more about SQL Server Compatilibility Level, …
Read More »