【fosoyo】SQL Server儲存過程/函式加/解密

儲存過程、儲存函式的加密：WITH ENCRYPTION


<!--[if !supportLineBreakNewLine]--&gt
<!--[endif]--&gt

CREATE procedure dbo.sp_XML_main

@table_name nvarchar(260)='',

@dirname nvarchar(20)=''

WITH ENCRYPTION

as

begin

....................

end

go



儲存過程、儲存函式的解密


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

/*--破解函式,過程,觸發器,檢視.僅限於SQLSERVER2000

--作者:J9988-- All rights reserved*/

/*--呼叫示例

--解密指定儲存過程

exec sp_decrypt 'AppSP_test'

--對所有的儲存過程解密

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

--破解位元組不受限制，適用於SQLSERVER2000儲存過程，函式，檢視，觸發器

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/12639172/viewspace-329650/，如需轉載，請註明出處，否則將追究法律責任。