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

Which are new data types introduced in sql server 2008?

0 Answers  

---

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

2 Answers   TCS, Wipro,

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

Why do we use non clustered index?

0 Answers  

---

How to drop an existing stored procedure in ms sql server?

0 Answers  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

What is the difference between coalesce() & isnull()?

0 Answers  

---

What are the types of lock supported by ?

0 Answers   HCL,

---

What are the essential components of sql server service broker?

0 Answers  

---

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

---