Although BCP is the correct answer, you can also correct the orphaned
logins to users with sp_change_user_login. I now work for Oracle and rarely
do MSSQL, but here's your answer,
http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm
Good luck,
Kellyn
On Jan 6, 2016 07:59, "Rich J" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx> wrote:
On 2016/01/06 06:55, angelo wrote:
Good morning John,
Try to make a backup/ restore of the database, all of whole schema from
the database you had targeted for backup will be included.
The backup/restore does work, but it breaks security if *server* logins
are mapped to *database* schemas, which they likely are (aka "orphaned
users"). And I'm excluding things like replication and encryption that I
thankfully have not had to deal with in the SS world.
Since I've had to deal with SQueaL Server, I've had good luck finding many
answers at places like sqlservercentral.com. Googling for SS answers has
often been counterproductive for me due to the morass of "expert" blogs.
Or try PostgreSQL instead. ;)
GL!
Rich
