- Docs
- /
06 Jun 2022 15331 views 0 minutes to read Contributors
T-SQLTransact-SQL
1234567 SELECT 'IF(SUSER_ID('+QUOTENAME(SL.name,'''')+') IS NULL)BEGINCREATE 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 SLWHERE name not like '##%##' and name <> 'sa'order by name
In this article
Please choose a monitoring environment to connect to:
Enter your email address to recover your password.
Download link successfully sent. Check your email for details.
Reset password link successfully sent to . Check your email for details.
An email with a link for creating your password is sent to
Share link successfully sent to .
Your reply is send.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
Download link successfully sent to . Check your email for details.
We received your request. We will contact you shortly