How to view the history of changes in database structure in MS SQL Server Management Studio?

Hello. In the finished database had made some changes (created tables, added columns, removed columns, creating keys and index etc.). You need to look at the history of these changes over a period of time. How can I do this program? Or this is not possible?
June 8th 19 at 17:22
3 answers
June 8th 19 at 17:24
Of course, such a possibility. Make a trigger for change, there are two steps:
1. To create a table where to write the changes.
2. create a trigger on the database.

In this case, I store the: who, when, how, was, became, date / time changes.
It is clear. But this will only be on future changes. And I need to watch all the past. - dorian53 commented on June 8th 19 at 17:27
And, well, it let fly a magician in the blue helicopter. Or invent a time machine.
Another way to take the data that was not previously saved, I don't know.

Although, as already said, you can try to see the transaction log, but the game worth the candle, not the fact that is. - lauren.Prosac commented on June 8th 19 at 17:30
June 8th 19 at 17:26
What do you mean "transactions"? If you mean SQL, I did not use transactions. Or are they automatically used? - dorian53 commented on June 8th 19 at 17:29
Yes. takes default transaction always starts, they need to resolve conflicts when accessing shared resources. - lauren.Prosac commented on June 8th 19 at 17:32
in this context read the term as "the change log". it exists, but not in the most digestible form. easier to protect against unauthorized changes, access rights and regulation, what then is there to be picked - dorian53 commented on June 8th 19 at 17:35
Looked the article You gave the link. Something a little too difficult. I have even the first step did not work (wrote that insufficient rights). So I roughly remember what changes were made, just wanted to see exactly, in order not to forget anything (need to document). It is therefore possible and score on it (if there is a simple solution; I am in General not much is needed). - maritza_Marquardt commented on June 8th 19 at 17:38
again. these things are regulations (migration etc.) :)) easier solution does not exist. maybe it's a sign that you need to debug the process - maritza_Marquardt commented on June 8th 19 at 17:41
is a sign that is not solved. As I wrote above, it's easier for memory to play all the actions that I made with the base. Not so much, so it will be easy is that to forget something. (As I wrote this I need to compile some documentation) - dorian53 commented on June 8th 19 at 17:44
,
is that to forget something
for example the piece where clause in delete -) - maritza_Marquardt commented on June 8th 19 at 17:47
I unimportant changes in the data, I important changes in the structure - dorian53 commented on June 8th 19 at 17:50
changes in the structure, too, can do sql queries and there also may be conditions where - delta89 commented on June 8th 19 at 17:53
June 8th 19 at 17:28
MICROSOFT SQL SERVER MANAGEMENT STUDIO you Need to look at the history of these changes over a period of time. How can I do this program? Or this is not possible?
No.
To track changes of database structure needed, after changes to script "Create Database" and feeding it to any version control system.
There are third party programs that can do the script of the difference in the versions database.

Find more questions by tags SQL ServerMicrosoft SQL Server Management Studio