?
Solved

Transaction History in SQL SERVER Express

Posted on 2014-03-20
1
Medium Priority
?
369 Views
Last Modified: 2014-03-20
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 ?
0
Comment
Question by:Vikash p
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39943207
For DML yes - you would need to put triggers on INSERT/DELETE/UPDATE to generate the Audit(log) records you need to keep.

For DDL you can try use SQL Database DDL triggers meant for that:

http://technet.microsoft.com/en-us/library/ms190989(v=sql.105).aspx
0

Featured Post

Application Discovery Service in AWS

In the era of the cloud, customers migrating away from their existing on-premise infrastructure. This requires lots of planning, strategies, and effort to identify their existing resources and determine how best to migrate.  Datacenter migrations happen in four phases -

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question