Wednesday, 11 January 2012

How to Rectify Consistency Problem in SQL Tables

Solution 1: sp_dboption 'dbname', 'single user', 'true' go dbcc checkdb ('dbname', REPAIR_REBUILD) go sp_dboption 'dbname'single user', 'false' go Solution 2: The second option is to run the...