Failing to update/insert into column

[mike55]

Hi all,

 

My problem is as follows, I have a database table which contains multiple columns, one of these columns is called "Custom7". If I attempt to insert or update and row, the command will execute correctly and all the data, except "Custom7" will be inserted/updated.

 

I can understand why this column in particular is acting up, I have checked with the people that I work with, and they confirm that the stored procedures that I am using are correct. I have confirmed that the correct data is going into the stored procedure. I am not getting an error back from the stored procedure. And finally, the same code worked correctly in a SQL Server 2000, and works correctly on another persons machine.

 

Any suggestions on what is causing this error, or how I can solve it?

 

Mike55.

[Igor Sukhov]

Hi all,

 

My problem is as follows, I have a database table which contains multiple columns, one of these columns is called "Custom7". If I attempt to insert or update and row, the command will execute correctly and all the data, except "Custom7" will be inserted/updated.

 

I can understand why this column in particular is acting up, I have checked with the people that I work with, and they confirm that the stored procedures that I am using are correct. I have confirmed that the correct data is going into the stored procedure. I am not getting an error back from the stored procedure. And finally, the same code worked correctly in a SQL Server 2000, and works correctly on another persons machine.

 

Any suggestions on what is causing this error, or how I can solve it?

 

Mike55.

 

What type of the "Custom7" column ?

Do you have any triggers on the table you're working on ?

I've mentined that your code works correctly on another machine, is that machine uses the same SQL Server ? Does that machine have the same "

"regional and language" settings?