go to query analyzer and give the following command sp_droplogin and
username whichever it is.

or go in system databases to sysusers table and delete the user from the
table and add the user again.

Thanks and Regards
simerjeet
----- Original Message -----
From: "Kumar" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, July 23, 2003 3:31 PM
Subject: Moving SQL DB to another Server


Dear Friends,

I am running 2 MS SQL 2000 servers on Win2k server machines. In the server 1
a DB is running which is having the objects owned by user X. I want to move
the db to the server 2. For this I have done using the following methods.

(1) Backup the Db from server 1 and restore it in server 2 and created the
user X in the Server 2. While I connect to the Query Analyzer, the DB was
not shown to be. While I assign the user X as the DB owner, in the server
2, it never allowed me, saying the user already has objects.

(2) While use DTS to do the migration, the job failed.

How can I over come this problem? Looking for ur valuable advises.

Regards
Kumar

MS Sql Server LazyDBA home page