Home > Archive > MS SQL Server > March 2006 > Starting SQL Server 2000









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Starting SQL Server 2000
Praveen

2006-03-05, 8:23 pm

In this syntax

net start mssqlserver 1> NUL 2> NUL

what is the use of follwing piece of code "1>NUL and 2 >NUL" ?.

Pls help me.

Jack Vamvas

2006-03-05, 8:23 pm

Just use "net start mssqlserver " if it's a default instance.
Check http://msdn2.microsoft.com/en-us/library/ms190737.aspx for a whole
range of start up parameters
--
Jack Vamvas
____________________
_______________
Receive free SQL tips - www.ciquery.com/sqlserver.htm


"Praveen" <apveen@gmail.com> wrote in message
news:1141301544.242449.177620@i40g2000cwc.googlegroups.com...
> In this syntax
>
> net start mssqlserver 1> NUL 2> NUL
>
> what is the use of follwing piece of code "1>NUL and 2 >NUL" ?.
>
> Pls help me.
>



Praveen

2006-03-05, 8:23 pm

Yes i know bit about startup parameters. But i want know what is the
use of this syntax "net start mssqlserver 1> NUL 2> NUL"

i.e what is the use of this 1> NUL 2> NUL piece of code?.

regards

Tibor Karaszi

2006-03-05, 8:23 pm

Where did you see that syntax?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/



"Praveen" <apveen@gmail.com> wrote in message
news:1141305436.210575.127330@i40g2000cwc.googlegroups.com...
> Yes i know bit about startup parameters. But i want know what is the
> use of this syntax "net start mssqlserver 1> NUL 2> NUL"
>
> i.e what is the use of this 1> NUL 2> NUL piece of code?.
>
> regards
>



Linchi Shea

2006-03-05, 8:23 pm

I beleive that is to redirect stdout and stderr to NUL device.

Linchi

"Praveen" wrote:

> Yes i know bit about startup parameters. But i want know what is the
> use of this syntax "net start mssqlserver 1> NUL 2> NUL"
>
> i.e what is the use of this 1> NUL 2> NUL piece of code?.
>
> regards
>
>

Praveen

2006-03-05, 8:24 pm

I am exploring the PSSLabs downloaded from microsoft website. This
syntax is been used in all most all the batch files for starting the
sql server.

Tibor Karaszi

2006-03-05, 8:24 pm

I see. I concur with Linchi's comment. Seems like they are piping the output from NET START to nul
so you don't have to see that output.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

Blog: http:// solidqualitylearning
.com/blogs/tibor/



"Praveen" <apveen@gmail.com> wrote in message
news:1141377556.891854.12210@v46g2000cwv.googlegroups.com...
>I am exploring the PSSLabs downloaded from microsoft website. This
> syntax is been used in all most all the batch files for starting the
> sql server.
>


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com