.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

sql logs

Posted By: vikas     Posted Date: November 10, 2009    Points:2   Category :Sql Server
i hav a table in sql database..i want to keep track of the table if i perform any operation like update delete on table...how can i do this with sql logs n triggers

Author: Amit Mehra             
Posted Date: November 11, 2009     Points: 5   


You can perform with the QueryAnalyzer in sql server client. But if you want to read log file generated by sql server than you can use this article



Please "Mark As Answer " if this post help you.
Author: Alwyn The Master             
Posted Date: December 02, 2009     Points: 5   

It's Simple,
Create a table with a name as Logger
When ever u update or insert or delete, add an entry to logger table.
then u can easily track what are the changes made to a specific table
by querying the logger table.

Thanks & Regards,

Jesus Saves ! Rest of us better make backups.

Author: Lalij Mer             
Posted Date: January 29, 2010     Points: 5   

show here article


Please Check my answer if you help....
Thank You...

Author: vikas             
Posted Date: January 29, 2010     Points: 5   

hello Alwyn The Master
i want to do this by only one trigger for all database tables
and want to store all database tables track into a single tack table
how can i do this????
MY Track_Table fields are TableName(Employee,Customer),Operation(insert,Delete,Update),id(Like Employee id which is updated),oldValue(Old EmployeeName),NewValue(New EmployeeName).
i want to store these All Filds by single Trigger for all database tables.
Track_Table Will be Single For all database tables(Like Employee,Customer)

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend