Skip to Content.
Sympa Menu

freetds - RE: [freetds] dbmorecmds works

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT bluewin.ch>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] dbmorecmds works
  • Date: Tue, 29 Jul 2003 08:25:31 -0000

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






Archive powered by MHonArc 2.6.24.

Top of Page