trigger a table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

trigger a table

hi guys,
I am think how to implement this table.
I need load staging table to data warehous.
I want a table called status, and before loading, I want to insert current time and date to this table, after loading is complete, I want to insert another column to store finish time.
can you use trigger to do it.
how to fire trigger before and after loading.
thanks.
http://www.sql-server-performance.com/nn_triggers.asp
http://www.sqlservercentral.com/columnists/bkelley/triggers_1.asp Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>