Starting SQL Server - Revision history

182.72.168.130: Blanked the page

2013-03-01T05:52:07Z

Blanked the page

Satya at 04:14, 11 February 2013

2013-02-11T04:14:31Z

Connor: Created page with "

Running SQL Server

Name of the server	sqlservr.exe
Name of the client	isql.exe or isqlw.exe or "SQL..." 2012-07-19T10:31:56Z 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..." New page <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>

Name of the server

sqlservr.exe

Name of the client

isql.exe or isqlw.exe or "SQL..."

2012-07-19T10:31:56Z

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..."

New page

<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>

← Older revision		Revision as of 05:52, 1 March 2013
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>~~
−
−	~~----~~

← Older revision		Revision as of 04:14, 11 February 2013
Line 50:		Line 50:

	</table>		</table>
		+
		+	----