Menu
I am running SQL Server Profiler (SQL Server 2008). Is there a way to see the name of the stored procedure that is executing? I am profiling SP:Started and SP:Completed. The TextData column hasn't been helpful as my stored procedures are encrypted so TextData displays "-- Encrypted text".
476
Using SQL Server Management Studio Expand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure and then click View Dependencies. View the list of objects that depend on the procedure.
Have you tried adding column ObjectName? This should show stored procedure names. I haven't worked with encrypted procedures, but I'd be very surprised if the names are also encrypted ('cause how could you call the proc if you didn't know the name?)
191
It is possible that the stored procedure is encrypted, try searching for text containing 'WITH ENCRYPTION' in your db.
Additionally, perhaps there is a point in which there's too much data being passed into the sp where SSP will not display the text.
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
