Post reply

Schema audit

  • March 20, 2006 at 1:55 am

    #189735

    Hi,

     

    I need to be able to compare schema between tables.  I would like this compare to run automatically and send notification when there is difference detected.  Any one any ideas on the best way to do this?

     

    Thanks

     

    Kindest Regards,

    BJ

  • March 20, 2006 at 5:23 am

    #627559

    You can compare schema with sysobject & syscolumns tables.

    But it can't be automated.

    It can be done in SQLServer 2005. It has DDL Triggers.

    Kindest Regards,

    R

  • March 21, 2006 at 6:44 am

    #627846

    You could have a scheduled job that stores the results for sysobjects and syscolumns and compares them daily.  I've done this as a workaround before.

     

     

  • March 22, 2006 at 2:40 pm

    #628232

    Best bet in SQL 2000 or 7

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

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