dbTalk Databases Forums  

Re: Database error code: 515

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Re: Database error code: 515 in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hari Prasad
 
Posts: n/a

Default Re: Database error code: 515 - 12-14-2006 , 07:59 PM






Hello,

Just see if you insert NULL into Contact_ID field. Please take a look into
table schema using SP_HELP <TableName> and verify the data you
are trying to insert..

Thanks
Hari


"Yigedeb" <Yigedeb (AT) discussions (DOT) microsoft.com> wrote

Quote:
We have MS SQL 2000 server. Recently, on our database application we gate
"Databse error code: 515" It says: Cannot insert the value NULL into
cilumn
"contact_id", table name, column doesn't allow nulls. INSERT fails. No
changes made to databse. ....

A recent action on this table was, we exported the contact table to Excel,
updated, and imported from Excel.

Would you please advise us what the problem could be and how we can
address
this.

Thanks,
Yigedeb.
CBI



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.