hi frnds.
I have been working on db for a long time i encoutered a small problem recently while i was learning the concept of encryption.
The Problem is using the "WITH ENCRYPTION" property i am able encrypted a stored procedure, a view or a function but i am unable to decrypt it to the earlier state or i am unable to get the source code of the stored procedure but i am able to execute it fine
Solution will be highly appreciable
Loading
Syed ShakeerPosted Mar 15, 2010, 3:29 PM
Encrypting StoredProcedure:-
Create Procedure spname with encryption
As
Print 'DotNetHeaven'
Go
Decrypting StoredProcedure:-
exec dbo.Decryptsp2k 'spname'
go