Cannot find Stored Procedure

[DayWalker]

I have deployed a application for testing. It uses a stored procedure to Insert data into a db. It works fine on the pc i am using but when i install it on another machine it says it cannot find the stored procedure. I have given the user of the machine "EXC" rights in the db but it still does not find it. Any help will be appreciated:confused:

[Nerseus]

Have you run a SQL trace to see how/if the user is connecting? Is the connection string using the user's credentials? If so, make sure that user has access to the DB AND has the EXEC rights.

 

-Nerseus

[DayWalker]

Yip thxs the problem was i created the SP on my machine it set the SP owner as 'My Name'.Even though i had given the relevant permissions it still didnt work. When i changed it to dbo it worked on all the client machines. Thanks for the help.

 

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

 

setuser N'dbo' --this was set to myname

GO

 

CREATE PROC ****