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

microsoft.public.sqlserver.tools

22 Jan 2005 8:57 PM

Lars

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

24 Jan 2005 8:27 AM

Vikas Kumar

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