The user still exists and has the correct authority on the database itself after the restore. I need to update the Login to add the authority for the database...

I have got around my original problem by adding the user to the database that I am restoring from. Thanks to all the replies.

I now have another problem where...

The sp_change_users_login is used to correct users when there is no login. In this case I have a login but no user. Is there a similar procedure I...

Thank you, Thank you, Thank you Ian Scarlett. That has solved my problem:kiss:

The copying of the .bak file is not a problem. The problem is the restore.

I am using REXX to connect to the server using SQLConnect and execute the stored procedure....