Post reply

SQL 6.5: How to know when last change were done.

  • October 16, 2008 at 4:35 am

    #194585

    Hello,

    Can anyone tell me how can i find when was last changed databases in SQL Server 6.5 :blink:

    I must know when was the last change done in these databases to end this plataform. What a hell who uses this kind of motor already :sick:

    Thanks and Regards

    JMSM 😉

  • October 16, 2008 at 4:44 am

    #885717

    How about looking at the size of your transaction logs? all the ones showing no acitivity should be of the same size, the last one showing something else would tell you. 😎

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • October 16, 2008 at 4:57 am

    #885722

    Hi,

    But is there any query to can check the last date/time when objects were changed.

    Thanks and regards,

    JMSM 😉

  • October 16, 2008 at 5:10 am

    #885725

    Are you talking about DML or DDL?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • October 16, 2008 at 5:18 am

    #885727

    I'm talking about any change, so it can be DML or DDL

    Thanks and regards,

    JMSM 😉

  • October 16, 2008 at 5:39 am

    #885732

    I think there is no silver bullet...

    DDL, I remember a schema-version column on sysObjects that would tell if the object was ever changed but it does not records the timestamp, remember there is a refdate or something column people used to insist was designed to that purpose but... didn't work.

    DML, Other than looking at backup/t-log sizes don't think you are going to find out.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • October 16, 2008 at 6:00 am

    #885739

    If you can find a log reader for v6.5, not sure who had one then, you can flip through log backups. The version column in sysobjects detected a change in the object and increased value by a power of two, but unless you tracked that every day (or hour/minute/etc), you couldn't know an object had changed.

    For data changes, really the same thing. If you are running log backups, and they are small, a few hundred kb for overhead, chances are nothing has changed.

    Note that SQL 2005 still has support for 54 compatibility.

  • October 16, 2008 at 8:51 am

    #885892

    Thanks a lot everybody.

    Regards,

    JMSM 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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