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 deadlock and what is a live lock?

0 Answers  

---

How do I delete a sql server database?

0 Answers  

---

How to use subqueries in the from clause in ms sql server?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

What does the INSTEAD OF trigger do?

3 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---

Does group by or order by come first?

0 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

What is trigger and different types of Triggers?

0 Answers   QuestPond,

---

How to perform key word search in tables?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

How do I shrink an ldf file?

0 Answers  

---