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.

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

How sql server enhances scalability of the database system?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

How many types of stored procedures are there in sql server?

0 Answers  

---

What is order of B+tree?

0 Answers   HCL,

---

How to select true false based on column value in sql server?

0 Answers  

---

What are different types of join?

0 Answers  

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

How many types of triggers are there?

0 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---