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