help: running a stored proc on mssql 2000
| From: | david dot tansley at btinternet dot com | Date: | Tue, 13 Nov 2001 17:21:49 +0000 |
| Subject: | help: running a stored proc on mssql 2000 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14291@lists.php.net to get a copy of this message | ||
Hi,
I am trying to run the SP 'sp_password' on mssql, using this command:
$sql="exec sp_password 'NULL','master','davet')";
Is that the correct way ???
But when I run my script I get a error with this statement.. saying "Incorrect syntax near
')' "
$sql_result=mssql_query($sql,$connection);
Can't figure the problem. Any idea's. Also,
how do I check the returned status ?
(linux, using freetds connecting to ms-sql.)
Thanks
DT