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 »The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log backup that includes LSN (xxx)
ERROR MESAGGE: “The log in this backup set begins at LSN (xxx), which is too recent to apply to the database. An earlier log …
Read More »Arithmetic overflow error converting numeric to data type numeric.
ERROR MESAGGE: “Arithmetic overflow error converting numeric to data type numeric.” EXPLANATION: You may receive this error message when you are using data types …
Read More »The server principal “login_name” is not able to access the database “database_name” under the current security context.
ERROR MESAGGE: “The server principal “login_name” is not able to access the database “database_name” under the current security context.” EXPLANATION: You receive this error …
Read More »