Error 80040e14 Could Not
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn could not find stored procedure in sql server 2008 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags could not find stored procedure c# Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,
Could Not Find Stored Procedure But It Exists
helping each other. Join them; it only takes a minute: Sign up “could not find stored procedure” up vote 7 down vote favorite I am maintaining a classic ASP website that has a SQL Server 2005 backend. For
Stored Procedure Not Found
a small piece of new functionality I wrote a stored procedure to do an insert. This is the only user stored procedure in the database. When I attempt to call the stored procedure from code I get the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' Could not find stored procedure 'InsertGroup'. /newGroup.asp, line 84 The DB uses SQL Server authentication. When I connect to the DB server in Visual Studio using the same sqlcmd could not find stored procedure user/pw as in the connection string the stored procedure is not visible but all tables are. The user has datareader and datawriter roles and explicit execute permission on the stored procedure. What am I missing? UPDATE: My apologies, the server admin misinformed me that it was a 2000 server when it is actually a 2005 server (running on Windows Server 2003 x64). sql-server stored-procedures share|improve this question edited Oct 9 '13 at 3:00 Drew 19.6k53849 asked May 11 '09 at 12:30 Chloraphil 1,38872740 add a comment| 5 Answers 5 active oldest votes up vote 27 down vote accepted Walk of shame: The connection string was pointing at the live database. The error message was completely accurate - the stored procedure was only present in the dev DB. Thanks to all who provided excellent answers, and my apologies for wasting your time. share|improve this answer answered May 11 '09 at 15:21 Chloraphil 1,38872740 2 You should probably mark this as the answer, to help others who may not read to the bottom. It's great that you posted this. I'm sure others have done and will do similar things, and an example of an oversight like this will probably help somebody else find his error. –GilM May 12 '09 at 5:40 6 @Chloraphil: It's always funny to see that developers tend to think that the most probab
360 games PC games
Could Not Find Stored Procedure Dbo
Windows games Windows phone games Entertainment All Entertainment could not find stored procedure vb net Movies & TV Music Business & Education Business Students & educators system.data.sqlclient.sqlexception: could not find stored procedure Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/847879/could-not-find-stored-procedure Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/316371 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might http://dba.stackexchange.com/questions/23983/could-not-find-stored-procedure-even-though-the-stored-procedure-have-been-cre have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish could not to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top "Could not find stored procedure' even though the stored procedure have been could not find created in MS SQL Server Management Studio up vote 8 down vote favorite 2 I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, null) expire_time (time(7), null) which I used the Microsoft SQL Server 2008 Management Studio. I created a stored procedure testtable_pricesmaller as follows use testbase go create procedure testtable_pricesmaller @pricelimit money as select * from testtable where price = @pricelimit; go and are able to view the Stored Procedures on the Object Explorer of the Microsoft SQL Server Management Studio. (It is listed in the following tree structure of the Object Explorer) Databases + testbase + Tables + dbo.testtable + Programmability + Stored Procedures + dbo.testtable_pricesmaller I find it very strange when I receive the following error: Could not find the stored procedure 'dbo.testtable_pricesmaller'. when I execute the following SQL statement: execute dbo.testtable_pricesmaller 50 What could it be missing? sql-server-2008 stored-procedures ssms share|improve this qu