Could not find stored procedure
-
Hi, I have a problem with my database, where is says it can't find a specific stored procedure, however when I look at the list of stored procedures (even after refreshing the view several times) it is there. I've tried calling it from sql query analyser and it says the same thing.
I have restored the database from another server, and also have been using dts to import data....could either of these have an effect on it?
many thanks for your help
Kate
-
Are you calling the proc with owner.procname?
Is it possible that this proc is calling a proc that is missing?
-
could it be the proc exists in the MASTER database, but does not start with "sp_"
if a proc exists in master, but doesn't have the proper naming convention, then you must explicitly call it by dbname.owner.procname, ie
use pubs
exec master.dbo.pr_getTBResults @parma1,@param2
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Do you think we're gonna get an answer from her??
-
Sorry guys - I was off work yesterday so didn't get a chance to reply to you!! Thanks for the posts. The stored proc that can't be found isn't calling any other sp's, it's also not in the master db - it's a sp that comes with an ecommerce product that we use, so it's in the db for that particular ecommerce site. I've got about 4 other databases for this ecommerce product (for different sites) on my sql server and none of these have this problem. I've backed up the same db on our development server (which works fine) and restored it on my local computer, so I would have thought that the two would be identical. The only difference is that a dts package has been run on my local sql server, and hasn't been run on the development server.
any more suggestions? any help at all would be very gratefully received
Kate
-
Stupid questions warning : Are you calling the sp from the right db?
Is the sp executing a statement that could fire a trigger, that would try to execute an sp that doesn't exists?
- yes I am
I think I've fixed it - I copied the contents of the same stored procedures from another db into the stored procedures that can't be found, and it seems to have fixed it. I have no idea why, maybe the dts package broke the sp's in some way? Doesn't seem to have done it since though. Thanks for taking the tiem to reply - you put me on the right track!!
Kate
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply