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 database white box testing?

1087

---

How do I get to sql server configuration manager?

958

---

What is microsoft sql server?

920

---

Why is the need for data conversion transformations?

985

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

898

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

952

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1075

---

What are ddl triggers and types of ddl trigger?

985

---

what is an extended stored procedure? : Sql server database administration

1002

---

Write an sql query for deleting duplicate rows?

960

---

What is the difference between having clause and where clause in sql server?

1039

---

How do you improve the performance of a SQL Azure Database?

135

---

How to get a list of columns using the "sys.columns" view in ms sql server?

924

---

Please explain go command in sql server?

1001

---

Explain magic tables in sql server?

993

---