4>
5>
6> DECLARE cuTriggers CURSOR
7> FOR
8> SELECT name FROM sysobjects WHERE type = 'TR'
9> OPEN cuTriggers
10> DECLARE @chvTrigger VARCHAR(30)
11> FETCH NEXT FROM cuTriggers INTO @chvTrigger
12>
13> WHILE (@@fetch_status <> -1)
14> BEGIN
15> EXEC ("DROP TRIGGER " + @chvTrigger)
16>
17> FETCH NEXT FROM cutriggers INTO @chvTrigger
18>
19> END
20> DEALLOCATE cuTriggers
21> GO
1>