I've got a problem with a trigger I've set on a table. This is the code for
the trigger:

CREATE TRIGGER Update_Allowance_Rule ON [dbo].[setting_allowance_rule]
FOR UPDATE
AS
UPDATE [dbo].[setting_allowance_condition_rule]
SET [dbo].[setting_allowance_condition_rule].rule_description =
deleted.rule_description
WHERE [dbo].[setting_allowance_condition_rule].allowance_rule_key =
deleted.allowance_rule_key

The problem that I'm having is that when an update occurs on the
setting_allowance_rule the trigger fires but I get the following ODBC error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'dbo.setting_allowance_condition_rule'

setting_allowance_condition_rule does exist, the spelling is correct and it
is owned by dbo. The version of the SQL Server ODBC driver is
2000.81.9030.04. For the life of me, I can't see what I've done wrong. Have
I done something stupid? Any help anyone can offer will be greatly
appreciated.

Thanks


Joe Bertolini