Viewing 2 posts - 1 through 2 (of 2 total)
Thanks everyone.The problem was solved on my computer.(The customer's DB has resored by backup)
I executed :
sp_Msforeachtable @command1="print '?' dbcc dbreindex('?')"
reindex all the user table,then run the check again no error...
June 17, 2004 at 11:21 pm
#510953
First thanks for you.I execute the follow script :
sp_configure 'show advanced options',1
go
sp_configure 'allow update', 1
then I restart the SQL Server service
then I execute:
truncate table sysindexes
the reply is:
could not allow truncate...
June 16, 2004 at 8:15 pm
#510751