FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

On 29 Jul 2003 10:25:28 +0200, Michael Peppler <mpeppler AT bluewin.ch>
wrote:
> 
> The sp_xxx stored procs should normally not be executed with the
> database specifier. They are automatically found by the SQL parser on
> the server. For Sybase 4.x (and MS-SQL, apparently) the sp_xxx procs are
> in master, for Sybase > 10.x the procs live in sybsystemprocs. In any
> case you should just run
>       exec sp_help
> 
> That being said - running "master..sp_help" *should* also work -
> certainly it works here via sqsh and OpenClient.

Right.  I was running "execute master..sp_help sp_help".  The idea was to
get help on something, and help on help seemed to require the fewest
assumptions.  

I couldn't say "execute sp_help sp_help" because the default database
probably wouldn't have an sp_help to get sp_help about.  If you see what I
mean.  ;-)

--jkl