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.
| Abbrv. | Superset/Dialect Name | Vendor |
|---|---|---|
| PL/SQL | Procedural Language/Structured Query Language | Oracle |
| T-SQL | Transact[ional] Structured Query Language | Microsoft |
|
|---|