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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-06-27 : 17:47:29
|
| Hi,Is there any way to create definition scripts for objects ( sp_, tables, etc) that are encrypted?Thx,Dobby |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-06-27 : 18:10:53
|
| Yes there are, but there are easy ways to decrypt them that can be found on teh net from what I understand. Maybe you can describe what you are trying to achive and we can tell you how to achive that using the security that is built into SQL Server.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
nemohm
Yak Posting Veteran
69 Posts |
Posted - 2003-06-28 : 12:22:52
|
| Basically I would like to create scripts for stored procedures, created by former administrator. The message on the screen is that they are encrypted and script cannot be generated.On Monday I'll take screen shots.Thx,Dobby |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-30 : 22:55:12
|
| For one thing, you should NOT be encrypting them if you do not have an unencrypted copy of the source code someplace safe. Two, for this and other reasons, you need to use source control like SourceSafe or CVS. All of your code goes in there in unencrypted form and can be recalled at any time, for any version you need. Finding a procedure that decrypts them doesn't help you to recover an earlier version or determine who made the changes...source control does these things too, and if you use it you won't need to decrypt anything either. |
|
|
|
|
|
|
Encrypted objects- how to create script ?