resolve sql error 823

Monday Aug 30, 2010

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...


SQL database is marked suspect

Thursday Aug 5, 2010

Sometimes, during MS SQL Server installation, SQL agent fails to start and the msdb SQL database is marked suspect. This article provides solution to MS SQL Server database’ suspected state. Actually, msdb database is a database used by SQL Server Agent for scheduling alerts and jobs and read more...


SQL Database corruption caused after running ALTER TABLE

Thursday Jul 29, 2010

SQL Server is a relational model database and as we know administrators use T-SQL and ANSI SQL as their primary query languages. Talking of ALTER TABLE, this statement enables a user to rename an existing table. Moreover, this statement can be successfully used to add, modify or drop a column read more...