Script to alter all SQL Server users password

The script bellow will create the syntax used to alter the passwords of all users. I use this script when i clone a database from production to development and i don't what that the user maintain the same password.

SET NOCOUNT ON
SELECT
'ALTER LOGIN [' + loginname + '] WITH CHECK_POLICY=OFF
go
ALTER LOGIN [' + loginname + '] WITH PASSWORD=''new_passw''
go'
FROM syslogins
WHERE name NOT IN ('asql') and name not like '%#%'
AND isntname = 0


Leave a comment or a question in the comment area bellow if you fell like


Be a sport and

Search

Loading... Please wait

Subscribe to our Newsletter

Be a sport and

x