Post reply

Maximum output length in text for a query result.

  • November 29, 2013 at 1:59 am

    #283037

    In SSMS.

    Can the maximum output length be set from within a query ?

    (Not by going trough tools/options/query result/sqlserver/result to text).

    Ben

  • November 29, 2013 at 2:18 am

    #1669775

    No. It's a property of the client tool only, not something that SQL Server sets within itself

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 29, 2013 at 2:47 am

    #1669781

    GilaMonster (11/29/2013)

    No. It's a property of the client tool only, not something that SQL Server sets within itself

    Thanks Gail,

    I thought so, but it's nice to know for sure.

    Are there suggestions how to handle this aspect ?

    Yesterday I delivered a dynamic script, producing strings longer than the default setting.Between a lot of instructions with the script there was also the instruction to ther user :tools/QueryResult\SQLServer\Result to text\Length:, but this was 'forgotten'. It took some communication and some time to 'pinpoint' this problem, after which is was easely solved.

    I do run into this problem fairly often, but am used to this so notice this almost immediatly. This is not true for all persons who use this type of scripts.

    Ben

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

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