Post reply

Less records according to Enterprise Manager

  • December 29, 2004 at 9:33 pm

    #61509

    Hi All,

    In using DTS to transfer records from one table to another I found that I ended up with more records in the destination table than existed in the source table....according to Enterprise manager that is!

    When I use query analyser to do a select * from SourceTable, I get the expected number of records.

    It seems as if Enterprise manager is reporting that the table has fewer rows than actually exist. The table in question exists in an archive database that has had no activity in over a year.

    Any ideas?

    Regards,

    Terry Pino

  • December 30, 2004 at 12:52 am

    #535371

    Hello Terry,

    Try one of these.

    EXEC sp_spaceused @updateusage = true

    DBCC UPDATEUSAGE ('<databasename>')

    Regards,
    Leon Bakkers

  • December 30, 2004 at 5:05 pm

    #535477

    Hi Leon,

    Attempted both but still have the same problem of Enterprise

    manager not reporting all rows. I ran sp_spaceused with the object name and it returned the same number of rows Enterprise manager is reporting. When transferring the records into another database I still end up with more than is reported?

     

    Thanks,

    Terry

     

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply