RE: dbmorecmds works

On Tue, 2003-07-29 at 07:54, Frediano Ziglio wrote:
> ...
> > 
> > Mmm... sp_help is really old. Should be present even on Sybase... I'll
> > test this evening.
> > 
> 
> Do not work with Sybase 11.9.2 (my Sybase test server)


> TDS dump (end):
> Sending packet @ 07:51:33.975287
> 0000 0f 01 00 2d 00 00 00 00-21 20 00 00 00 00 65 78 |...-.... ! ....ex|
> 0010 65 63 75 74 65 20 6d 61-73 74 65 72 2e 2e 73 70 |ecute ma ster..sp|
> 0020 5f 68 65 6c 70 20 73 70-5f 68 65 6c 70          |_help sp _help|

> sp_help is in sybsystemprocs on my server.

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.

Michael