SQl Server 2008 Plain Text procedures results iin Encrypted Text within Profiler

352395 pts.
Tags:
SQL
SQL Server 2008
SQL Server 2008 64-bit
SQL Trigger
I am attempting to trace some SQL activity on a SQL 2008, Standard SP1 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for triggers and procedures that are clearly plain text and are not encrypted. In this example, the object is a trigger. I do notice that the parent object is an encrypted stored procedure that is performing an insert, thereby firing the trigger. Has anyone else observed this?

Software/Hardware used:
Sql server 2008

Answer Wiki

Thanks. We'll let you know when a new response is added.

I can see that. The flag saying that the code was encrypted would be set for the transaction so everything would probably report that flag.

The easiest way around this would be to decrypt the procedure. There’s plenty of software on the net to do this.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQLChap
    Yes, I've seen this too, an unencrypted SP is reported as encrypted by profiler when it's called by some encrypted code. I'm sure the behaviour has changed from previous versions of SQL
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following