Just now i read SQL REPLICATION link
Its a superb link for understanding purpose, but after going through it i had some doubts in my mind, i thought lets just ask and see if somebody can help..
1. Lets say i am using pull replication, what happens if this replication doesn't get commited or it gets half commited. is there a way to know this, can i send email to someone if this job gets failed.
2. Lets say as a subscriber i just want to read data from distributor but it should be replicated at every day at morning 5, what i should do.
3. or if not possible which action user should take to run this think at every day 5 morning.
4. Which replication strategy well suits my scenario, if i just need to read data every morning 5 and show that data on my front end.
Please help me...
SHOUTING removed - OriginalGriff[/edit]