[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

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
0
enrique_aeo
Asked:
enrique_aeo
  • 2
4 Solutions
 
Pawan KumarDatabase 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_aeoAuthor Commented:
What does this mean
User tracking requires adding column to SUSER_SNAME table
0
 
Pawan KumarDatabase 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 JonesData Research AnalystCommented:
You can also take the help of this link: http://www.sqlmvp.org/create-temporal-table-in-sql-server-2016/
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now