SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
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 VARIABLES --
set nocount on
declare @self int
select @self = CASE WHEN @loginame is null THEN 1 ELSE 2 END
-- RESOLVE LOGIN NAME
if @loginame is null
select @loginame = suser_sname()
-- CHECK PERMISSIONS (SecurityAdmin per Richard Waymire) --
IF (not is_srvrolemember('securityadmin') = 1)
AND not @self = 1
begin
dbcc auditevent (107, @self, 0, @loginame, NULL, NULL, NULL)
raiserror(15210,-1,-1)
return (
SQL数据库: 错误2812 未能找到存储过程 sp_password
最新推荐文章于 2021-07-18 16:07:27 发布
这篇博客介绍了如何处理SQL数据库中遇到的错误2812,具体涉及存储过程sp_password。内容包括密码更改的权限检查、登录名解析、非SYSADMIN用户的限制以及密码变更步骤。同时,文中提供了存储过程的详细代码以供参考。
摘要由CSDN通过智能技术生成