isql.exe or isqlw.exe or "SQL Server Enterprise Manager.MSC"
to be found in "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"
There is also a client in \Win\System32\ but I cannot find it
now, someone please help me.
Typical command line to start the client
isql -U scott -P tiger -d gisq
gisq
name of the database
scott
user name
tiger
password
Useful commands
use databaseX
go
sp_help tableX;
go
Beware!
You must type go after every command
If you are using windows you might as well use isqlw.exe
If ou are familiar with Microsoft Access it is easy to link to
SQL Server tables and work from Access.
