May 16, 2018 at 6:34 am
Hi,
I hipe I'm posting in the correct forum. Apologies if I'm not...I using MS Sql Server 2014 Profiler (v.12.0.2000.8) on a Window 10 Enterprise computer (64 bit system). I can successfully trace the database in the
upper pane of the profiler. It logs nicely. However, when I click on the row - it does not appear in the lower pane of the profiler (which it did before the upgrade)
and hence I cannot copy and paste the command out quickly.
I'm just wondering has anyone come accross this and is there any way to enable it? It's a very useful feature...
Any help much appreciated! Thanking you...
J.
May 16, 2018 at 8:28 am
jellybean - Wednesday, May 16, 2018 6:34 AMHi,I hipe I'm posting in the correct forum. Apologies if I'm not...I using MS Sql Server 2014 Profiler (v.12.0.2000.8) on a Window 10 Enterprise computer (64 bit system). I can successfully trace the database in the
upper pane of the profiler. It logs nicely. However, when I click on the row - it does not appear in the lower pane of the profiler (which it did before the upgrade)
and hence I cannot copy and paste the command out quickly.I'm just wondering has anyone come accross this and is there any way to enable it? It's a very useful feature...
Any help much appreciated! Thanking you...
J.
Does your trace include the "text" column?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2018 at 3:24 am
Hi Jeff, yes the "TextData" column is displaying. I have played with it's location relative to the other ie first, second last position but when I click on the rtow - the bottom panel still does not display the contents.
Any ideas? I'm at my wit's end....
J.
May 17, 2018 at 7:37 am
I feel like I need to change my handle to "yet another Jeff." 😀
jellybean, what options are you selecting in your Trace? I generally use a blank template and then select a few items:
Stored Procedures: SP StmtCompleted
TSQL: SQL StmtCompleted
I then will filter based on query duration and then the Database I'm watching. If I want to capture more statements in a shorter period of time, I'll remove the duration filter.
Typcially this gets me the most information in the shortest time possible. Should I need to add more options to capture parameters or something else, I will add those in. But this is where I typically start off.
I hope this helps in some way.
Regards, Irish
May 17, 2018 at 9:14 am
Hi Jeff (no, the other one)
Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get the command to display in the bottom panel. Has anyone else come across this? Surely - I can't be the only one.. 🙁
May 17, 2018 at 11:21 am
jellybean - Thursday, May 17, 2018 9:14 AMHi Jeff (no, the other one)
Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get the command to display in the bottom panel. Has anyone else come across this? Surely - I can't be the only one.. 🙁
Try adding the BinaryData column and see if that makes a difference. There was or is an issue related to that with some events and Profiler.
Sue
May 18, 2018 at 4:26 am
Hi Sue,
Thanks for the suggestion. I t was already added but I tried again and moved it around etc for blank and standard templates and tested a few variations bit still it's not appearing in the bottom pane.
Confused,
J.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply