Row-level history of changes

[newDBA]

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.

 

[jabrony76]

I don't know of a tool within SQL Server but you could use Triggers to store a change history to a logging table.

 

[SQLDenis]

SQL Server 2005 will have DDL triggers in 2000 you are out of luck

http://sqlservercode.blogspot.com/