So, this morning I had to find out what privileges had been granted on a
particular stored proc in Sybase and for the life of me, I couldn’t understand
why sp_helpprotect was giving me the 2812 “stored proc not
found” error message. Finally, I found this page which reminded me that the name of the stored proc is actually sp_helprotect!
Can’t anyone at Sybase spell? I ran into this exact same problem only a month or two ago with RAISERROR … I wasted a good hour until I realized that it wasn’t spelled RAISEERROR, like you would expect it to be, if you could spell.