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 are different types of roles provided by ssrs?

150

---

How to execute stored procedure and set temp table in sql server?

1040

---

What causes index fragmentation?

997

---

What is the process of normalization?

1124

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1066

---

When I delete any data from a table, does the sql server reduce the size of that table?

1018

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1029

---

What do you understand by the analysis services in sql server?

939

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1143

---

How to send a ssrs report from ssis?

176

---

How can a user-defined datatype be created?

985

---

How you can get the list of largest tables in a database?

1015

---

explain databases and sql server databases architecture? : Sql server database administration

962

---

Name and describe few console utilities for ssrs?

284

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

998

---