• I tried with DBCC CHECKDB('TransAidDB', REPAIR_REBUILD), but during this trial I am getting an error that database is to be opened in single user access, which I already did using with both of these options.

    exec sp_dboption 'TransAidDB','Single User', 'true'

    Alter Database TransAidDB SET single_user

    I am not able to proceed beyond this step.

    Thanks

    Srinivas