+ -
当前位置:首页 → 问答吧 → 如何查看加密了的过程内容

如何查看加密了的过程内容

时间:2011-01-05

来源:互联网

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

作者: yzrhmily   发布时间: 2011-01-05

呵呵,不容易咧!

作者: wfcjz   发布时间: 2011-01-06