Answer / swapna

SQL Server can be started from command line, using the
SQLSERVR.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. Check
out SQL Server books online for more parameters and their
explanations.

Answer / ganeshsamurti

• Open "Control Panel->Administrative Tools->Services"
• Mouse right click on specified SQL Server instance service
and select "Properties" menu to bring up following
configuration window:

• Specify start parameters as following:

-s{ Instance name } -m

If instance is default instance (no instance name) ,then
just enter

-s -m
• Restart the SQL Server instance service



SQL Server can be started from command line, using the
SQLSERVR.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 / abc

sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command

Explain multiserver query

0 Answers  

---

What is data compression?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

What do you understand by the analysis services in sql server?

0 Answers  

---

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

---

Can you please differentiate between a primary key and a unique key?

0 Answers  

---

How to loop through the result set with @@fetch_status?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

How to generate create procedure script on an existing stored procedure?

0 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

What is difference between clustered and non clustered index?

0 Answers  

---

ehat is the default port no of sql 2000?

2 Answers   IBM,

---