Sql change password

From Logic Wiki
Jump to: navigation, search


USE Master
GO
ALTER LOGIN username WITH PASSWORD = 'new_password'
GO
ALTER LOGIN username WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;