Re: osql to connect to a Database
From: Gert E.R. Drapers (GertD_at_SQLDev.Net)
Date: 01/06/05
- Next message: Bourriague: "Great Plains 8.0 and MS Project Server 2003 off one SQL Server?"
- Previous message: Manzoorul Hassan: "osql to connect to a Database"
- In reply to: Manzoorul Hassan: "osql to connect to a Database"
- Next in thread: Manzoorul Hassan: "Re: osql to connect to a Database"
- Reply: Manzoorul Hassan: "Re: osql to connect to a Database"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 Jan 2005 00:08:18 +0100
osql -S (local) -E -d pubs
GertD@SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Manzoorul Hassan" <manzoorul.hassan@gmail.com> wrote in message
news:1105052724.438484.94120@z14g2000cwz.googlegroups.com...
>I am running MSDE 2000 Rel A on a Windows XP machine and am able to
> connect to it by doing the following:
>
> osql -U sa
>
> or
>
> osql -E
>
> But how do I connect to a Particular Database or see all the tables
> etc? I am a but familiar with sql (which could be the problem) and an
> trying to do the following that I can with it:
>
> sql user_name/database_name@password
>
> so that I can connect directly to the DB I'm interested and then I can
> do:
>
> select tablenames;
> desc table_name;
> select * from table_name;
> etc
>
> Any ideas? Like I mentioned, maybe I'm trying to do things that is not
> supposed to be possible with osql (which would really suck).
>
> - manzoor
>
- Next message: Bourriague: "Great Plains 8.0 and MS Project Server 2003 off one SQL Server?"
- Previous message: Manzoorul Hassan: "osql to connect to a Database"
- In reply to: Manzoorul Hassan: "osql to connect to a Database"
- Next in thread: Manzoorul Hassan: "Re: osql to connect to a Database"
- Reply: Manzoorul Hassan: "Re: osql to connect to a Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
