String or binary data would be truncated

Toad for SQL Server
1

I have a stored procedure that has run flawlessly for years - last week started throwing up this error. I reinstalled version 6.8.2.9 (64bit) Trial due to the license issue, still getting the error.

This bit appears to be in a header, not sure how to alter. With the int datatype on line 6 - would seem to be a variable that could become a truncate issue but this has been running for a while with no issues.

– Execute Stored Proc SERFF.dbo.RATE_HISTORY

USE [SERFF];
GO

DECLARE @return_value int;

EXEC @return_value = SERFF.dbo.RATE_HISTORY;

SELECT @return_value as N’@Return Value’;

GO

2

nevermind - i found the issue

3

Hi,

Did you reslove your problem?

Michael

4

Yes, I resolved the problem.

Thank you,

Keith