Ghost User?

  • 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?

  • Although the user did not have an account, after running EXEC sp_dropuser 'Fareed' the error went away.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply