Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

History actions Expand / Collapse
Author
Message
Posted Saturday, July 17, 2010 10:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 17, 2010 10:35 AM
Points: 1, Visits: 0
As I can make a stored procedure to save the transaction in my database.
I will raise it another way, there is some form of a table stored in the history of actions to be carried out in my database and the user which was carried out such action?

try to translate what I know, sorry if there are mistakes in English.
Thank you.
Post #954399
Posted Saturday, July 17, 2010 10:50 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:11 AM
Points: 31,168, Visits: 15,611
If I understand what you are saying, you are looking for an audit trail of what has heppened in your database? There is no log per se. There is a default trace, which has a lot, but it is also limited in size, so the time in which things are stored is relatively short, depending on load.

http://www.sqlservercentral.com/articles/64547/







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #954401
Posted Monday, July 19, 2010 12:56 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 1:49 PM
Points: 1,093, Visits: 1,174
If you want something more advanced you need to build the mechanism yourself. Generally you don't want to log everything, just specific data changes, so it's fairly easy to create log tables and maintain them through the same stored procedures that are performing the data changes.

└> bt


Forum Etiquette: How to post data/code on a forum to get the best help
Post #955045
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse