Cannot insert the value NULL into column ”, table ”; column does not allow nulls. INSERT fails.

I stumbled upon this error all of a sudden when I was working in a project. There was this SQL Server 2000 database that existed, that very few knew nothing about. This error message confused me a lot, because it didn’t show up when I was running some scripts from the Query Analyzer, but is showed up when I ran the exact same scripts from within a SSIS SQL task.

As it turned out, the database had some unknown owner. Here’s how to find out.

 

 

If you get any results, you can set an owner for those databases using:

 

 

That should take care of the problem.