Error Message after executing sp

• Himansu Amin

  Ten Centuries

  Points: 1041

  More actions

  January 12, 2007 at 9:21 am

  #193846

  Hello everyone,

  I keep getting this error message after executing a stored procedure NOT created by me:

  [Server: Msg 515, Level 16, State 2, Procedure pExportNoAgeMailAppend, Line 41

  Cannot insert the value NULL into column 'Line', table 'tempdb.dbo.#Temp_______________________________________________________________________________________________________________000100024730'; column does not allow nulls. INSERT fails.

  The statement has been terminated.]

  ** I have other co-workers executing the same stored procedure and they have no problems.  Are there any settings I'm missing?  Please advise.

  --

  Thanks,

  Himansu

   

• Himansu Amin

  Ten Centuries

  Points: 1041

  More actions

  January 12, 2007 at 1:19 pm

  #683040

  After doing this:

  Tools ---> Options ---> Connection Properties ---> "check" off 'Set ansi_defaults"

  --

  this worked.