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. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.