Triggers on SQL-Server (RESOLVED)

Anyone know how i can retrieve the tables where there are triggers set through code.

I need to transfer data from Access db to SQL-Server db.
The triggers should be set OFF to transfer all data and after tranfer is done they must be set ON.

Can this be done and how.

I don't want to use enterprise manager to check all them tables.

try
ALTER TRIGGER trigger_name DISABLE;

Quote:

---

Originally posted by ralph
try
ALTER TRIGGER trigger_name DISABLE;

---

Right, but he needs trigger_name first.....

Try doing a SELECT * FROM sysobjects and see what gets returned. Then add WHERE clauses to return only triggers. Try using the xtype .... I know that 'U' = User table, 'P' = stored proc, 'F' = Function, 'V' = View.... hope that helps......

Owe you one.

xtype 'TR' = trigger

correct syntax is

VB Code:

[COLOR=blue]ALTER TABLE[/COLOR]  table_name DISABLE [COLOR=blue]TRIGGER[/COLOR]  trigger_name