Just copy and paste the code in your sql server and execute.Your problem Solve.(If it shows again just refresh the database.)And replace the ct_net with your database name.
EXEC sp_resetstatus CT_net; ALTER DATABASE CT_net SET EMERGENCY DBCC checkdb(CT_net) ALTER DATABASE CT_net SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (CT_net, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE CT_net SET MULTI_USER.
No comments:
Post a Comment