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.

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is not null constraint?

0 Answers  

---

Explain indexed views?

0 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

State a few properties of relational databases?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How can change procedure in sql server?

0 Answers  

---

Explain foreign key in sql server?

0 Answers  

---