absolutly correct karthikeyan, but beforeDB design we need to analyze do we really need a trigger. If yes the for what purpose we will desing it , trigger may be on table or on database (in Sql 2005 ) so it depends upon the user as well as on developer also.

If suppose DB dev. want to maintain DDL log audit on database then will write a DB trigger.

if want to maintain any table audit will create trigger on tables.