Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which column causes the problem?
Message
From
22/03/2015 15:05:37
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2014
Application:
Web
Miscellaneous
Thread ID:
01617084
Message ID:
01617086
Views:
33
>Hi,
>
>When my program executes a stored procedure that updates many fields, the following error is generated:
>
>
>String or binary data would be truncated.
>
>
>I know that it means that I am trying to set the value greater than the column type/length allows.
>
>Is it possible to have the error to include which column is the problem?

Never! That is against Microsoft's policy!

Or else they have fixed the "file not found" which never tells you which file was it. It's unchanged since 1981 or thereabouts. This immediate amnesia, where the code immediately forgets which file/field/routine caused the error, is a long standing feature which will live longer than we do.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform