Auditing with Temporal Tables

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
enrique_aeoAsked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
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
 
enrique_aeoConnect With a Mentor Author Commented:
What does this mean
User tracking requires adding column to SUSER_SNAME table
0
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
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
 
Daniel JonesConnect With a Mentor Data Research AnalystCommented:
You can also take the help of this link: http://www.sqlmvp.org/create-temporal-table-in-sql-server-2016/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.