Answer / dharmendra k. dixit

Master , MSDB and TempDB
these are the inbuild Database which r provided by SQL
SERVER.
All have their own functinality & responsbility like.

1. Master : Master DB is responsible for Storing all
information at system level.
2. MSDB : it is Microsoft DB, it creates a Copy of whole
Database in it
3. TempDB : it stores all the log information of Server,
it will initilize automatically wheneve Server will start,
the max. size alloted fro TempDB is 10MB.

Thanks & Regards
Dharmendra k. Dixit

Answer / pinak

the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.

tempdb is a temprary database.

how can you move the master database

1 Answers   IBM,

---

What is self contained sub query?

0 Answers  

---

What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

0 Answers   IBM,

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

0 Answers  

---

Explain sql delete command?

0 Answers  

---