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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:28:56
|
| EhsanF writes "Dears, I have an application , which encrypt its Objects' scriptsto use them for building its database setup . this applicationencrypt all its objects'(by "WITH ENCRYPTION").but there is a problem: I had no problem with SQL 7.0, cause it encrypted codeworked on SQL 2000, too. But, when I moved my DB server into SQL2000, and use encryption , the result strings differ from the previous, and also, it can not be run under SQL 2000!!!!!Please tell me about the solution for running the encrypted codes On SQL 2000 (Like "Exec(decrypt(0x4f635...))"). Thanx, Ehsan Ferdowsi, TechnoStructure team manager System Group Co." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-01 : 23:38:31
|
| HiYes, basically encryption differs on a server by server basis, I.E. the encryption seed is different (that is my understanding anyway).Keep all your objects as scripts and execute them from there. Also use source control for your scripts.Damian |
 |
|
|
|
|
|
SQL Server 2000 encryption algorithm!!!