Answer / swapna

SQL Server can be started from command line, using the
SQLSERVR.EXE. This EXE has some very important parameters
with which a DBA should be familiar with. -m is used for
starting SQL Server in single user mode and -f is used to
start the SQL Server in minimal confuguration mode. Check
out SQL Server books online for more parameters and their
explanations.

Answer / ganeshsamurti

• Open "Control Panel->Administrative Tools->Services"
• Mouse right click on specified SQL Server instance service
and select "Properties" menu to bring up following
configuration window:

• Specify start parameters as following:

-s{ Instance name } -m

If instance is default instance (no instance name) ,then
just enter

-s -m
• Restart the SQL Server instance service



SQL Server can be started from command line, using the
SQLSERVR.EXE. This EXE has some very important parameters
with which a DBA should be familiar with. -m is used for
starting SQL Server in single user mode and -f is used to
start the SQL Server in minimal confuguration mode.

Answer / abc

sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command

Can you explain different types of locks in sql server?

0 Answers  

---

Does table partitioning improve performance?

0 Answers  

---

What is a natural primary key?

0 Answers  

---

explain different types of cursors? : Sql server database administration

0 Answers  

---

what is sql injection in sql server?

2 Answers   TATA,

---

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

What is bulkcopy in sql?

0 Answers  

---

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

---

What is the impact on other user sessions when creating indexes?

0 Answers  

---

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

---

What are translations and its use? : sql server analysis services, ssas

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---