Difference between revisions of "Starting SQL Server"
From SQLZOO
(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 04: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" |
| Typical command line to start the client | isql -U scott -P tiger -d gisq
|
| 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. |
