Difference between revisions of "Starting SQL Server"

From SQLZOO
Jump to: navigation, search
(Created page with "<h1>Running SQL Server</h1> <table border="1"> <tr> <th>Name of the server</th> <td>sqlservr.exe</td> </tr> <tr> <th>Name of the client</th> <td>isql.exe or isqlw.exe or "SQL...")
 
Line 50: Line 50:
  
 
</table>
 
</table>
 +
 +
----

Revision as of 05:14, 11 February 2013

Running SQL Server

Name of the server sqlservr.exe
Name of the client 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.


Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense