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 »DBA_TAB_MODIFICATIONS table does not return any record
In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the …
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 »CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file
ERROR MESAGGE: CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting …
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 »