Wednesday, June 9, 2010

For the Next Time I am moving a SQL Database to another server

Not a lot to comment on this; there is a good discussion here but the key bits to lookup on Books Online are:

The stored proceedure sp_change_users_login, look up the topic Troubleshooting Orphaned Users and the proceedure sp_validatelogins. That should be enough to get it all working when I need to to do it about 2 to 3 years as that seems to be the pattern of these things.

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

CiV VII The first 100 hours

First Impressions   I purchased Civ VII from Steam earlier this summer when it was on sale and almost immediately pulled an all-night sessio...

  • Is Conjure Elementals Really Broken
    Does Conjure Minor Elementals damage apply to multi target cantrips like Eldritch Blast? Hi all, Treantmonk a prominent YouTuber recently ...
  • A look at Entity Framework
    What I have been doing since. Been a while since I posted here. Blame real life and some computer issues. Purchased a new laptop as spring...
  • (no title)
    Should you buy the new (2024) D&D Player’s Handbook?      The new edition of Dungeons and Dragons is out, and you may be wondering if it...