Very Computer

I have two installations of SQL Server both have the same
database, then I run the same store procedure ( It insert
several rows into a table) on both DB and for one of these
I got an error.

The error

8152    16      String or binary data would be truncated.

Why I got an error just for one DB, exist any
configuration which increase or decrease the error
tolerance.

I follow the store procedures and the row that has the
problem is not inserted in both cases but just one report
this to me.

I need this two DB supporting this kind of errors (Warning
for me!) because is out of control the maximum size of the
fields due to this messages came from an unknown HOST.

Thanks,

David

You're sure that both tables have the EXACT same column data types? You may
want to double check.

Zach

Quote:> I have two installations of SQL Server both have the same
> database, then I run the same store procedure ( It insert
> several rows into a table) on both DB and for one of these
> I got an error.

> The error

> 8152 16 String or binary data would be truncated.

> Why I got an error just for one DB, exist any
> configuration which increase or decrease the error
> tolerance.

> I follow the store procedures and the row that has the
> problem is not inserted in both cases but just one report
> this to me.

> I need this two DB supporting this kind of errors (Warning
> for me!) because is out of control the maximum size of the
> fields due to this messages came from an unknown HOST.

> Thanks,

> David

Yes, I did a strict check. Any idea??

I think this "error" is actually a warning.  The fact that this error occurs
on one server and not another would indicate the setting "ANSI_WARNINGS"
would be off on one and on on the other.

Tim

Quote:> I have two installations of SQL Server both have the same
> database, then I run the same store procedure ( It insert
> several rows into a table) on both DB and for one of these
> I got an error.

> The error

> 8152 16 String or binary data would be truncated.

> Why I got an error just for one DB, exist any
> configuration which increase or decrease the error
> tolerance.

> I follow the store procedures and the row that has the
> problem is not inserted in both cases but just one report
> this to me.

> I need this two DB supporting this kind of errors (Warning
> for me!) because is out of control the maximum size of the
> fields due to this messages came from an unknown HOST.

> Thanks,

> David

[posted and mailed, please reply in news]

This error is dependent on the setting for ANSI_WARNINGS. This setting
can be set in various ways. You can set up a global default by means
of the configuration parameter useroption. You can set it on database
level as a database option, and you can set it per process with
SET ANSI_WARNINGS ON/OFF. The latter takes precedence and the
default behaviour by ODBC and OLE-DB is to turn this setting on.

--
Erland Sommarskog, Abaris AB

SQL Server MVP