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 I create a new template for import ? : sql server management studio

0 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

What is BCP? When does it used in sql server 2012?

0 Answers   TryTechnicals Pvt Ltd,

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

How to convert character strings into numeric values?

0 Answers  

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

Which joins are sql server default?

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

What is fill factor and pad index?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

How to populate a table in sql server?

0 Answers  

---