December 3, 2008 at 8:34 pm
What is audit login? How To Handle This In DataBase Level?
December 3, 2008 at 9:47 pm
lav (12/3/2008)
What is audit login? How To Handle This In DataBase Level?
im my organization at the time of auditing, i create a backup of the database upto the required date and lock all the tables and allow only the select statement for the purpose of auditing. or we can say that we create another application setup upto a required date
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 10:14 pm
Suppose I Want Maintain All Trans. Information In My DataBase .For Eg. A User Insert a Record In a Table I Want To Store Which user insert a record and which table and which column update (old value,new value)how to handle this?
December 3, 2008 at 10:33 pm
lav (12/3/2008)
Suppose I Want Maintain All Trans. Information In My DataBase .For Eg. A User Insert a Record In a Table I Want To Store Which user insert a record and which table and which column update (old value,new value)how to handle this?
Which user you are talking about , the sql user or the UI user, but i prefer in both the cases, use triggers, u can use them as an end level tracker, before the information passes into their respective database.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
December 3, 2008 at 10:51 pm
How to use trigger ? i want to store User Interface User
December 3, 2008 at 10:56 pm
lav (12/3/2008)
How to use trigger ? i want to store User Interface User
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server[microsoft].
Triggers execute when a user tries to modify data through a data manipulation language (DML) event. Events are INSERT, UPDATE, or DELETE statements on a table or view.
Example:
USE AdventureWorks;
GO
IF OBJECT_ID ('Sales.reminder1', 'TR') IS NOT NULL
DROP TRIGGER Sales.reminder1;
GO
CREATE TRIGGER reminder1
ON Sales.Customer
AFTER INSERT, UPDATE
AS RAISERROR ('Notify Customer Relations', 16, 10);
GO
I would prefer to use Insert statements inside the trigger except the update and Delete due to the performance issues.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply