Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Just now i read SQL REPLICATION link
 
http://www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server
 
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...
 
Thanks Regards,
SUNIL MALI.
 
[edit]SHOUTING removed - OriginalGriff[/edit]
Posted 24-Apr-13 22:04pm
Edited 24-Apr-13 22:59pm
v3
Comments
Tadit Dash at 25-Apr-13 3:52am
   
It will be better if you can add one comment in that article only, so that the author will directly answer your doubts. Otherwise it will take time here, as all of us, who don't know the concept, has to go through the article and then answer you.
 
So, I suggest you to go ahead and post a comment there.
OriginalGriff at 25-Apr-13 3:59am
   
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.
sunil_mali at 26-Apr-13 4:00am
   
hello sir,
It was not mean't to Shout, i thought my subject is small so i should write it in capitals, i didn't know capital means shouting, i didn't mean that at all, still if you feel i was shouting, then sorry for that.
OriginalGriff at 26-Apr-13 5:19am
   
It's basic Netiquette: http://en.wikipedia.org/wiki/Etiquette_(technology)
And it applies pretty much everywhere on the net, not just here.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Don't post this under Quick Answers - if you got the code from an article, then there is a "new message" button at the bottom of that article, which causes an email to be sent to the author. They are then alerted that you wish to speak to them.
Posting this here relies on them "dropping by" and realising it is for them.
  Permalink  
Comments
sunil_mali at 26-Apr-13 4:01am
   
ohh... i thought, i had so many doubts together, so it might create unecessary garbage there.. okk i will do that.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Afzaal Ahmad Zeeshan 256
1 OriginalGriff 251
2 BillWoodruff 240
3 Maciej Los 230
4 Sergey Alexandrovich Kryukov 195
0 OriginalGriff 6,419
1 Sergey Alexandrovich Kryukov 6,008
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 4,070


Advertise | Privacy | Mobile
Web03 | 2.8.1411019.1 | Last Updated 25 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100