Browse by Tags

• Security

• 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, Read More... Posted Friday, October 17, 2008 11:32 AM by ejohnson2010 | 3 Comments Filed under: Logins, Security, SQL Server 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. Read More... Posted Tuesday, September 30, 2008 2:58 PM by ejohnson2010 | 5 Comments Filed under: Logins, Security, SQL Server 2008