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 to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

What is collation sensitivity?

0 Answers  

---

List the types of recovery model available in sql server?

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

How do you delete a trigger?

0 Answers  

---

How do I clean up sql server transaction log?

0 Answers  

---