USE Secure
GO

-- Create a login with a weak password

CREATE LOGIN MyLogin WITH PASSWORD = 'password'

-- You can skip the password policy

CREATE LOGIN MyLogin WITH PASSWORD = 'password', CHECK_POLICY = OFF
DROP LOGIN MyLogin

-- Edit Group Password Policy

-- start - run - gpedit.msc /gpobject:"LDAP://CN={31B2F340-016D-11D2-945F-00C04FB984F9},CN=Policies,CN=System,DC=AdventureWorks,DC=local"
-- start - run - gpupdate

-- Try again

CREATE LOGIN MyLogin WITH PASSWORD = 'password'
DROP LOGIN MyLogin
