• harita (10/2/2013)


    thanks and how to put databases in sync when the date is changing in both at different timings?

    Why would you want to have the dev database perfectly in sync with your production database?

    This a nightmare to manage, and a nightmare for the developers who must continually deal with the constant changes. Not to mention regulatory requirements of scrubbing production data when used in a QA or dev type of environment.

    Do the once a day method. You will save you and your boss plenty of hair that way.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events