I'm new to SQL Server and am trying to find out if it provides a way to keep a history of row-level changes on specified tables.
In Oracle, there's a tool called Workspace Manager that allows you to keep a history of all changes made to a table - versions of the row are saved so all changes (made via SQL update statements, for example) can be tracked.
Does SQL Server provide such capability?
I've seen that DTS has a row-level lineage feature, but as I understand it, that's only for tracking changes made through a DTS package...but I need to track changes made through regular SQL update statements.
Thanks for your help.
In Oracle, there's a tool called Workspace Manager that allows you to keep a history of all changes made to a table - versions of the row are saved so all changes (made via SQL update statements, for example) can be tracked.
Does SQL Server provide such capability?
I've seen that DTS has a row-level lineage feature, but as I understand it, that's only for tracking changes made through a DTS package...but I need to track changes made through regular SQL update statements.
Thanks for your help.