Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-11-24 : 03:38:08
|
| hello everybody,could anybody let me know wether is there a way for decrypting a view in sql server 2008.thanx in advance |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-11-24 : 03:51:16
|
| 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. |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 04:27:44
|
| 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. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-11-24 : 06:14:10
|
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  |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 07:45:28
|
| thanx kristen for your valuable answer |
|
|
|
|
|
|
decrypting a view