How to Fix Chain Linkage Mismatch Errors

To fix “Chain Linkage Mismatch” error, execute this script in your Query Analyzer;

Use DBName
GO

ALTER DATABASE database_name SET SINGLE_USER
GO

DBCC CHECKDB('DBName', REPAIR_REBUILD)
GO

After the repair, you have to set the database to multi-user;

ALTER DATABASE database_name SET SINGLE_USER
GO