FreeTDS Development Group

["Sherrill, Justin" <jsherrill AT currentcomm.net>]

'exec sp_tables', assuming stored procedures are installed.  

-----------------------------
Justin C. Sherrill - CURRENT Communications
220 Kenneth Drive
Rochester, New York 14623
P: 585.486.0549 F: 585.486.0030

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> bounces AT lists.ibiblio.org] On Behalf Of SteveC
> Sent: Wednesday, May 02, 2007 7:39 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] login failures
> 
> 
> On 30 Apr 2007, at 21:17, James K. Lowden wrote:
> 
> > SteveC wrote:
> >> I'm using tsql on a remote machine and a remote MS SQL db of
unknown
> >> version. I have a username and password from some source code. I
can
> >> connect to the db but I get login failure with the user/pass.
> >
> > Export TDSDUMP=log, try your tsql query again, and look at the
> > log.  The
> > file will be short.  It will tell you the TDS version used.  If
> > there's a
> > login failure, it will say that too.
> 
> Thanks very much, I've got it working and can connect with 4.2 or 8.0.
> 
> It now sits there with prompts
> 
> 1>
> 2>
> 3>
> 
> etc no matter what I type. I'd appreciate hints on what I can do to
> 'show tables' as I would in mysql or '\d' in postgres... or
> recommendations for books on mssql. Or is there something more deeply
> wrong?
> 
> Also, is there a howto for dumping the database with freebcp, the
> tool you mentioned?
> 
> Thanks in advance :-)
> 
> have fun,
> 
> SteveC | steve AT asklater.com | http://www.asklater.com/steve/
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

***CONFIDENTIALITY NOTICE***
The information in this email may be confidential and/or privileged. This 
email is intended to be reviewed by only the individual or organization named 
above. If you are not the intended recipient or an authorized representative 
of the intended recipient, you are hereby notified that any review, 
dissemination or copying of this email and its attachments, if any, or the 
information contained herein is prohibited. If you have received this email 
in error, please immediately notify the sender by return email and delete 
this message from your system.