Only if the Sql logins already exist on BOTH servers with different SID's. If you bcp the info over (or any other method) that preserves the SID, then everything works, period.

Andy