修改一个触发器
我要修改一个已存在的触发器：

SQL code

use schoolgoalter TRIGGER TR_CLASS_UPDATEON CLASS for insert,UPDATEAS

运行后报错：cannot alter trigger 'TR_CLASS_UPDATE'on CLASS because this trigger
doesnot belong to this object.这是因为指定的库不对么？

[解决办法]
应该是指定的库不对吧。
[解决办法]

SQL code

select * from sysobjects where id = (select parent_obj from sysobjects where xtype = 'TR' and id = object_id('你的触发器名'))