存储过程、存储函数的加密：WITH ENCRYPTION
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
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--*/
/*--调用示例
--解密指定存储过程
exec sp_decrypt 'AppSP_test'
--对所有的存储过程解密
declare tb cursor for
select name from sysobjects where xtype='P' and status>0 and name<>'sp_d