Some one please advise me regarding this problem. Problem is that there is stored procedure running for doing some work and it is working fine when you run on back end.
When you run from front end through application it pop up with error 'string or binary would be truncated' and program stop in mid.
yes, thats true but how to know there are 8 table running in that procedure each table contain almost 15 fields and and 17 records are getting inserted. and each table has own triggers almost 5,6 per table
check whats the difference in values passed when executed from frond end by debugging the app or running sql profiler in backend. for finding exact place of error, you need to try running each query in batch and check individually. you can also check partial results by putting select statements in between.
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
string or binary would be truncated
Posted - 04/01/2012 : 01:07:47
