If you need to copy a login without knowing the password

20 Aug 2019 11103 views 0 minutes to read Contributors Danny Riebeek


		
			T-SQL
			
Transact-SQL
			
			SELECT 'IF(SUSER_ID('+QUOTENAME(SL.name,'''')+') IS NULL)
BEGIN
CREATE LOGIN '+QUOTENAME(SL.name)+' WITH PASSWORD = '+CONVERT(NVARCHAR(MAX),SL.password_hash,1)+' HASHED, <br />SID = '+CONVERT(NVARCHAR(MAX),SL.sid,1)+'
END' 
FROM sys.sql_logins AS SL
WHERE name not like '##%##' and name <> 'sa'
order by name
			
				
					
				
					1
2
3
4
5
6
7
				
						SELECT 'IF(SUSER_ID('+QUOTENAME(SL.name,'''')+') IS NULL)
BEGIN
CREATE LOGIN '+QUOTENAME(SL.name)+' WITH PASSWORD = '+CONVERT(NVARCHAR(MAX),SL.password_hash,1)+' HASHED, <br />SID = '+CONVERT(NVARCHAR(MAX),SL.sid,1)+'
END' 
FROM sys.sql_logins AS SL
WHERE name not like '##%##' and name <> 'sa'
order by name

If you need to copy a login without knowing the password

Stay up-to-date

Unsubscribe