How to change DBO Login name 1

[dbrew0]

Hi all,

After copying a user database I've noticed that the dbo user does not have a login name (the field is blank). How can I change the login name for the dbo user?

Thanks,
Dan B.

 

[Corran007]

Use Databasewithoutowner

exec sp_changedbowner 'newonwernamehere'

 

[dbrew0]

Thanks Corran007,

That did the trick. It's tough being a newbie at this.

Thanks again,
Dan