Joe, first check a table called 'dbo.setting_allowance_condition_rule'
exists. Then try adding a from clause, "FROM
dbo.setting_allowance_condition_rule, deleted"

"Joe Bertolini" <Joe.Bertolini@bgc-contracting.com.au> wrote in message
news:Odh13vGQDHA.2160@TK2MSFTNGP11.phx.gbl...
> 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
>
>