A Fix for Database Orphans

Friday Oct 24th 2008 by DatabaseJournal.com Staff
Share:

A common problem when restoring databases is making orphans of users. Here's a quick fix.

[From Microsoft Certified Professional Magazine]

Because SQL Server manages SIDs for any user logging into SQL Server, you risk "orphaning" users when you do a restore. It's a common problem and here's why.

The article continues at http://mcpmag.com/columns/article.asp?editorialsid=2852

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved