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