CREATE LOGIN Veronica WITH PASSWORD = 'YourPass', DEFAULT_DATABASE = YourDatabaseName CREATE LOGIN Trishelle WITH PASSWORD = 'ChangeMe' MUST_CHANGE , CHECK_EXPIRATION = ON, CHECK_POLICY = ON