Triggers on SQL-Server (RESOLVED)

[swatty]

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.

[ralph]

try
ALTER TRIGGER trigger_name DISABLE;

[techgnome]

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......

[swatty]

Owe you one.

xtype 'TR' = trigger

correct syntax is

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