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 |
|
JacobPressures
Posting Yak Master
112 Posts |
 Posted - 2005-08-12 : 18:39:27
|
| "Once encrypted, the definition of the trigger cannot be decrypted and cannot be viewed by anyone, including the owner of the trigger or the system administrator."Does this include the script from which the trigger was created? the trigger.sql file? |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-12 : 19:20:47
|
| No, if the trigger was created from a script file, the script file is still in plain text format. Only the text of the trigger within SQL Server is encrypted.---------------------------EmeraldCityDomains.com |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-08-12 : 19:22:28
|
 No, it's the trigger definition in syscomments that is encrypted.Keep the original (readable) files/definitions secure somewhere, in case You need to see the code.rockmoose |
|
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-08-15 : 09:46:31
|
| thanks guys!So i guess you can see the "source" code of all the functions, triggers, stored procedures, etc stored in SQL Server? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-15 : 10:39:08
|
Lets assume you have a file somewhere called "trigger.sql"And that your script file uses the syntax "WITH ENCRYPTION".You load the script file into, say, Query Analyser and execute it on a database on your SQL Server.That Object, in the database on your SQL Server, is encypted and the souce cannot be viewed. (To test that try sp_helptext 'MyTrigger' after creating the object - try again without using the WITH ENCRYPTION statement)The original file, "trigger.sql", is NOT encrypted by this process, and will still be readable.Note, however, that the encryption used by SQL Server is very basic, and easily cracked, so you need to consider that when "relying" on WITH ENCRYPTION  Kristen |
|
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-08-15 : 13:03:10
|
| Great info! Thanks! |
|
|
|
|
|
|
|
|
Encrypted Trigger