You are here

Home

TSQL – Orphaned User Script

ben himself's picture
published by ben himself on Sat, 03/19/2016 - 16:39

Finding Orphaned Users

USE [db]
GO
EXEC sp_change_users_login 'Report'
GO

Fixing Orphaned Users

USE [db]
GO
EXEC sp_change_users_login 'auto_fix', 'USERNAME'
GO
Tags: 
tsql
sql server
orphaned users
Categories: 
SQL Server
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
1 + 5 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Theme by Danetsoft and Danang Probo Sayekti inspired by Maksimer