not able to execute stored procedures with dbo

Question

not able to execute stored procedures with dbo

mvssrikanth1

SSC-Addicted

Points: 463
More actions
May 20, 2011 at 1:03 am

#239976

Hi!
I am not able to execute the stored procedures with dbo but able to execute them without dbo.For eg.
Example:
EXEC [dbo].[sp_Test] -> not able to execute them
EXEC [sp_Test] -> For some reason, we can execute.
Please help in this regard.
thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Satheesh E.P. SSCrazy Points: 2509 More actions · Answer 1

Verify the owner of the SP. It might have created by a username other than dbo, probably by the username you used while creating this SP. (i.e) [UserName].[SP_Test] rather than dbo.sp_Test.

---------------------------------------------------
Thanks,
Satheesh.

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

What error do you get when you try to execute dbo.sp_test?

I think you belong to different schema and sp_test exists in it.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

Must be that the procedure was created with a different schema as owner.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lowell SSC Guru Points: 323518 More actions · Answer 4

if you sp_help YourProc name, what owner/schema is it? you get results like this?

sp_help sp_Test

Name Owner Type Created_datetime

sp_Test dbo stored procedure 2011-01-19 11:02:11.727

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!