Is there another kind of replication that I can work with besides transactional? The objective is to move our reporting off our live database. and onto its own server this...

thanks for the advice I will take make necessary changes.

As far as changing the sa account. When I change the sa account under Security from that point forward I have...