 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / November 2007system table on SDF to query to see if I have a pending change
I am looking for something in the SDF to tell me that I have data that has changed. I found the __sysDeletedRows and that is all fine for deleted rows, but I want to know about inserted/updated rows as well. The tables I see do not show me that information. Any Ideas? Below is the list of system tables on the SDF that I know about. select * from __sysDeletedRows select * from __sysMergeArticles select * from __sysMergeSubscriptions select * from __sysRowtrack select * from __sysTrackedObjects My guess is sysTrackedObjects or sysRowtrack would give me that info. sysTrackedObjects I don't understand yet and sysRowtrack is always empty as far as I can tell. Look here for information on SQL Compact system tables: http://blogs.msdn.com/sqlservercompact/archive/2007/04/18/merge-replication-syst em-tables.aspx  SignatureErik Ejlskov Jensen - see my SQL Compact blog at http://erikej.blogspot.com >I am looking for something in the SDF to tell me that I have data that > has changed. [quoted text clipped - 16 lines] > sysTrackedObjects I don't understand yet and sysRowtrack is always > empty as far as I can tell. Thanks, I see those tables, the only problem I see is that __sysRowTrack always seems to be empty. Therefore I'm not sure what it is doing and how it is tracking that something changed. > Look here for information on SQL Compact system tables: > http://blogs.msdn.com/sqlservercompact/archive/2007/04/18/merge-replication-syst em-tables.aspx [quoted text clipped - 19 lines] > > sysTrackedObjects I don't understand yet and sysRowtrack is always > > empty as far as I can tell. How to find this infomation is described here: http://blogs.msdn.com/sqlservercompact/archive/2007/04/18/howto-pending-changes- for-a-merge-subscription.aspx SignatureErik Ejlskov Jensen - MCTS: Mobile App Dev > Thanks, I see those tables, the only problem I see is that __sysRowTrack > always seems to be empty. Therefore I'm not sure what it is doing and how it [quoted text clipped - 23 lines] > > > sysTrackedObjects I don't understand yet and sysRowtrack is always > > > empty as far as I can tell. Thank you this is exactly what I needed. > How to find this infomation is described here: > http://blogs.msdn.com/sqlservercompact/archive/2007/04/18/howto-pending-changes- for-a-merge-subscription.aspx [quoted text clipped - 26 lines] > > > > sysTrackedObjects I don't understand yet and sysRowtrack is always > > > > empty as far as I can tell. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.