Answer Posted / 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.

What is a raid and what are different types of raid configurations?

1203

---

What are the types of dml?

930

---

What is self contained sub query?

969

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

991

---

What is attribute? : sql server analysis services, ssas

978

---

Can we deploy SSRS reports on our personal website?

162

---

What is lock escalation? : sql server database administration

1102

---

How to convert a table data in XML format in sql server?

2493

---

How many types of the database links?

1023

---

What is used to replicate sessions between instances in coldfusion clusters?

1016

---

What are distributed partitioned views?

1006

---

What are the different sql server versions?

931

---

What is the difference between a stored procedure and a user defined function?

973

---

What are the different acid properties?

1013

---

What do you need to connect php to sql server?

1038

---