title: Msg 8152, Level 16, State 4, Line 1 String or binary data would be truncated These are not real People or SSN's
body: <p>I'm getting an error:</p>
  
  <blockquote>
    <p>Msg 8152, Level 16, State 4, Line 1<br>
    String or binary data would be truncated</p>
  </blockquote>
  
  <p>What am I doing wrong?</p>
  
  <pre><code>INSERT INTO Person(PID, First_Name, Middle_I, Last_Name, Birth_Date, SSN, Gender, Student_Active, Staff_Active, Mod_date)
  VALUES (1, 'Mohammad', 'A', 'Ratliff', '1957-06-04', '346-05-9842', 'M', 'Yes', 'No', '19563-06-04'),
         (2, 'Lidia', 'B', 'Knapp', '1955-08-13', '758-10-7115', 'F', 'Yes', 'No', '19542-07-02'),
         (3, 'Alexandre', 'C', 'Wright', '1989-01-06', '567-30-3117', 'M', 'Yes', 'No', '19564-02-1'),
         (4, 'Cortez ', 'D', 'Payne', '1983-10-08', '513-30-0449', 'M', 'No', 'No', '19532-06-04'),
         (5, 'Sherman', 'E', 'Yang', '1955-12-29', '246-97-0792', 'M', 'Yes', 'Yes', '19547-06-04'),
         (6, 'Remington', 'F', 'Montoya', '1989-01-22', '672-20-4607', 'M', 'Yes', 'No', '19554-02-05'),
         (7, 'Yessenia', 'G', 'Petty', '1967-12-03', '508-78-9337', 'F', 'Yes', 'No', '19547-01-01'),
         (8, 'Yvette', 'H', 'Mcgowan', '1979-10-29', '019-88-7329', 'F', 'No', 'No', '19123-04-09'),
         (9, 'Hugh', 'I', 'Cooke', '1950-03-12', '699-14-9893', 'M', 'Yes', 'No', '19563-06-04'),
         (10, 'Curtis', 'J', 'Mooney', '1979-09-17', '193-20-2358', 'M', 'No', 'No', '19551-02-07'),
         (11, 'Desiree', 'K', 'Ayers', '1981-10-16', '256-84-1903', 'F', 'Yes', 'Yes', '19533-07-08');
  </code></pre>
  
  <p>Here is my table:  </p>
  
  <p><a href="https://i.stack.imgur.com/Ir5e3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ir5e3.png" alt=""></a></p>