Sql server stored proc fails
Posted: Tue Oct 17, 2006 2:18 pm
Hello,
I am trying to run a bunch of queries using stored proc in sql server. The stored proc runs fine when I run it using
SQL Server Management Studio, but it fails when I run it from PHP. This is there error -
Warning: mssql_execute(): stored procedure execution failed in C:\Inetpub\wwwro
t\...\extractionScripts.php on line 59
I have tried using mssql_get_last_message() to find where the query fails.
All I get is this - Changed database context to 'FinancialReports'.
Pls. let me know if there is other way to find out where it fails.
Thanks..
I am trying to run a bunch of queries using stored proc in sql server. The stored proc runs fine when I run it using
SQL Server Management Studio, but it fails when I run it from PHP. This is there error -
Warning: mssql_execute(): stored procedure execution failed in C:\Inetpub\wwwro
t\...\extractionScripts.php on line 59
I have tried using mssql_get_last_message() to find where the query fails.
All I get is this - Changed database context to 'FinancialReports'.
Pls. let me know if there is other way to find out where it fails.
Thanks..