A possible database consistency problem is detected. | Solution

A possible database consistency problem is detected in the database 'wsedsqldb. DBCC checkdb and DBCC checkcatalog should be run on the database 'wsedsqldb'

Solution:

Enterprise Manager -- database list -- select the database to be repaired -- properties -- "options" tab -- restrict access -- select a single user. Close the Enterprise Manager, open the query analyzer, and run:
DBCC checkdb ('database name', repair_rebuild)
Or
DBCC checkdb ('database name', repair_allow_data_loss)
When this problem occurs frequently, data cannot be accessed and an index error is reported.

Use zj123_ B2B;
Go
DBCC dbreindex ("product", "", 70 );
Go
Use this to re-create the index.