Sql server 2005 weird issue...

D3vy

Hi

Im using SQL Server 2005 and am having a strange problem... I get the following error when trying to modify any data on row 1 on a specific table, I cant edite/delete any of the values for ANY column.. and I cant delete the row (I get the same error)
All of the data types are OK as the same data in another row is fine... Any ideas?

screenshot of error: http://david.exact3ex.co.uk/error.gif 

Thanks in advance.

david

KenW

[quote user="devy"]Hi

Im using SQL Server 2005 and am having a strange problem... I get the following error when trying to modify any data on row 1 on a specific table, I cant edite/delete any of the values for ANY column.. and I cant delete the row (I get the same error)
All of the data types are OK as the same data in another row is fine... Any ideas?

screenshot of error: http://david.exact3ex.co.uk/error.gif 

Thanks in advance.

david

[/quote]

The data truncation part of the message gives you the answer. You're doing something with data that's too large to fit within one of the columns.

You might try asking your question (with DDL of your table and the data and SQL you're using) in the forums at SQLTeam.com.

Ken

D3vy

That was my first thought, however the same data in a different column works without any problem...

Also I dont see how that would affect my ability to delete the row?

Besides the data that Im changing is an int value changing it from 1 to... 2 dont see why truncation would be needed??

Angstrom

Check your triggers.