How to find a problem in SQL database maintenance failure

Data | database | questions

To view the job's error log
View the history of the database maintenance plan and find the wrong information

Using the SQL Event Tracker

Use the SQL statement to do a further check
DBCC DBREINDEX (N ' [dbo].[ Tblsitewantprod] ', N ', sorted_data_reorg,
DBCC checkident (' Tblsitewantprod ')
DBCC CHECKDB
DBCC CHECKTABLE

SQL error message
CREATE UNIQUE Index terminated because an index ID%1! was found The duplicate key. The most important primary key is '%2! '.

%1= is probably the first index of the current table???
%2= the value of a duplicate key