January 9, 2006 at 5:15 am
Usualy i use SQL Profiler to debug my programs. Now, with SP4 when i create a trigger or a procedure, or... in the profiler i get the text
"-- 'encryption' was found in the text of this event.
-- The text has been replaced with this comment for security reasons."
How can i change sql server to let me see my code again?
Best regards,
Mário Seabra
January 9, 2006 at 5:46 am
🙂
You can't!
Profiler will suppress all text of events such as "sp_addlogin..." to prevent exposure of passwords etc.
It will also suppress the text if you are using "WITH ENCRYPTION" in your Stored proc or View definition...
What is the point of having "WITH ENCRYPTION" is the text can then be seen in profiler?
If you need to decrypt stored procs etc, go here.. http://www.geocities.com/d0mn4r/dSQLSRVD.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply