新闻中心
新闻中心
速达提示2812错误

如何速达软件有提示2812错误,需要后台执行SQL代码来解决  请联系客户服要代码。

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 (1)
end
ELSE
begin
dbcc auditevent (107, @self, 1, @loginame, NULL, NULL, NULL)
end
-- DISALLOW USER TRANSACTION --
set implicit_transactions off
IF (@@trancount > 0)
begin
raiserror(15002,-1,-1,'sp_password')
return (1)
end


本问题解决需要懂数据库知识 请联系公众号客服协助

上一条:速达提示sa密码错误
下一条:速达软件输入文字变成问号?
 
QQ在线咨询
售前咨询:
400- 800- 4362
售后服务:
0755-27890045