in reply to MS SQL Stored Procedure Syntax
No, what's he's trying to do here is EXEC[UTE] a stored procedure in MS SQL from the sound of it. The CALL syntax is Oracle's, you're getting your SQL dialects mixed up.
$sth = $dbh->prepare('EXEC sp_spaceused');
MSDN has an online transact SQL reference which I suggest you bookmark. Dealing with multiple dialects of the same language can get confusing no matter your experience level.
||Procedural Language/Structured Query Language
||Transact[ional] Structured Query Language