Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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 »Ekrem Önsoy
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 »Database cannot be upgraded because it is read-only or has read-only files
ERROR MESAGGE: Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft …
Read More »Login failed for user. This user is not associated with a trusted SQL Server connection.
ERROR MESAGGE: Login failed for user . This user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) EXPLANATION: …
Read More »Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection.
ERROR MESAGGE: Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) EXPLANATION: If you …
Read More »Cannot open user default database
ERROR MESAGGE: “Cannot open user default database. Login failed. Login failed for user . (Microsoft SQL Server, Error: 4064)” EXPLANATION: In SQL Server, a …
Read More »A connection could not be established to . Reason: Login failed for user. Reason: Server is in single user mode. Only one administrator can connect at a time
ERROR MESAGGE: “A connection could not be established to . Reason: Login failed for user <server\login_name>. Reason: Server is in single user mode. Only one administrator …
Read More »Device activation error. The physical file name may be incorrect.
ERROR MESAGGE: “Device activation error. The physical file name <database_file_path>may be incorrect.”</database_file_path> EXPLANATION: You receive this error when you try to create a database in …
Read More »