Simple update query is making me lose my mind...

[somesteve]

I feel so stupid for posting this but I cannot figure out why I'm getting an error with this simple update query.

update [spa work order pgsql]
set [scan_closing] = '02/14/06 06:00:00 AM'
where [scan_closing] = '02/14/20 06:00:00 AM'

Gives me the following error:

Server: Msg 512, Level 16, State 1, Procedure HIFL3253_SO_15155, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

And that's it. I cannot grok that error message BECAUSE THERE'S NO SUB QUERY. I can see no reason why this should error out. Thanks in advance to anyone who points out whatever simple thing I've missed.

[seenirajr]

Check your update triggers.

[somesteve]

Check your update triggers.

Thank you kind sir. There was a trigger in there I didn't know about. It just didn't occur to me to look at those.

[somesteve]

UPDATE:

I'm in the process of doing a lot of clean up work on the db.
<WTFery>
When I first got here there were 117 triggers on the main table that ran everytime ANY entry was updated. Performance killer would be a kind way to put it. Those triggers came from an ASP page that actually PRODUCED a trigger for a dealer that sent an email when their product shipped. I dealt with those triggers and ASP pages and got it down to 3 triggers for the table. Anyway, you've just alerted me to ANOTHER page that was doing the same thing, just not with the same frequency so it escaped my attention because I thought I'd finished with that horrible mess.
</WTFery>

Thanks again. Knew it was something simple I was missing.