EXEC sp_helptrigger <tablename>
will return the types of triggers that are defined on the specified table
for the current database
"Adria" <a-carbotamu.edu> wrote in message
news:25b801c33f29$e8d49200$a601280aphx.gbl...> How can I view all triggers for a table? I am exporting a
> production table to a test machine and need to make sure
> that all triggers have been copied.