--查看sql server的所有账号和密码,但是密码是加密的,不可逆的.
select
name
,
password
from
syslogins
--如果还记得旧密码,修改密码
Alter
Login [账号]
with
password
=
'newpassword'
old_password=
'oldpassword'
;
--忘记密码,建议直接重置密码
Alter
Login [账号]
with
password
=
'newpassword'
;