THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » Logins   (RSS)
  • Fixing Orphaned Users

    This is a problem that plagues DBAs everywhere. When you restore a database, you run the risk of orphaning the users in the database. All users are linked via a SID to a login and if you have SQL Server logins, who’s SIDs are managed by SQL Server, you are at risk. Typically a restore to the same server from which the backup was taken ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 17, 2008
  • Scripting SQL Server Logins

    You ever find yourself with the need to copy SQL Server logins from one server to another? Maybe you are setting up a failover site, building a replacement server, setting up a reporting instance, or maybe you just want to backup the logins just in case. If you are using Windows Logins, this is a simple matter of scripting the login and applying ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on September 30, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement