Wednesday, June 10, 2009

MS SQL 2000 to MS SQL 2005 import duplicate SID mayhem

The problem: importing a db from a 2000 src resulted in duplicate SIDs.

Utimately the fix:
  1. 1. Create a user login.
  2. 2. Run `ALTER USER WITH Name = [], DEFAULT_SCHEMA = , LOGIN = [];` and sub out the parts

Fixed, imported...other issues still pending...