April 22, 2008 at 3:16 am
Hi,
does anyone know how to encrypt stored procs in Sql2000 and later?
We used to use an sql7 server to encrypt. By adding WITH ENCRYPTION in the stored proc.
But this doesnt seem to work in Sql2000 and later?
Was this encryption abolished?
Any response gratefully appreciated.
April 22, 2008 at 3:25 am
It still works in SQL 2000 and later. What error are you getting?
This works fine in SQL 2005
CREATE PROCEDURE Test
WITH ENCRYPTION
AS
SELECT 1
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2008 at 3:53 am
My mistake you're right actually.
We have some in house software which takes all our stored procs, adds WITH ENCRYPTION to them, adds them to a db, then scripts the db objects to a file.
This file we then send to our clients.
The db we were using was on an Sql7 server. So I assumed that WITH ENCRYPTION doesnt worker on a later version.
Our problem is actually that in Sql7 you can script encrypted stored procs to a file. They appear as one mass long hexidecimal. It doesnt look like you can script them to a file in Sql2000 or above.
Unless anyone knows any different?
April 22, 2008 at 4:18 am
Not that I know of. In SQL 2000, encryption means that the object cannot be scripted of modified without either having the original code, or decrypting the proc.
Especially in SQL 2000, the encryption was trivial to crack.
see here - http://www.sqlservercentral.com/Forums/Topic396563-119-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply