When using DTS to move the data between two servers, please select the option "transferring objects (not just tables)", which will import both the data and the schema.
The system stored procedure I mentioned is to map the login ID and the database user Id.
If you want to set up the second server which is the standby one for the live server, you have two options:
Both of them can synchronize two servers automatically with some specified delay.
This post has been archived. It cannot be replied.