• jitendra.padhiyar (1/15/2013)


    Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the database. And we can fix it by applying latest service pack of SQL Server 2000!!

    Err, no it is not caused by shrink trying to remove a page from sysfiles1 and no you cannot fix it by applying a service pack.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass