|
|
| (One intermediate revision by one user not shown) |
| Line 1: |
Line 1: |
| − | <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 Server Enterprise Manager.MSC"
| |
| − | to be found in "C:\Program Files\Microsoft SQL Server\80\Tools\Binn"<br/>
| |
| − | There is also a client in \Win\System32\ but I cannot find it
| |
| − | now, someone please help me.</td>
| |
| − | </tr>
| |
| − |
| |
| − | <tr>
| |
| − | <th>Typical command line to start the client</th>
| |
| − | <td>isql -U scott -P tiger -d gisq
| |
| − |
| |
| − | <dl>
| |
| − | <dt><p>gisq</p>
| |
| − | <dd><p>name of the database</p>
| |
| − | <dt><p>scott</p>
| |
| − | <dd><p>user name</p>
| |
| − | <dt><p>tiger</p>
| |
| − | <dd><p>password</p>
| |
| − | </dl>
| |
| − | </td>
| |
| − | </tr>
| |
| − |
| |
| − | <tr>
| |
| − | <th>Useful commands</th>
| |
| − | <td><pre>
| |
| − | use databaseX
| |
| − | go
| |
| − | sp_help tableX;
| |
| − | go
| |
| − | </pre></td>
| |
| − | </tr>
| |
| − |
| |
| − | <tr>
| |
| − | <th>Beware!</th>
| |
| − | <td>
| |
| − | <p>You must type <tt>go</tt> after every command</p>
| |
| − | <p>If you are using windows you might as well use isqlw.exe</p>
| |
| − | <p>If ou are familiar with Microsoft Access it is easy to link to
| |
| − | SQL Server tables and work from Access.</p>
| |
| − | </td>
| |
| − | </tr>
| |
| − |
| |
| − | </table>
| |
