Is this what you mean

sp_change_users_logins 'Auto_fix'

  ,@UserNamePattern = 'user'

  ,@LoginName = 'null'

  ,, @passwd = "'password'

I tried it the Auto_Fix value and it would'nt work. the error was: The Action 'Auto_Fix' is incompatable with the other parameter values ('(NULL)', '(NULL)').

Thanks...I was able to resolve one id but the one that is the the table owner and is a dbo for the database I can't change.  I tried to alias...

Ok.  Thanks for the response.

Thanks for your help.

Thanks, That did the trick.

I did that yesterday. I'm still hoping that I (or someone else) can figure out how to make the copy database procedure work.

Thanks, I read the article, we aren't using the Local System Account we're using a domain account that has rights as a local admin, on the network, and as...

thank you...that does the trick.

I appreciate your help more then you'll ever know.

I did as you suggested and got the following:

Membership of the public role cannot be changed.

Is there possibly another way to this?

Is there a script that I can run to remove all 2800 logins at once?

I'm bringing over only the id's associated with that specific database and taking all the other defaults options given.

No I didn't. Is that required and if so, are there other objects I should remove before trying again?

Thanks for the help. I believe this will do the trick.

The users are setp only on server a. Is there a way to copy both the users and permission via a stored procedure?