Hello Deepak
Yes but I didn't understand what I need to do.
I already tried next command
-- To update stats on the current DB
DBCC UPDATEUSAGE(0);
-- To go to a different database
DBCC UPDATEUSAGE ('db name');
-- To browse all databases (using a simple cursor)
-- Cursor updates usage for all non system databases
declare @name sysname, @str varchar(500)
declare cur_dbs cursor
for select [name] from master.sys.databases
where [name] not in ('master', 'tempdb', 'model', 'msdb') -- Ignore system databases
open cur_dbs
fetch next from cur_dbs into @name
while @@fetch_status = 0
begin
select @str = 'DBCC UPDATEUSAGE('''+@name+''');'
execute(@str)
fetch next from cur_dbs into @name
end
close cur_dbs
deallocate cur_dbs
But I still got same error.
We have Mircrosoft SQL server 2008
EDIT: This is the another message what I got
Job ended: 09. syyskuuta 2009 at 07:52:04
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors
For additional information regarding this error refer to link V-79-57344-33859
