Showing posts with label weve. Show all posts
Showing posts with label weve. Show all posts

Monday, March 19, 2012

Is it possible to alter snapshot agent to not drop tables?

We've got transactional replication set up from 2000 to 05. Is there a
way to not let the snapshot agent to drop and recreate the destination
tables, but rather truncate them?
Thank you,
Igor
*** Sent via Developersdex http://www.codecomments.com ***
Have a look at the article properties (@.pre_creation_cmd ). By default it is
Drop, but it can be converted to delete or truncate (or none).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Right ON!
Thank you.
*** Sent via Developersdex http://www.codecomments.com ***