I am trying to create a utility to monitor and record database changes. One of the stored procedures that I would like to use is the sp_spaceused.

Looking at this stored procedure, it returns a value of 1 or 0, but when run in the Query Analyzer, it also returns a recordset detailing the space used details of the database. In C#, how do I review and recordset data? I have tried several iterations of reading this information but it appears as though I can't read it in the application. If the Store Procedure displays a recordset of data in Query analyzer, is it also reasonable to assume that I should be able to read it when called via the application?

Any help is greatly appreciated.