You’re offline. This is a read only version of the page.
I get this
Error -2147217873:
Cannot insert the value NULL into column 'PurchaseOrderID',table 'WH.dbo.PurchaseOrderEntry'; Column does not allow nulls, INSERT FAILS.
Any idea on how to fix this ? maybe add null to column and default 0 ?
*This post is locked for comments
It rehappened something with temp tables are you usig sql2008?
RestRting flushes temp dbs I guess
Very annoying happens to you as well ?
Hello Fcases,
Thank you for posting,
Did restarting SQL fix it entirely, or do you have to reboot it everytime?
Please let me know if this has been a one time instance or if it is continuing.
Thanks,
Clint Skog
seems restarting SQL server works as a fix... but this is weird.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (