sp_spaceused Stored Procedure

[stevegreen]

Hi
Has anyone evry used the sp_spaceused stored procedure before with VB. I'm not sure how to add a parameter to it. I'm using ADODB and need to get details on a table called Customers. I've got the following so far.

cStored.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc
cStored.Parameters.Append(cStored.CreateParameter("")
cStored.CommandText = "sp_spaceused"
cStored.ActiveConnection = cConnection

Its the create parameter bit I'm lost at.

Cheers

Steve

[stevegreen]

If I run the procedure from SQL Query Analsier all I need to enter is

exec sp_spaceused Customers

So I'm looking for a similar way of doing this in VB using adodb.

Hope this helps

Steve