Post reply

List of the objects changed in the last X days

  • January 27, 2010 at 8:24 am

    #229395

    Hi there,

    I need a help. I need to know how can I query or get the name of objects changed in last days...

    If there's a table that stores the objects and the date of their last DDL updates... maybe I can query it...

    So, can anyone help me ???

    Thanks a lot ...

    att.

    Edvaldo Castro

  • January 27, 2010 at 9:24 am

    #1109376

    this might help, and also the default trace can help as well:

    select *

    from sys.objects

    where create_date > GETDATE() -30

    or modify_date > GETDATE() -30

    or the built in report from the trace:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 27, 2010 at 11:21 am

    #1109467

    Thank you very much...

    It's easy and usefull...

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

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