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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!