Skip to Content.
Sympa Menu

freetds - Re: [freetds] dbmorecmds works

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] dbmorecmds works
  • Date: Wed, 30 Jul 2003 01:47:42 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page