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 |
|
Gus Brower
Starting Member
7 Posts |
 Posted - 2006-10-16 : 05:09:32
|
| What solutions are available?Is there a way to read about from server's metadata?I posted similar topic on New To SQL Server forum. If here is more applicable place for this question - let moderators remove that topic.Gus |
|
|
Gus Brower
Starting Member
7 Posts |
Posted - 2006-10-16 : 12:33:10
|
| To elaborate a bit my question: I meant a case when an object is encrypted on the server (for example, a trigger) and I want to decrypt DDL of the one.Gus. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-16 : 12:57:57
|
| SQL Server's encryption is trivially simple to defeat (I haven't tried in SQL2005, but I think I remember reading that it hasn't changed)If that's what you want to do then please use Google to find out how - the Mods do not allow such discussion on this forum.Kristen |
|
|
|
Gus Brower
Starting Member
7 Posts |
Posted - 2006-10-16 : 13:43:03
|
quote:
Originally posted by Kristen
SQL Server's encryption is trivially simple to defeat (I haven't tried in SQL2005, but I think I remember reading that it hasn't changed)
If it was so trivial I wouldn't bother anyone. The mechanisms of encryption of SQL 2005 were improved and the approaches that worked with SQL 2000 wouldn't work here.This is not question for just Google.Gus. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-16 : 14:14:06
|
| Sorry, we don't publish methods to defeat SQL Server encryption. Google is your only avenue. |
|
|
|
Gus Brower
Starting Member
7 Posts |
Posted - 2006-10-16 : 14:32:00
|
| Anyway - thank you for the response. |
|
|
|
|
|
|
Decryption on sql2005