To work around this problem, use the sp_changedbowner stored procedure to change the owner of any databases owned by a login that does not exist on the new server to...

I removed the one null user but I still have the problem below:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q218172&

Any ideas?

Neil

I was hoping to find somethign that ran that on all the databases. Right now none of these databases show a DBO user which I can't imagine is good!

Right?...

can I add a user to that role?

neil

I checked all privleges for that user. I am trying to allow this user to make FullText Catalogs. Do you know what permissions on which DB he will...

Got it 🙂 I changed a bunch of permissions on that user. I removed them and its all better now...

Thanks...

Neil

Is there a way to search in these forums? I posted pretty comprhensive stuff on my last mention of this problem...

Neil

I just got that and it worked. I guess after talking it out and writing it in here it seemed a lot easier 🙂

Thanks!

Neil

Its ok the link you sent me with that storedproc showed me. I had an old stored proc that referenced a column that didn't exist and it was making...

No history other than the days I reschedule it to 5 minutes before that moment.

Strange huh?!

Neil

No other jobs running. I am checking the maintenance history. I think it filled up and then stopped recording but if I recall I purged it.

Checking now...

Neil

What about Tables that have the name in it? How can I find those?

Neil

I get an error when DTS'ing but that is because somewhere in my DB there is a reference to an old column name which no longer exists. I would...

MY DB is broken somehow and I need to figure out how and how to correct it.

Neil

Can I remove the relationship or find all objects that contain the column name?

Neil