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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply