Answer Posted / 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.

How can you append an identity column to a temporary table?

455

---

Define right outer join?

558

---

what is the primary use of the model database? : Sql server administration

518

---

List the different normalization forms?

554

---

What is the use of for clause?

591

---

---

What does top operator do?

581

---

What is dbcc? Give few examples.

590

---

What are the different types of replication are there in sql server 2000?

575

---

Are connections to sql server encrypted?

586

---

What are the disadvantages of indexes?

544

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1730

---

If no size is defined while creating the database, what size will the database have?

558

---

Can a table be created inside a trigger?

576

---

What are the different types of triggers in SQL SERVER?

554

---

How to disable a login name in ms sql server?

605

---