Re: MS SQL 2K thinks user is both there and NOT there... what gives???

sightdev_at_yahoo.com
Date: 01/30/04 

Date: 30 Jan 2004 06:08:10 -0800

If you are still having problem tries this.

1. Common problem when the db is moved to another environment and GUI
is used to recreate the user ID.
2. First check sp_helpuser to see if it is present.
3. sp_dropuser to get clean out the error.
4. sp_adduser to give access/assignment.

When moving database from one relocation to another location
everything including the users should be moved because of the
relations they have as each user id and its environment have unique
keys/id.