Raghu
Not sure what you're asking. A trigger is a spcecial kind of stored procedure that runs when a table is updated, inserted into or deleted from. Could you phrase your question a bit more clearly, please?
John
Edit: I see what's happened here - you've replied to an article or script by another user. There isn't a link to the article so I can't comment.