Monday, March 19, 2012

agrument tuncated in execution plan .. how do I get the whole argu

Hello,
I tried analysing a query using the execution plan provided by the query
analyser. But when I move the mouse pointer onto some queryitems it seems
that the argument used by the query part is tuncated. Even using SET
SHOWPLAN_TEXT or SET SHOWPLAN_ALL doesn't help to view the whole argument.
How can I do that ?
Thanks
Lars
In QA by default a column can show text up to 255 characters. I think you
need to increase the this to a higher number.
Go to tools->Options->Results->"Maximum Characters Per row" change the
value to a higher no.
Thanks
Vikas

No comments:

Post a Comment