I need to keep Table log in a history table. Can you please suggest me I can get the record from SQL SERVER Log table ?
Or do I need to write trigger for every table and store the data for edit, insert and delete in history table ?
Its a ASP .NET application so I want to store data about the user did the modification and from the IP . Whats the best way to do this ?