Comments by ErrrCmon!

ErrrCmon! 18-Mar-14 3:32am View

It's ok Vick, no probs ;) in case you encountered the same problem as mine, atleast you know what to do now :D

Thank you and more power!

ErrrCmon! 18-Mar-14 3:30am View

Ok, I will read this. Thank you Syed for the help!

ErrrCmon! 18-Mar-14 2:56am View

Yup, Replication was my second choice BUT I'm only running the express edition of SQL Server 2008 R2... I guess the Publication/Distributor is not part of the Express edition... Meaning, its not free...T_T

PS, Thank you for the info!

Currently, I'm reading the "Linked Database" suggested by another user. His comment can be seen under first my post as a "Comment"

ErrrCmon! 18-Mar-14 1:58am View

Thank you for the reply. Yes of course, flag or a separate counter should be done for tracking purposes. But what I need/like to know is: Are there any other way where I can achieve the same goal without using dataset? Like I just need to run some stored proc in the Main Server to copy the local tables...

ErrrCmon! 18-Mar-14 1:38am View

Thank you for the reply. I have updated my question so please feel free to read it again. As for the Linked Database, may I ask for some links you recommend so that I could read about it?

Again, Thank you!

Comments by ErrrCmon! (Top 5 by date)