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
766 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,105 reads
Blogs
SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the...
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
Forums
What is spinlock ALLOC_CACHES_HASH?
Hi, Queries are slow, cpu usage at 80%. ALLOC_CACHES_HASH backoffs start at same time...
BULK insert several thousand files
I have a bunch of logging data that my sysadmin has downloaded from our...
SSRS 2016 install on FCI with AAAG.
Appreciate advice here as I am slightly confused. I need to install SSRS 2016...
Ask SSC