Very easy way to fix ORPHAN users
Run this script against the database restored from other SQL Server database. It will solve the orphan users.
2003-06-12
769 reads
Fix - Orphaned User Connections
Run the '1'-first script.This stored procedures will easily script all the logins and passwords, which will then help you to transfer them to another SQL Server. Run the '2' - Second Script. This will fix the Orphane Connections. Run the '3' - Third Script. Fixing some Orphaned Users left after step 2. NOTE: Script below […]
2001-12-09
2,118 reads
Blogs
Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning
By kleegeek
Join us on December 8th at 10am Pacific time for an exciting new webinar!...
Daily Coping 3 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 2 Dec 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Holiday Fun for Your Career
Comments posted to this topic are about the item Holiday Fun for Your Career
Get backup folder sizes from shared Location
Comments posted to this topic are about the item Get backup folder sizes from...
ReportingService2010 soap call to set report credentials
I have written a routine to speed up the upload and download of reports...
Ask SSC