<div>
Do this from the Command line:<br />
net start MSSQLSERVER<br />
net start SQLSERVERAGENT
</div>


Do this from the Command line:
net start MSSQLSERVER
net start SQLSERVERAGENT

<div>
Also, just friendly reminder but the following questions are now considered abandoned, please attend to them:<br />
1 02/28/2007 500 sql server cou at 100% and wil... Open MS SQL Server <br />
2 02/22/2007 500 SQL DTS error, how to troubles... Open MS SQL DTS <br />
3 01/11/2007 500 How to find the root of blocki... Open MS SQL Server <br />

</div>


Also, just friendly reminder but the following questions are now considered abandoned, please attend to them:
1 02/28/2007 500 sql server cou at 100% and wil... Open MS SQL Server
2 02/22/2007 500 SQL DTS error, how to troubles... Open MS SQL DTS
3 01/11/2007 500 How to find the root of blocki... Open MS SQL Server


<div>
<div class="content wysiwyg-content">
Hi,<br />
How can I restart the mssqlserver and sqlserveragent in QA?<br />
I try with this command exec master..xp_cmdshell 'net start msssqlserver' but there is an option Yes or not which I do not know how to enter the values
</div>
</div>


Hi,
How can I restart the mssqlserver and sqlserveragent in QA?
I try with this command exec master..xp_cmdshell 'net start msssqlserver' but there is an option Yes or not which I do not know how to enter the values

How to start the mssqlserver by using xp_cmdshell

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.