Results 1 to 4 of 4

Thread: Database object info

  1. 03-11-2005, 04:57 PM #1
    deepa
    deepa is offline Registered User
    Join Date
    Feb 2004
    Posts
    64

    Database object info

    Hi,

    Is there a way to find the changes made to the objects? For example adding new column to the table, adding new or deleting constraints to the table etc.

    Thanks.
    Reply With Quote Reply With Quote
  2. 03-11-2005, 07:02 PM #2
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    Use a log reader tool.
    Reply With Quote Reply With Quote
  3. 03-11-2005, 10:35 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Generate script daily.

    You can compare the scripts later for changes.

    http://www.databasejournal.com/featu...le.php/3401081
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  4. 03-14-2005, 02:25 PM #4
    deepa
    deepa is offline Registered User
    Join Date
    Feb 2004
    Posts
    64
    Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules