jitendra.padhiyar (1/14/2013)
Moreover, its sql server 2000, what may be the solution ? Checkdb ?
Ideally, restore from a clean backup, but only once you know the severity of the problem.
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability