brokenbone
Programmer
Hi all!
I've decided to use CDC for keeping record of who changed what data and when. I thought I can use just the publisher without any subscribers but my changes in change table disappeared over the night. In CDC literature I then found out that there is a job that executes every 24 hours and cleans all the changes that no one is subscribed to. I need my change data to be there forever (or at least until I delete them
)
How can I do this, do I need at least one subscriber? I wouldn't like to use EXPAND_WINDOW procedures every time I need that data.
Thank you in advance, bye!
BB
I've decided to use CDC for keeping record of who changed what data and when. I thought I can use just the publisher without any subscribers but my changes in change table disappeared over the night. In CDC literature I then found out that there is a job that executes every 24 hours and cleans all the changes that no one is subscribed to. I need my change data to be there forever (or at least until I delete them
)How can I do this, do I need at least one subscriber? I wouldn't like to use EXPAND_WINDOW procedures every time I need that data.
Thank you in advance, bye!
BB
