Hi! Welcome to satish24k - It's Not Just Central Government Employeees News, but We Strive To Present You Whatever You Might Be Interested In.......................Chief Editor - kavitaSatish, Just a COMMON MAN with UNCOMMON DREAMS..........
LIFE IS NOT WHAT WE GET FROM BIRTH, IT IS WHAT WE MAKE OUT OF EVERY MOMENT WE LIVE; SO MAKE BEST OUT OF IT.......HAVE A GREAT LIFE

Solution1.Run latest DBAnalyzer. Select 'DBUtilities >> Check Database Consistency' option and run it for all databases

The problem relates to corrupted tables in the BPRO database.

.The first option is to restore a fairly recent backup in which the DBCC Checkdb command does not report errors and then to update the database with transactions for the subsequent days.

The second option is to run the query given by us through query analyzer.This solution given may result in a certain degree of data loss proportionate to the corruption of data.The extent and amount of data loss cannot be determined before running the query. Run the query given below from SQL Query Analyser after taking a backup and after obtaining permission from your divisional \ regional offices and informing them of the data loss which might occur.