sql server, stored procedure question

[mcaizpp2]

Hi I made a report which referenced a stored procedure that stored procedure referenced a view.

Everything was fine until we sent the report + sp + view to our client.

They have a replica of our database + website + reports. When they ran the report they report crashed because it couldn't find the stored procedure. I took out the stored procedure and modifioed the report to run off the view only - and the report started working.

I would like to ask anyone if they have encountered that problem? I dont understand why it would work from a view but not a stored procedure!

 

[vidru]

Is it possible the permission wasn't granted properly for the procedure?

-dave