Calling a Stored Procedure?

[netfrugal]

I have a SQL Server Database with a stored procedure called: sp_allManagers

This is my first time working with calling stored procedures and I can't seem to understand the online tutorials that are currently available.

This stored procedure is just a SELECT * from the Managers table, so it's nothing major.

What is a simple call to the stored procedure so that I can show all rows?

Below is what, I think, is used to initialize a stored procedure, but I am not sure what is missing, or wrong.

<?php
$s = @mssql_connect("localhost", "root", "password");
$d = @mssql_select_db("SPLASHDB", $s);
$query = mssql_init("sp_allManagers", $s);
$result = mssql_execute($query);
?>

[tomhath]

What you have looks like it should work. Does the account you're logging onto SQLServer with have EXECUTE permissions for that procedure?

Try running this in a query tool:

GRANT EXECUTE ON sp_allManagers TO public
GO

[kakki]

and then use "call sp_allManagers;" on the shell