Thanks for your input, Jeff. We have SQL Server 2000 SP4 installed on the server in question. Yes, the statement you pointed out in BOL does seem...

Yes, I did notice that. Oddly, in the SQL 2008 BOL, Update() is not even shown in the create trigger syntax. Yet, in 2008, I have used update()...

Sorry -- I forgot to say that, unfortunately, I believe my employer's confidentiality policies prohibit me from posting the trigger in its entirety.

Thanks,

JoBeth

I understand why you doubt me. The error certainly is very strange. But the error is definitely being caused by the update function. As a further...

Yes, I'm certain that's the line that's causing the error. I did a lot of troubleshooting by commenting out parts of the code and running the trigger just to...