In Below Stored Procedure Id Is Primary Key In Abc Table..While Running This I Want To Insert The Error Details In The Error Table(Exception)..But I Am Getting The Below Error..

See more:

SQL-Server-2012

ALTER PROCEDURE Ins2(@id   INT,@name NVARCHAR(50)) 
AS 
  BEGIN 
      BEGIN try 
          INSERT INTO abc 
                      (id, 
                       name) 
          VALUES     (@id, 
                      @name) 
      END try 

      BEGIN catch 
          INSERT INTO exception 
          VALUES      (Error_number(), 
                       Error_severity(), 
                       Error_state(), 
                       Error_procedure(), 
                       Error_line(), 
                       Error_message(), 
                       Getdate()) 

          SELECT * 
          FROM   exception 
      END catch 
  END 

ERROR:

(0 row(s) affected)
Msg 8152, Level 16, State 13, Procedure ins2, Line 19
String or binary data would be truncated.
The statement has been terminated.
.......