I recently upgraded from SQL Server 2000 to SQL Server 2008. To do this, I created new databases in 2008, then restored the 2000 bak file to the 2008 database. All seems to be working just fine for about a week now.
I need to change the length of a varchar field from 50 to 200 characters. Should be simple enough. However, I'm getting a message stating that the change can't be made because there is no owner assigned to the database. I've tried changing the owner using:
exec sp_changedbowner 'netadmin'
I am getting this message:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database.
It doesn't make sense to me that I can only assign a database owner that does NOT exist. What am I missing here?