unable to execute a newly created stored procedure

[Gino Talamini]

In an existing database I added a stored procedure name sp_simpleTest (doing
just a simple select).
I granted all permissions for users/groups/roles.
I see the stored-procedure in the list generated by sp_help.

but when I execute it in WinSQL it says:
Error: Stored procedure 'sp_simpleTest' not found. Specify owner.objectname
or use sp_help to check wheter the object exists (sp_help may produce lots
of output).
(State:37000, Native Code: AFC)

I also tried executing: exec dbo.sp_simpleTest but it gives the same error.

BTW. I created my own database on which te stored procedures work just fine.

Anyway, I'm pretty puzzled by now. Can anybody help me out?

Thanks in advance.

Gino Talamini

[Rob Verschoor]

Sounds like an ownership mismatch. I expect that the proc is owned by
user 'abc' (database user that is), so it should be executed as "exec
abc.sp_simpleTest" when you're that specific user 'abc' when you're
executing it.
(run "sp_help sp_simpleTest" if you want to see the actual owner)

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Associate DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:r...@sypron.nl
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Gino Talamini" <ne...@talamini.com> wrote in message
news:8jhooc$koh$1...@linux1.netconx.de...