March 25, 2009 at 11:09 pm
SET STATISTICS IO ON will give the IO information in Message panel in Management studio.
Instead I just need these information in result's panel.
Please provide any workaround for this ...??:-)
March 26, 2009 at 5:31 am
One option is to change the output of the results from a grid to text. Then the columns and the I/O all come out in a single window.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 26, 2009 at 5:39 am
It won't happen Fritchey, because by default Mangement Studio return IO information in under Message panel.
March 26, 2009 at 5:39 am
It won't happen Fritchey, because by default Mangement Studio return IO information in under Message panel.
March 26, 2009 at 5:39 am
It won't happen Fritchey, because by default Mangement Studio return IO information in under Message panel.
March 26, 2009 at 5:44 am
Actually, it works fine. I just did it. You get the query results and the messages in a single window when you change the output from the default grid to text.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply