Fix orphaned users after restoring database to another server.
Script reassigns database orphan users to the matching SQL Server logins.
2011-11-15 (first published: 2011-10-24)
2,544 reads
Blogs
Architect a disaster recovery for SQL Server on AWS: Part 1
New blog post - Architect a disaster recovery for SQL Server on AWS: Part...
Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.
New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...
Daily Coping 3 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
How to determine whether SSIS is being used?
Hello I've inherited some dev environment which looks like was abandoned, but I'd like...
xml output from sql query
The script runs but gives me "no data to export" I see data in...
Dynamically Update A Parameter to Pass to Another Report
I have an existing SSRS Report which displays the following: UserName, UserID, DOB Bill...
Ask SSC