A Fix for Database Orphans

Friday Oct 24th 2008 by DatabaseJournal.com Staff

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

Mobile Site | Full Site