Results 1 to 4 of 4

Thread: table modified

  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: table modified

    Hi all,
    Sql server 7

    Is there anyway to findout if list of tables that has been modified after august 2003 in a database.

    Waiting for ur reply.

    TIA
    Adil

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    from some one else, not sure who...

    use crdate from sysobjects
    Isn't that the create data and not the modified date? Or is modification considered a new creation?
    Last edited by rokslide; 01-14-04 at 19:54.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    It depends on the level of the modification involved. If the change was done through EM it may not mean that ALTER was suffice.

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Yeah, I know that EM will sometimes create a whole new table with a temporary name, copy the data across from the old table, delete the old table and rename the new one.... it would be interesting to know how it decides what to do though.

Posting Permissions

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