does the view return encrypted data? we're unlikely to help. breaking encryption is a no-go subject here. talk to the code developer. or do you want to see the SQL behind the view? script the object in SSMS.
when a view is created with encryption it gets dissappeared from syscomments.so now what my question is how to see that view in syscomments. is it possible to decrypt it again or is there any other way.
If the view is created WITH ENCRYPTION then it is encrypted.
People here are not able to help you reverse engineer or break Microsoft's encryption - the MODs will just delete the answers if they do.
We keep all our code (Procedures, Triggers, Views) in external files in order to prevent accidents where something gets encrypted to ensure it is not our only source of that code
decrypting a view
Posted - 11/24/2010 : 03:38:08
