SQL corruption can be a result of numerous factors such as virus attacks, etc and can result in severe data loss. In case of corruption of SQL database, your entire data becomes inaccessible. In order to resolve corruption in SQL database, you need to run the DBCC CHECKDB command with the read more...

Let’s consider a real life scenario wherein while working on MS SQL Server 2000 database, you get to face the following error message: “Table error: Object ID O_ID, index ID I_ID, column ‘COLUMN’. The column ID COL_ID is not valid for this table. The valid range is from 1 to read more...

MS SQL Server uses MDF file to store your crucial data. You often need to execute queries to add, delete, or modify data stored in the MDF file. Sometimes, while querying the MDF database you may get various errors on your computer screen. Interpreting some of the error messages is quite read more...