sumith1andonly1 (8/7/2014)
hi,i have to find out the modified table and its column details .
ie,if we are executing a query.It will insert or update records .
i have to get tables and column (which column , table changed ,updated or inserted value,previous value in case of exiting record etc)
is there any sql script or tools or any feature available??
if Any method .. please let me know
thank you
Not quite sure what context you are looking for but perhaps a trigger? Or you might like into CDC (Change Data Capture).
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/