I have been asked to set up a process that will make data available for users to run report daily on a QA box. Options are:
Transactional Replication or
Which of these three will server the purpose?
What are the troubles with you've encountered with snapshot replication?
How do you threat securities and permissions after the snapshot daily?
What is the best way to sync security here?