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...")
 
(Blanked the page)
 
(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>
 

Latest revision as of 05:52, 1 March 2013

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense