Post reply

Rows in text-based plan getting cut off

  • April 22, 2009 at 5:27 am

    #133398

    Hi all....I'm looking at a number of sql 2000 text-based execution plans and for some reason the longer rows are getting cut off. Is this a configuration setting that I need to change, or am I going to be suffering with partial statements? An example is

    | | | |--Clustered Index Scan(OBJECT: ([Database].[dbo].[InstallationRepairTickets].[PK_InstallationRepairTickets] AS [InstallationRepairTickets]), WHERE: (like([InstallationRepairTickets].[EmployeeName, 'b%',

    That's all I'm getting. Looking at my SQL statement, there are at least 6 more conditions in the where statement (Completion dates etc.). I copied and pasted the Execution plan into Notepad; would this have something to do with it?

    Appreciate any ideas.

    Thanks in advance......

    Chris

  • April 22, 2009 at 5:39 am

    #982081

    can you go to tools/options/results and set the maximum characters per column to a higher amount?

  • April 22, 2009 at 5:41 am

    #982086

    :Whistling:

    Yup, that did the trick. Think that would have been the first place I checked *shrugs*

    Can I blame it on the lack of coffee this morning? LOL

    Thanks a lot,

    Chris

  • April 22, 2009 at 7:20 am

    #982173

    ha, i blame everything on too much coffee. not lack of 😛

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply