title: "sp_spaceused" returns only one result set in perl
body: <p>When I used the "sp_spaceused" in SQL server editor it returns two result set.</p>
  
  <p>i.e.</p>
  
  <pre><code>database_name, database_size, unallocated space
  
  'Test', '25000.00 MB', '4510.67 MB' 
  </code></pre>
  
  <p>and </p>
  
  <pre><code>reserved, data, index_size, unused
  
  '10741072 KB', '10007904 KB', '661728 KB', '71440 KB'
  </code></pre>
  
  <p>But in perl script it returns only one.</p>
  
  <p>EX:</p>
  
  <pre><code>my $query = "sp_spaceused";
  
  my $sth = $dbh-&gt;prepare($query) ;
  $sth-&gt;execute();
  
  while ( my @row = $sth-&gt;fetchrow_array() )
  
  {
  
      print " @row \n ";
  
  }
  </code></pre>
  
  <p>Output: </p>
  
  <pre><code>database_name, database_size, unallocated space
  
  'Test', '25000.00 MB', '4510.67 MB' 
  </code></pre>
  
  <p>Is there any way to fetch and store both the result set !</p>