Could not find stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Could not find stored procedure

Author

Topic

apeters
Starting Member

3 Posts

Posted - 2009-04-26 : 10:19:22

Hello,
I have a security qustion.

I've created a really simple sproc:

CREATE PROCEDURE [dbo].[MySproc] 

AS
BEGIN
	SELECT CURRENT_TIMESTAMP
END

I can successfully execute the sproc using:

EXEC dbo.mysproc

Why, then, does SQL Server 2008 display the follwing tooltip when I hover over the above statement: "Could not find Stored Procedure dbo.mySproc"?

In this example it's just a curious irritation, but I'm seeing a similar problem when I try to access the Stored Procedure from ASP.NET

apeters
Starting Member

3 Posts

Posted - 2009-04-26 : 11:28:17

I seem to have fixed the problem when encountered in Management Studio by adding my database user account to the 'db_owner' database role.
The problem is still present when trying to access the sproc from within Visual Studio/ASP.NET, but this might be because Visual Studio is version 2005 whereas I'm trying to access SQL Server 2008.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-26 : 11:44:31

Are you using a case sensitive collation on server?

Try

EXEC dbo.MySproc

E 12°55'05.63"
N 56°04'39.26"

apeters
Starting Member

3 Posts

Posted - 2009-04-26 : 13:31:02

It turns out that this is a known problem with Visual Studio 2005 and SQL Server 2008 - see http://support.microsoft.com/?kbid=954961.
Microsoft have a patch for Visual Studio 2005 Professional Edition, but not for Standard Edition. So the only options are to either upgrade to Visual Studio 2008 or to downgrade to SQL Server 2005.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources