error with stored procedure

[jackvull]

Am trying to use this to run a stored procedure but it seems to error with:
Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in C:\Inetpub\wwwroot\structure.php on line 189
Changed database context to 'CCApp_DEV'.

All permissions seem okay on the server. ANy ideas?

$stmt = mssql_init("web_GetStructure",$dbhandle) or die(mssql_get_last_message());
$stmtDivLevels = mssql_init("web_GetDivLevels",$dbhandle) or die(mssql_get_last_message());
$result = mssql_execute($stmt) or die(mssql_get_last_message());
$resultDivLevels = mssql_execute($stmtDivLevels) or die(mssql_get_last_message());

[coopster]

Which line is 189? Did you try to run your stored procedure from a command line to see if it fails there?