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 an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

Name three of the features managed by the surface area configuration tool? : sql server security

0 Answers  

---

Why do we use stored procedures in sql server?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

What is log in sql server?

0 Answers  

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

Does the unique constraint create an index?

0 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---