Thanks Thom,

But this would just disappear the warning. Let me make it more clear about what i am looking for

create table TEST_INSERT
(id int , name varchar (3))

GO 

INSERT INTO TEST_INSERT
SELECT 1, 'FOUR'

In case the warnings are on i get the error, otherwise it says completed successfully and in both cases nothing gets inserted.
What I am looking for is to have the first 3 characters inserted and the rest ignored.
I cannot use a LEFT/SUBSTRING function as I am trying to fetch data from a linked server.

Thanks.