Answer the question
In order to leave comments, you need to log in
How to view the history of changes to database structures in MS SQL Server Management Studio?
Hello. Some changes were made to the finished database (tables were created, columns were added, columns were deleted, keys and an index were created, etc.). You need to look at the history of these changes over a certain period of time. How can this be done in this program? Or is there no such possibility?
Answer the question
In order to leave comments, you need to log in
Of course, there is such a possibility. Make a trigger for changes, there are two steps:
1. Create a table where changes will be written.
2. create a trigger on the database.
In this case, I store: who, when, how it was, how it became, the date-time of the change.
MICROSOFT SQL SERVER MANAGEMENT STUDIO You need to look at the history of these changes over some period of time. How can this be done in this program? Or is there no such possibility?No.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question