Moved database, need to set the login name for DBO.

From: CQMMAN (cqmman_at_yahoo.co.uk)
Date: 03/17/05 

Date: Thu, 17 Mar 2005 15:45:23 -0000

Hello,

I have moved a database to a new server (DR scenario). I have sucessfully
recreated one of the SQL user accounts needed, but the other one (lets call
it ACCOUNT2) is more of a problem.

When I look at the users on the database in question, dbo should have a
login of ACCOUNT2. I can't figure out how to recreate this. ACCOUNT2
currently exists on the new server.

I have tried looking at SP_CHANGE_USERS_LOGIN but don't think it will do the
job.

Any ideas?

Cheers 

--
Remember that you are an Englishman, and have consequently won first
prize in the lottery of life" -Cecil Rhodes
"For a century and a half now, America and Japan have formed one of the
great and enduring alliances of modern times."
George W Bush -Tokyo, Japan, Feb. 18, 2002
Happy shall he be, that taketh and dasheth thy little ones against the
stones. Psalms 137:9.
Behold, I will corrupt your seed, and spread dung upon your faces.
Malachi 2:3.
"He who rises up to kill us, we will pre-empt it and kill him first,"
- Ariel Sharon 8th May 2002