Version Table in SQL

Jan 12 2021 6:53 AM
Hi All,
 
I Have a 2 questions, 
 
1. Is it possible to Version Table in SQL Server and Mark that table(s) as Open for modification or closed for modification when presented in UI using C#  ? i.e Versioned Table will need to have a Version Status to show if table in DB is Open/Closed for Modification
 
2. Is it possible  to have Version-ID to primary key of the table?

Answers (4)