Record insertion fialed But no error raise

• lokanadh

  Old Hand

  Points: 358

  More actions

  May 23, 2008 at 2:35 am

  #207587

  I have an SP which is for inserting a new row into table having Identity id column and return new identity value.

  Some times we are getting new identity values and rows is not stored in table. We are getting gaps in Identity values.

  The profiler also shows that this SP is invoked and no exception thrown.

  Our problem is we are not getting any errors in SQL server log or Application log.

  When we tried the same manually insertion is fine.

  Any one have idea on this why this failure in insertion

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  May 23, 2008 at 7:50 am

  #819678

  How are you returning the new ID value?

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE:
  
  

• Phil Factor

  SSC-Insane

  Points: 20254

  More actions

  May 23, 2008 at 7:56 am

  #819685

  ... and make sure there isn't a trigger on the table causing mischief

  Best wishes,
  Phil Factor

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 23, 2008 at 8:54 am

  #819740

  Can you post some code? Include any triggers or any other code in the batch/transaction.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question