请教，多谢

我把您这段代码拷到northwind数据库的表Categories的触发器下，怎么打叉，没有处于激活状态，我写了段asp代码删除Categories表里的内容，报错如下：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]DELETE 语句与 COLUMN REFERENCE 约束 'FK_Products_Categories' 冲突。该冲突发生于数据库 'Northwind'，表 'Products', column 'CategoryID'。
/测试/测试.asp, 第 7 行

CREATE TRIGGER Category_Delete

ON Categories

FOR DELETE

AS

UPDATE P SET Discontinued = 1

FROM Products AS P INNER JOIN deleted AS d

ON P.CategoryID = d.CategoryID