dcsimg
Results 1 to 5 of 5

Thread: Finding Modified Objects

  1. #1
    Join Date
    Apr 2005
    Posts
    2

    Finding Modified Objects

    hi,
    I want to find the modified database objects(Tables, Proc and Fun) in last 3 days in SQL 2000.

    With Regards
    Praveen (DBA)

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    You have to set up triggers, etc., to monitor the objects, or use a log viewer to look through the database logs for the past 3 days.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,918
    SQL Server does not capture update date for an object. If something new is created then you can check crdate column in sysobjects.

    Other thing you can do is monitor schema_version in sysobjects. It changes every time an object is modified, but to find out what changed in three days, you need to get schema_version three days old.

  4. #4
    Join Date
    Apr 2005
    Posts
    2

    Schema_ver

    hi,
    Thanks about this info (schema_ver), I didn't no that...

    With Regards
    Praveen(DBA)

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    This value doesn't apply to sp nor udf.

Posting Permissions

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