SQLTeam.com | Weblogs | Forums

Indexes, problems


Is there a question?

First thing - what version and edition of SQL Server are you running?
Second - rebuild all indexes on the affected table: ALTER INDEX ALL ON WebCam08.File.Datahst REBUILD;

And finally - perform an integrity check of the full database and validate no issues: DBCC CHECKDB(WebCam08) WITH all_errormsgs, no_infomsgs;