why can I never remember sp_helptext?

Roughly once ever year or two, I have to look at a Sybase database to do some troubleshooting and it almost always involves looking at the body of a stored procedure. Since it’s so infrequent, I can never remember what the magic incantation is to get Sybase to give up that blossom of information. Every time, I spend a good five or ten minutes Googling around until I find the Sybase cheat sheet that reminds me the answer is sp_helptext.

Tags:
,

Related posts:

  1. sp_helprotect, not sp_helpprotect … can’t anyone at Sybase spell?!
  2. How to find what depends on a stored procedure in Sybase
  3. Is Vertica’s product just Sybase IQ?
  4. Butte Pirates, remember this gag?
  5. “SELECT DISTINCT … ORDER BY” is broken in Sybase ASE 12.5.3

Speak Your Mind

*