Sql Server Could Not find Stored Procedure after uploading my project on server...Why..?

Question

0.00/5 (No votes)

See more:

Hi..friends...

In my web application i am using sql server-2008 R2. My web application runs fine at local host but when i uploaded my project on server then it's give an error like...."Server couldn't find store procedure 'procedure_name'...."

I have created backup of my DB successfully with the same name which i used at localhost as well as a different DB name...i have tried with both of DB one by one but still error is not resolved....Please help me..

My connection strings in webConfig, DAL file and Class file are same...

Thanks

Sunil sharma

Posted 29-Dec-13 21:18pm

sonusharma65

Add a Solution

Comments

Member 10434230 30-Dec-13 3:32am

can you please post, connection string
and DB Server name and DB name, so that it can be validated

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-12-29T21:45:00

Check the production server directly using SSMS and look at the database to check that you transferred the stored procedures - if you didn't explicitly select them when you did the backup to transfer to the production server, then you will not have copied them to the server.

You can also check using code from here: Using C# to Enumerate Through Stored Procedures in MS SQL Server 2000[^] - it's old, but should still work.

Christian Graus · Answer 2 · 2013-12-29T23:21:00

Solution 2

right click on your DB on localhost. Go to tasks/generate scripts. Here you can create scripts to create all of your procs, so you can install them on your server.

Posted 29-Dec-13 23:21pm

Christian Graus

Ankit Roy · Answer 3 · 2014-01-02T19:29:00

Hi,

I will suggest that Delete your Database from Server and create an empty Database, after that go to localhost Right Click on DB Name -> Task -> Generate Script and here is the catch.

When you see the window Choose Objects You get two options
1. Script entire Database and database objects.
2. Select Specific database objects

Choose 2nd Option and Check all you tables and Stored Procedures and Create the script and then run it to Sever Database. It will Work Fine.

This is because When you choose First option the script is created with MDF and LDF file with your local systems path, which may not exists in your Server and the scripts fails.

Hope above helps.

Sql Server Could Not find Stored Procedure after uploading my project on server...Why..?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0