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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Not authorized to run stored procedures

Author  Topic 

xaphod
Starting Member

4 Posts

Posted - 2005-11-22 : 05:44:58
Hi,
Im a asp.net developer trying to run a stored procedure in SQL 2000 from Visual Studio 2005.
But the error mess says: Could not find stored procedure 'arTest'.
But I can execute the sp from Query Analyser.

What is happening?
Im not admin on the server, can it be Im not authorized to run stored procedures?

Regards /X

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-22 : 05:46:37
Make sure it is connected to the correct Database

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-11-22 : 06:37:53
Or possibly it is created for a specific user/owner - rather than "dbo"

Kristen
Go to Top of Page
   

- Advertisement -