Sql server stored proc fails

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ratan
Forum Commoner
Posts: 28
Joined: Thu Jul 13, 2006 4:22 pm

Sql server stored proc fails

Post by ratan »

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..
Post Reply