Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: system information

    Is there a SQL Server system table that stores information about the tables in the db like row count? If so wich is it. I am working on a migration and am looking for an easy way to compare the two servers and make sure that i get all of the data.
    Regards Jim

  2. #2
    Join Date
    Oct 2002
    Location
    BC, Canada
    Posts
    17

    Re: system information

    Originally posted by JDionne
    Is there a SQL Server system table that stores information about the tables in the db like row count? If so wich is it. I am working on a migration and am looking for an easy way to compare the two servers and make sure that i get all of the data.
    Regards Jim
    Hi there,

    In sysindexes table there is rows column with numbers that you need.

    Cheers, Marin
    Marin Kostadinovic
    ----------------------------
    DBA
    DIMM Info Systems Inc.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •