"dbo" user lost after having a database restore

Sometimes (but not always), "dbo" user will be lost after having a database
restore, how can I make the "dbo" user appear again ?Probably because the database was owned by some login which doesn't exist on
the destination SQL Server. Use sp_changedbowner and change the owner to sa
or some other existing login.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1svec$pq94@.imsp212.netvigator.com...
> Sometimes (but not always), "dbo" user will be lost after having a
database
> restore, how can I make the "dbo" user appear again ?
>