Solved

Auditing with Temporal Tables

Posted on 2016-11-22
4
35 Views
Last Modified: 2016-12-04
hi experts

i am reading about Auditing with Temporal Tables in https://msdn.microsoft.com/en-gb/library/dn935015.aspx

I could provide some good articles to go deeper into the subject

why, Temporal tables limitations?
User tracking requires adding a column to the table to hold SUSER_SNAME
0
Comment
Question by:enrique_aeo
  • 2
4 Comments
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 250 total points
ID: 41898376
There is a excellent video to deep dive in Temporal Table introduced in SQL 2016..

https://www.youtube.com/watch?v=t2baJaomY4o

A good article by David-http://www.slideshare.net/davidemauri/sql-server-2016-temporal-tables
0
 

Assisted Solution

by:enrique_aeo
enrique_aeo earned 0 total points
ID: 41898381
What does this mean
User tracking requires adding column to SUSER_SNAME table
0
 
LVL 28

Assisted Solution

by:Pawan Kumar
Pawan Kumar earned 250 total points
ID: 41898407
This means you have to attach another column lets say "UserNm" which will have value of SUSER_SNAME(). SUSER_SNAME() will give you the Domain\UserName which will be used for tracking.
0
 
LVL 4

Assisted Solution

by:Daniel Jones
Daniel Jones earned 250 total points
ID: 41898531
You can also take the help of this link: http://www.sqlmvp.org/create-temporal-table-in-sql-server-2016/
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql 2008 how to table join 2 28
While in ##Table - Help 4 19
TSQL recursive CTE challenge... 8 29
too many installs coming along with SQL 2016? 1 17
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question