May 23, 2007 at 1:39 am
Hello, I have created a function like:
CREATE
FUNCTION dbo.ufn_xxxxxxxx
(
@xxxxxxxxx VARCHAR(100))
RETURNS
VARCHAR(100)
WITH
ENCRYPTION
AS……..
When I connect as DAC or SA and want to see script of it I execute code like:
select
so.name, sc.* from sys.syscomments sc
inner
join sys.sysobjects so
on
sc.id = so.id
where
encrypted = 1
Answer in ctext and text columns is NULL.
name
id number colid status ctext texttype language encrypted compressed text
ufn_xxxxxxxxx 322816212 0 1 1 NULL 6 0 1 0 NULL
ufn_xxxxxxxx 338816269 0 1 1 NULL 6 0 1 0 NULL
Question is:
Is there possibility to see text of encrypted function/stored procedure?
Best Regards
May 23, 2007 at 7:03 am
Not from within SQL at least. Might be some third party apps that can somehow do it, but none that I know of.
May 23, 2007 at 8:48 am
The code was obfuscated in previous versions and there were some procs to decrypt the code. I'm not sure if this applies in SQL Server 2005.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply