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 dml command?

0 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

What is the simplest way to create a new database in ms sql server?

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

What is the command used to check locks in microsoft sql server?

0 Answers  

---

What is an identity column in insert statements?

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

What is function of CUBE ?

0 Answers   HCL,

---

What is the size of transaction log file?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

Can we drop user if user mapped to any logins

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---