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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2001-03-28 : 17:09:29
|
| Is there a way to decrypt a view, in SQL SERVER 7 (not 6.5)?I found code for SQL 6.5 today and havent had time to see if it may work with SQL 7. Example:Create view V_Name with Ecryption as select * from table1 where name is 'something'will be displayed as:exec(decrypt(0x4CAFD1771AB283A69C1A88839C43BCDED0514551A4ABB5668239B))DanielSQL Server DBA |
|
|
|
|
|
Decrypting a view with the WITH ENCRIPTION option