History actions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » History actions

History actions

Rate Topic

Display Mode

Topic Options

Author

Message

crojas

Posted Saturday, July 17, 2010 10:44 AM

Forum 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

Steve Jones - SSC Editor

Posted Saturday, July 17, 2010 10:50 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406, Visits: 13,723

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

bteraberry

Posted Monday, July 19, 2010 12:56 PM

Ten Centuries

Group: General Forum Members
Last Login: Saturday, February 23, 2013 11:07 AM
Points: 1,103, Visits: 1,170

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 »

Permissions