Yeah.

I did not change anything. I did not solve the problem. I got around it by opening the table and editing it manually instead of executing sql against it.

the problem was i couldn't run sql statements that explicitly referenced that column.

I've resolved this by manually editing the table, thanks for your time guys.

There are no other triggers on the table. The query I'm trying to run is what I posted just with the user name and password changed. The query is not...

there's a trigger called tu_users on the table but i don't know if it's responsible for the error.

Here's the trigger code:

USE

[My_Database]

GO

/****** Object: Trigger [dbo].[tu_users]...

i'm trying to execute:

update

users

set

password = 'myPassword',

active_flag

= 'Y'