USE [master]
GO

/****** Object:  UserDefinedFunction [dbo].[hack_encryption_password]    Script Date: 12/18/2007 18:36:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[hack_encryption_data]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[hack_encryption_data]
GO
use [Master]
go

CREATE function [dbo].[hack_encryption_data] (@encryptedtext varbinary(max))
returns varchar(8000)
with execute as caller
as
begin
declare @data varchar(8000)
declare @password varchar(6)
declare @i int
declare @j int
declare @k int
declare @l int
declare @m int
declare @n int


set @i=-1
set @j=-1
set @k=-1
set @l=-1
set @m=-1
set @n=-1
set @password =''

while @i<255
begin
	while @j<255
	begin
		while @k<255
		begin
			while @l<255
			begin
				while @m<255
				begin
					while @n<=255
					begin
					set @password=isnull(char(@i),'') + isnull(char(@j),'')+isnull(char(@k),'')+ isnull(char(@l),'')+isnull(char(@m),'') + isnull(char(@n),'')
					if convert(varchar(100),DecryptByPassPhrase(ltrim(rtrim(@password)),@encryptedtext)) is not null
					begin
					--print 'This is the Encrypted text:' +@password
					set @i=256;set @j=256;set @k=256;set @l=256;set @m=256;set @n=256;
					set @data = convert(varchar(100),DecryptByPassPhrase(ltrim(rtrim(@password)),@encryptedtext)) 
					end
					--print 'A'+ltrim(rtrim(@password))+'B'
					--print convert(varchar(100),DecryptByPassPhrase(ltrim(rtrim(@password)),@encryptedtext)) 
					set @n=@n+1
					end
				set @n=0
				set @m=@m+1
				end
			set @m=0
			set @l=@l+1
			end
		set @l=0
		set @k=@k+1
		end
	set @k=0
	set @j=@j+1
	end
set @j=0
set @i=@i+1
end

return @data
END