Difference between revisions of "Starting SQL Server"

Jump to: navigation, search
(Blanked the page)
Line 1: Line 1:
<h1>Running SQL Server</h1>
<table border="1">
<th>Name of the server</th>
<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>
<th>Typical command line to start the client</th>
<td>isql -U scott -P tiger -d gisq
<dd><p>name of the database</p>
<dd><p>user name</p>
<th>Useful commands</th>
use databaseX
sp_help tableX;
<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>

Latest revision as of 05:52, 1 March 2013