Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR MESAGGE: “Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. > System.Data.SqlClient.SqlException: profile name is …
Read More »The backup set holds a backup of a database other than the existing ‘database_name’ database.
ERROR MESSAGE: “System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing ‘database_name’ database. (Microsoft.SqlServer.Smo)” EXPLANATION: If you already have …
Read More »Assign the data on the same line when defining a variable with “Declare”.
In SQL Server 2008, when you define a variable with “Declare”, you can also assign data to that variable in the same row! We …
Read More »How To Gather Statistics of a Table Partition(Update Partition Statistics)
When the table is large in Partitioned tables, the statistical update process is very long. Although the information we query will take place in …
Read More »How To Increase SQL Server Error Log File Count
For more information about SQL Server Error Log, you should type Error Log in our search section. SQL Server Error Log consists of 6 …
Read More »The operating system returned the error ‘5(Access is denied.)’ while attempting ‘RestoreContainer::ValidateTargetForCreation’
ERROR MESAGGE: “System.Data.SqlClient.SqlError: The operating system returned the error ‘5(Access is denied.)’ while attempting ‘RestoreContainer::ValidateTargetForCreation’ on ‘C:\Program Files\Microsoft SQL Server\MSSQLx.MSSQLSERVER\MSSQL\xxx.mdf’. (Microsoft.SqlServer.Smo)” EXPLANATION: If you …
Read More »Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. (Microsoft SQL Server, Error: 15335)
ERROR MESAGGE: “Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. …
Read More »How To Report Exadata Disk Topology
Simply run the following script from any database server to query the physical disk, celldisk, griddisk, and flash disks on the cell nodes in …
Read More »SQL Server Alert List(sys.messages)
You can capture errors that occur on SQL Server with the help of the following query. You can generate alerts using any of these …
Read More »Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.
ERROR MESAGGE: “Cannot truncate table because it is being referenced by a FOREIGN KEY constraint.” EXPLANATION: If you try to delete the contents of a …
Read More »