如何查看加密了的过程内容
IF EXISTS (select * from syscomments where (status = 0 or status is null) and id = object_id('dbo.Spt_zx'))BEGIN
DROP PROCEDURE dbo.Spt_zx
IF OBJECT_ID('dbo.Spt_zx') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dbo.Spt_zx >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dbo.Spt_zx >>>'
END
go
-- PROCEDURE 'dbo.Spt_zx' is encrypted
go
IF OBJECT_ID('dbo.Spt_zx') IS NOT NULL
PRINT '<<< CREATED PROCEDURE dbo.Spt_zx >>>'
ELSE
PRINT '<<< FAILED CREATING PROCEDURE dbo.Spt_zx >>>'
go
EXEC sp_procxmode 'dbo.Spt_zx','unchained'
go
GRANT EXECUTE ON dbo.Spt_zx TO public
go
REVOKE EXECUTE ON dbo.Spt_zx FROM syother
go 呵呵,不容易咧! 回复 1# yzrhmily
楼主贴的代码是什么意思? 回复 3# andkylee
上面是一个过程,但是中间的代码被加密,用下面这句话来显示
-- PROCEDURE 'dbo.Spt_zx' is encrypted
我现在想问的是,有没有什么办法看到这些加密了的代码 回复 4# yzrhmily
你直接问不就得了, 这个问题很容易理解,但是难度倒是有。
在创建加密存储过程的时候,存储过程的内容会保存的log中, 如果能看懂log就可以了。
页:
[1]