gaddamshiva (12/18/2013)
hi....1. what is diff b/w snapshot,transactional,merge replications in sql server 2008 r2.
2. what is exactly auditing is the server level or database level?
http://lmgtfy.com/?q=what+is+sql+server+auditing+at+the+database+or+server+level&l=1
Sorry. Both of those questions are pretty general.
Replication.
Snapshot: refreshes the whole subscription on a schedule. Not suitable for large publications
Transactional: Can be near realtime as it trickles the transactions regularly. Generally read only but they're are updateable versions
Merge: Can be similar to transactional and close to real time. Allows for updates at both publisher and subscriber.
Consider reading the stairway articles for more info. They can be found here:
http://www.sqlservercentral.com/stairway/72401/[/url]
Auditing is pretty expansive as a subject and you are better off reading and asking specific questions.