\SQL\Aeries SQL
  Back
 Count of SBG in All Databases.sql
 Create Role SQL.sql
 Create User Statements.sql
 Merge BCY, BST, BCU Between Years.sql
 Reset All Users Passwords.sql
 Roles Assigned to a Role.sql
Reset All Users Passwords.sql 
/*
	Generate "Alter Login" scripts to reset all users passwords to 'welcome'
*/

select 'ALTER LOGIN [' + name + '] WITH PASSWORD=''welcome'', CHECK_POLICY=OFF' 
from sys.sysusers
where 
	issqlrole = 0 
	and islogin = 1
	and not name in ('public', 'dbo', 'guest', 'INFORMATION_SCHEMA', 'sys')