Post reply

dba

  • May 10, 2010 at 3:41 am

    #143050

    Hi..

    iam dba of sqlserver. last couple of days i didn't go to office.. now i came today.. my question is what are the changes were done in database server from the last couple of days..

    could you pls help me out regarding this..

  • May 10, 2010 at 4:15 am

    #1164900

    You can check the default trace, if the server isn't too busy, the changes might still be in there. Otherwise you would have needed a trace or DDL trigger before the changes were made.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 10, 2010 at 6:43 am

    #1164932

    And in 2005/2008, it's pretty easy to see the changes from the default trace. In Management Studio, right click on the server name, in Object Explorer, and select, Reports, Standard Reports, Schema Changes. You'll get everything you need, as Gail said, assuming the number of changes hasn't cycled through the trace.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 10, 2010 at 6:56 am

    #1164945

    Here's a basic article :http://www.sqlservercentral.com/articles/64547/

  • May 10, 2010 at 9:59 pm

    #1165324

    Dear friend..

    Thanks for for your wonderful solution..

    With Regards

    Balaji Gangadharan

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

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