--对所有的存储过程解密

    declare tb cursor for

    select name from sysobjects where xtype=''''P'''' and status>0 and name<>''''sp_decrypt''''

    declare @name sysname

    open tb

    fetch next from tb into @name

    while @@fetch_status=0

    begin

        print ''''/*-------存储过程 [''''+@name+''''] -----------*/''''

        exec sp_decrypt @name

        fetch next from tb into @name

    end

    close tb

    deallocate tb

--*/

if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[SP_DECRYPT]'''') and OBJECTPROPERTY(id, N''''IsProcedure'''') = 1)

    drop procedure [dbo].[SP_DECRYPT]

GO

CREATE  PROCEDURE sp_decrypt(@objectName varchar(50))

AS

begin

set nocount on

--CSDN：j9988 copyright:2004.04.15

--V3.1

--

上一页  [1] [2] [3] [4] [5] [6] [7] [8]  下一页