title: Message: This row was successfully committed to the database. However, a problem occurred
body: <p>I have a table in SQL Server 2005 whose primary key is an identity column (increment 1), and I also have a default value set for one of the other columns.  </p>
  
  <p>When I open the table in SQL Server Management Studio and type in a new record into the table, the inserted values are not displayed, and I get the following message on save:  </p>
  
  <p><img src="https://i.stack.imgur.com/iuTtq.png" alt="messageonsave"></p>
  
  <p>However, if the table has <strong>either</strong> an identity column, <strong>or</strong> one or more columns with a default value specified, the inserted value(s) will be displayed in the table after a save.  And can be edited. </p>
  
  <p>I frequently create test data in ssms this way and this issue makes it cumbersome to do some things I would like to.  </p>
  
  <p>Is there any way around this? </p>