Cannot find Stored Procedure

D

DayWalker

Well-known member
Joined
Jul 9, 2003
Messages
51
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:
 
Have you run a SQL trace to see how/if the user is connecting? Is the connection string using the users credentials? If so, make sure that user has access to the DB AND has the EXEC rights.

-Nerseus
 
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 Ndbo --this was set to myname
GO

CREATE PROC ****
 
Back
Top