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: Wed, 30 Jul 2003 06:07:00 -0000

On Wed, 2003-07-30 at 07:47, James K. Lowden wrote:
> 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. ;-)

You *could* just do sp_help all by itself - or "sp_help sysusers", as
the sysusers table is guaranteed to exist in all the databases and all
the versions of Sybase and MS-SQL.

Michael






Archive powered by MHonArc 2.6.24.

Top of Page