title: Find error (line of error) in sql server managment studio message window
body: <p>I have Over 5000 insert query that i want to execute in Sql server mangement studio(SSMS)
  when these insert query execute with no problem in message window show <strong>Query Executed Successfully</strong>
  but my problem is when some of them of these query has error the message is <strong>query completed with error</strong> and in message window its difficult to find between</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>Msg 2627, Level 14, State 1, Line 1...</p>
  
  <p>*<strong><em>My Error Detail .... *</em></strong></p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected)</p>
  
  <p>(1 row(s) affected) </p>
  
  <p>is there any way just sql server show error in message window?</p>