Error 8152: String or binary data would be trucated when using upsizing wizard to SQL Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin Rajotte - 08 Mar 2005 15:05 GMT

Hi,

While running the upsizing wizard to upsize an access 2003 db to SQL Server
2000 I get the following error:

Server Error 8152: String or binary data would be truncated.
Server Error 3621: The statement has been terminated.

It looks like a field in the resulting table is not large enough to handle
the data being inserted but I have no control over this since the wizard is
creating the table...

How can I find out what is causing the problem? Any idea on how troubleshoot
or fix it are welcome.

Thank you for your help.

Reply to this Message

Alex Dybenko - 28 Mar 2005 12:16 GMT

Hi,
what you can do - try to upsize without transferring data, and then transfer
data manually

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hi,
>
[quoted text clipped - 12 lines]
>
> Thank you for your help.

Reply to this Message

LÑIJULO - 26 May 2005 00:22 GMT

Saludos

> Hi,
> what you can do - try to upsize without transferring data, and then transfer
[quoted text clipped - 25 lines]
> >
> > Thank you for your help.

Reply to this Message