SQL query should give a result of 100,000 rows but the output is truncated and only displays 64,000 rows. How is this corrected to show 100,000 rows.

I’m glad to be part of the Microsoft SQL Server forums. I look forward to learning from the community, sharing knowledge, and getting help with SQL Server-related queries. I’m excited to engage in discussions and contribute wherever possible!

Hi Guys,

I am just curious about ifilter capability for SQL 2025. Usually after installing SQL, attaching the databases, i install the ifilters as i am storing documents in Filestream and needs it to be indexed. Previous version of SQL works when i run the below query but not for SQL 2025. Anyone knows how to make it work or has any changes been done in SQL 2025 regard...

Thanks for the reply. Bummer about good ol’ Microsoft changing stuff
We do have ClearTraceXE working with SSMS 19 SMOs which I think are v 15.0.0.0 so we’ll have to decide if it is worth keeping SSMS 19 on our machines in order to keep using ClearTraceXE.

Thanks again for a handy product and the response to my support question.

I really don’t have a good way to support this app anymore.

The last version of SMO that supported reading trace files is 13.0. If you can get that installed and update the XML file to match you may have a chance. But once MS took that functionality out of SMO, there really isn’t much I can do.