Ghost user?

[ramsfield]

I have a database that has been running for some time without problems. We have recently built a new server and are in the process of moving the database from the old to the new. When I use the import / export wizard, the process starts fine but then fails with the error message

User or role Fareed does not exist in the database

Although Fareed was a user at one time, he has been removed a couple of years ago. I can not find any references to this user. What is causing this error message and how can I make it go away so that I can use import / export?

 

[SQLDenis]

run EXEC sp_dropuser 'Fareed '
before moving over the db


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ramsfield]

Dennis, this worked. Thank you!

So how can there be a user without there being a user? Meaning, I did not see this user anywhere, but was able to delete him? Did an association get orphaned or ?

 

[SQLDenis]

If you run this
EXEC sp_helpuser


are there any other ones?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ramsfield]

Yes, two for this database.

dbo (sa) - master db

imagex - mason db

dbo db_owner sa master 1
imagex ImageXRole imagex mason 7

Both of which are valid users

 

[SQLDenis]

Maybe Voodoo?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[ramsfield]

Well, as long as the blue smoke doesn't escape from the computer, we will be OK.

Thanks again fo ryour help!