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.

 

SELECT Name AS DBName, suser_sname(sid) AS Owner FROM master.dbo.sysdatabases WHERE suser_sname(sid) IS NULL

 

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

 

USE <THE DATABASE NAME>EXEC sp_changedbowner 'sa'

 

That should take care of the problem.

Using ASP.NET Development server with NOD32

So, you have installed Microsoft Visual Studio 2005/2008, created a Web Project using the ASP.NET Development server, hit F5 and you are greeted with this:

Internet Explorer cannot display the webpage.

Internet Explorer cannot display the webpage

This is NOD32’s fault.

Set the NOD32’s control panel to advanced mode.

Switch to Advanced Mode

Go to Setup->Antivirus and antispyware…

Configure

and click on Web Access protection->Configure…

HTTP and POP3 ports

Select "HTTP and POP3 ports" in the Protocol Filtering section.

Done!

Enable advanced performance, what’s the deal?

So, on my laptop, a HP 8510w running Windows Vista Ultimate x64, I did enable the advanced performance option in the Policies for the disk:

image

 

What I hoped for was a blasting performance increase that would blow me away.  I enabled it and let it on for a couple of weeks. To my disappointment, I didn’t notice much of an improvement. So today, I disabled it back to default. And let me say this: the performance now is a lot better. Everything is snappier, program starts quicker, everything feels a lot smoother.

I didn’t expect that.

So, really what’s the deal here? Maybe this explains a lot.

My suggestion is to let it be disabled.