Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alextansc
Starting Member
2 Posts |
 Posted - 2008-10-02 : 08:28:01
|
| The basic problem is like this:A subscriber has successfully replicated a row from the publisher, using transactional replication. Now, how do we keep track the time of this row being last successfully replicated?A friend has suggested the following solution, which he used for his SQL Server 2000:1) Add a timestamp column.2) Change the replication stored procedure to update the timestamp column (!).The step #2 sets off all sorts of warning bells within me, so I'm asking if there are better solutions for SQL Server 2005 in this situation, before I even go into detail with his solution. |
|
|
alextansc
Starting Member
2 Posts |
Posted - 2008-10-03 : 03:00:44
|
| I've made a mistake with the column's datatype; it was supposed to be DATETIME. One of my main concern, other than whether or not the solution will work for my case, is having to make the changes to some 30+ databases acting as subscribers. I supposed I can make a SQL script and set it to update the 30+ databases at once, but I'm open to a better solution. |
 |
|
|
|
|
|
Recording the time of replicated rows?