按照一下操作即可!
打开查询分析器,执行以下语句:
drop procedure sp_password
找到一个正常的sqlservel,在master下将sp_password存储过程复制过来
执行一下语句重新建立
create procedure sp_password
@old sysname = NULL, -- the old (current) password
@new sysname, -- the new password
@loginame sysname = NULL -- user to change password on
as
-- SETUP RUNTIME OPTIONS / DECLARE VARIABL...