tofan.nayak (1/18/2012)
more.....
That's for logon triggers. Setup a table trigger and try for yourself with an insert trigger.
CREATE TABLE SourceData
(SomeData VARCHAR(20))
INSERT INTO SourceData VALUES ('abc')
INSERT INTO SourceData VALUES ('def')
INSERT INTO SourceData VALUES ('ghi')
INSERT INTO SourceData VALUES ('jkl')
CREATE TABLE TargetData
(tdID INT Identity(1,1) NOT NULL,
SomeData VARCHAR(20))
CREATE TABLE DataLog
(tdID INT, DateOfEntry DATETIME DEFAULT (GETDATE()))
CREATE TRIGGER tr_i_TargetData
ON TargetData
FOR INSERT
AS
INSERT INTO DataLog (tdID)
SELECT tdID FROM Inserted
GO
INSERT INTO TargetData (SomeDAta) VALUES ('TestEntry')
SELECT * FROM DataLog
Now do a datapump in SSIS 2k5 from source to target and then recheck the DataLog table. The logging will not have fired.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA