Home Forums SQL Server 7,2000 General unable to see entire SQL Statement in profiler RE: unable to see entire SQL Statement in profiler

  • May 7, 2014 at 5:14 am

    #1711427

    HanShi (5/7/2014)

    yuvipoy (5/7/2014)

    .....both did not gave me the entire Textdata. how can i get it, it limiting by 256 bytes

    This could be the default limit in SSMS. Look in SSMS for the "properties" option in the "tools" menu. Expand the tree for "Query results" and check the settings in the "results to grid" and "results to text".

    I think you entered here wrongly.

    It is SQL server 200 it does not have SSMS.

    and thats too setting value in SSMS i dont think it will resolve.. in profiler 😉