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