FreeTDS Development Group

[Michael Peppler <mpeppler AT bluewin.ch>]

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