August 11, 2005 at 5:45 pm
Hi folks,
We are running ReportNet against a SQL2K database with some fairly large and complex finance tables.
Reportnet is generating a large and slow query.
Im trying to use SQL Profiler to capture the query so I can check it out but it gets cut off at about 2K characters so I cant see the whole query.
Any ideas how I can see that query?
August 12, 2005 at 12:58 am
Hi,
I perform the same routine almost daily and it never gets cut off. Have you applied SP3a or SP4?
JP
August 12, 2005 at 7:20 am
We are running SP3a + hotfix.
Not SP4 yet.
The output is truncated at the same point when I use the profiler interactively and also if I save the trace to a file.
I will paste it here when I get back to work on Monday.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply