Hi, I would like to know the detailed history(modification time, username, modified column etc) of table modification like alter. Could you please anyone help me to know the script to find the history of table modifications(at-least last 10 modification). Thanks, Raja.
There is no mechanism within SQL Server that automatically records that information. You can set up an [Extended Events] session to capture it for yourself. You can use the object_altered, object_created and object_created events to audit changes to the data structures of your systems. With that you can tell exactly who changed what. But, you have to set this up, it doesn't exist by default. :