David Townsend
Last Activity: Nov 15 '13, 09:16 AM
Joined: Nov 13 '13
Location:
-
There is no something like that built-in SSMS, but you can always try some free commercial tools, like PoorSQL and Dpriver (online formatters), or ApexSQL Refactor (free SSMS and VS add-in) -
Maybe a two table design can work for you. I suggest having one table to keep the transaction data (database, schema, date, app that triggered transaction, etc.) and another table to hold the record modifications, so you are able to undo them easily.
There is also a SQL Server Change Data Capture (CDC) feature you could use, as well as some commercial tools meant to deal with this.Leave a comment:
-
Hi,
First of all, SQL Server itself doesn’t support json, so you’ll need to figure out your own way if you want to accomplish this.
To help you, I’ve found a good post illustrating a number of string manipulation techniques in TSQL:
https://www.simple-talk.com/sql/t-sq...in-sql-server/...Leave a comment:
-
Pulling out the data manually, and adding it into change data capture tables is very complex.
You can use undocumented functions to get this done: fn_dblog and dbcc log.
Another option is to use log readers. Be aware that these are able to view only what’s written inside transaction log. You’ll need to figure out how to take these records, shown by transaction log readers, and insert them into change data capture tablesLeave a comment:
No activity results to display
Leave a comment: