Lowell,

I changed the procedure:

=============

ALTER PROCEDURE [dbo].[sp_InsertKeyIssues]

@KeyIssuesText nvarchar (250),

@ClinicalReviewID nvarchar(10)

AS

SET NOCOUNT ON;

BEGIN Try

Insert into tblKeyIssue

(KeyIssuesText ,ClinicalReviewID)

Values

(@KeyIssuesText ,cast(@ClinicalReviewID as int))

return @@rowcount

Print cast(@@rowcount as nchar(1))

END Try

begin catch

exec sp_SqlInsertError

end catch

=============

Then tried to generate...

Note that the second parameter in the main procedure declared as int .

In the first run I put quoted 'abc' - and it returned a message 'cannot convert nvarchar...