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 is the output for this query select * from employee where 1=1;

4 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---

What is the stored procedure?

0 Answers  

---

What are various ways to enhance the ssrs report?

0 Answers  

---

What is trigger explain with program?

0 Answers  

---

What is apply operator in sql?

0 Answers  

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

Explain steps of normalization?

0 Answers  

---

Can a function call a stored procedure in sql server?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---

What is truncate table?

0 Answers  

---