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.

List the different types of joins?

0 Answers  

---

What is the dbcc command and why is it used?

0 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

What is store procedure?

0 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

What is user-defined function?

0 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---

When you should use a low fill factor?

0 Answers  

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---