Hi GilaMaster,

Sorry, i have updated allocation error for my privies comment and consistency purpose below command can use..

use master

go

alter database DBname set single_user

GO

dbcc checkdb (DBname,repair_allow_data_loss)

GO

Regards

Satish