Re: Off topic MS SQL Server

From: Kellyn Pot'Vin-Gorman <dbakevlar_at_gmail.com>
Date: Wed, 6 Jan 2016 08:16:27 -0700
Message-ID: <CAN6wuX26O9SRwSX5gUGR7GRQrUouCdoPt2qhLAPnMDn+BZe4Lg_at_mail.gmail.com>

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_at_society.servebeer.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 06 2016 - 16:16:27 CET