Error on admin_stats.asp, line 84 : Microsoft OLE DB Provider for SQL Server error '80040e2f'

Hey Guys,

I'm getting the following error:
-----------------------
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.
/admin_stats.asp, line 84
-----------------------

It was working fine before. I have not changed anything.

I have logged in as Admin and the "General Stats and Information" page is showing an error.

The rest of the forum is working fine.

Any ideas why this error might be occuring?

Thank you for your help.

Regards
nik

This has something to do with the database server: You currently do not have a owner on your database. sp_helpdb system stored procedure requires a valid owner on the database in order to run.

Someone on the server side must have removed the owner for some reason. Please ask your server admin to check on it.

Samuel,

I am my own server Admin.

I did some changes to the PDC of the server. I changed the Server Domain.
Would this have affected it?

How do I add a valid "Owner" to the Database?

Thank you for your help.

Regards
nik

You should see that the Owner is listed as (unknown) on your database. To see the owner of the database, right click on your database in enterprise manager, and then select properties.

If the owner is indeed unknown,

1.
=======================================================
EXEC sp_changedbowner 'a username not in your database'
=======================================================

And then

2.
================================
EXEC sp_changedbowner 'sa'
================================

That worked.
Thank you.

Regards
Nik