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.

What are the recovery models in sql server 2000?

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

how to take backup bcp out for a column in table in sql server?

0 Answers  

---

---

Explain throw statement in sql server 2008?

0 Answers  

---

How to check status of stored procedure in sql server?

0 Answers  

---

What is a virtual table in sql?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Explain about system stored procedure?

0 Answers  

---