Answer / swapna

Sql Server can be started from command line, using the
Sqlserver.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 / sqlserverbuddy

1. STOP the SQL Server Service(Management Studio or Service)
2. Step into Root directory of the SQL server Instance
(Default or Named Instance)
3. Enter as given below for Default Instance
sqlservr -m
4. Enter as given below for Named Instance (MyServer)
sqlservr -m -s MyServer
5. Don't close the DOS screen which processing internal
activities.
6. Open the SQL Server management studio and Proceed

Answer / rahul

1) type cmd in rum
2) Stop the Server from configuration manager first and
then In Command Window, Type net start mssqlserver -m for
starting the Service in single user mode.
3) Type net start mssqlserver -f to start the Server in
minimal configration.

What is a coalesce function?

0 Answers  

---

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

---

What is the New in SQL server 2008?

0 Answers  

---

How to search for a string in all stored procedure in sql server?

0 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---

What is faster join or union?

0 Answers  

---

what are isolation levels? : Sql server database administration

0 Answers  

---

what is a self join? : Sql server database administration

0 Answers  

---

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 merge statement?

0 Answers  

---

What is difference between equi join and natural join?

0 Answers  

---

What is the default order of an order by clause?

0 Answers  

---