如何解密Sql Server 2008中的存储过程？

大家好

我的一位同事创建了 SP，现在我想管理所有这些事情，我不知道如何解密该程序，我们丢失了该程序的副本。

我正在使用以下代码来解密我的过程，但它无法获取它始终给出空值的过程。

create  PROCEDURE sp_decrypt_sp (@objectName varchar(50))
AS
DECLARE  @OrigSpText1 nvarchar(4000),  @OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000)
declare  @i int , @t bigint , @ct nvarchar(max)

--get encrypted data
SET @OrigSpText1= (SELECT top 1 ctext FROM syscomments  WHERE id = object_id(@objectName) order by colid)
SET @OrigSpText2='ALTER PROCEDURE '+ @objectName +' WITH ENCRYPTION AS '+REPLICATE('-', 3938)
EXECUTE (@OrigSpText2)
print @OrigSpText1

SET @OrigSpText3=(SELECT top 1 ctext FROM syscomments  WHERE id = object_id(@objectName) order by colid)
SET @OrigSpText2='CREATE PROCEDURE '+ @objectName +' WITH ENCRYPTION AS '+REPLICATE('-', 4000-62)

--start counter
SET @i=1
--fill temporary variable
SET @resultsp = replicate(N'A', (datalength(@OrigSpText1) / 2))

--loop
WHILE @i<=datalength(@OrigSpText1)/2
BEGIN
--reverse encryption (XOR original+bogus+bogus encrypted)
SET @resultsp = stuff(@resultsp, @i, 1, NCHAR(UNICODE(substring(@OrigSpText1, @i, 1)) ^
                                (UNICODE(substring(@OrigSpText2, @i, 1)) ^
                                UNICODE(substring(@OrigSpText3, @i, 1)))))
print @resultsp
 SET @i=@i+1
END
--drop original SP
--EXECUTE ('drop PROCEDURE '+ @objectName)
--remove encryption
--preserve case
SET @resultsp=REPLACE((@resultsp),'WITH ENCRYPTION', '')
SET @resultsp=REPLACE((@resultsp),'With Encryption', '')
SET @resultsp=REPLACE((@resultsp),'with encryption', '')
IF CHARINDEX('WITH ENCRYPTION',UPPER(@resultsp) )>0 
  SET @resultsp=REPLACE(UPPER(@resultsp),'WITH ENCRYPTION', '')
--replace Stored procedure without enryption
set @ct = (SELECT ctext FROM syscomments WHERE id = object_id(@objectName))
print @ct
execute( @resultsp)
GO

谢谢大家

解决方案4
解决方案1
解决方案2
解决方案3
解决方案5

解决方案4

尝试这个

SQL

create  PROCEDURE sp_decrypt_sp (@objectName varchar(50))
 AS
 

 
 DECLARE  @OrigSpText1 nvarchar(4000),  @OrigSpText2 nvarchar(4000) , @OrigSpText3 nvarchar(4000), @resultsp nvarchar(4000)
 declare  @i int , @t bigint , @ct nvarchar(max)

 --get encrypted data
 SET @OrigSpText1= (SELECT top 1 ctext FROM syscomments  WHERE id = object_id(@objectName) order by colid)
 SET @OrigSpText2='ALTER PROCEDURE '+ @objectName +' WITH ENCRYPTION AS '+REPLICATE('-', 3938)
  EXECUTE (@OrigSpText2)
 print @OrigSpText1

 SET @OrigSpText3=(SELECT top 1 ctext FROM syscomments  WHERE id = object_id(@objectName) order by colid)
 SET @OrigSpText2='CREATE PROCEDURE '+ @objectName +' WITH ENCRYPTION AS '+REPLICATE('-', 4000-62)

--start counter
 SET @i=1
 --fill temporary variable
 SET @resultsp = replicate(N'A', (datalength(@OrigSpText1) / 2))
 
--loop
 WHILE @i<=datalength(@OrigSpText1)/2
 BEGIN
  --reverse encryption (XOR original+bogus+bogus encrypted)
 SET @resultsp = stuff(@resultsp, @i, 1, NCHAR(UNICODE(substring(@OrigSpText1, @i, 1)) ^
                                 (UNICODE(substring(@OrigSpText2, @i, 1)) ^
                                 UNICODE(substring(@OrigSpText3, @i, 1)))))
 print @resultsp
  SET @i=@i+1
 END
 --drop original SP
 --EXECUTE ('drop PROCEDURE '+ @objectName)
 --remove encryption
 --preserve case
 SET @resultsp=REPLACE((@resultsp),'WITH ENCRYPTION', '')
 SET @resultsp=REPLACE((@resultsp),'With Encryption', '')
 SET @resultsp=REPLACE((@resultsp),'with encryption', '')
 IF CHARINDEX('WITH ENCRYPTION',UPPER(@resultsp) )>0 
   SET @resultsp=REPLACE(UPPER(@resultsp),'WITH ENCRYPTION', '')
 --replace Stored procedure without enryption
 set @ct = (SELECT ctext FROM syscomments WHERE id = object_id(@objectName))
 print @ct
 execute( @resultsp)
 GO