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 do you understand by mirroring and mention the advantages of the mirroring?

0 Answers  

---

Can we call future method from trigger?

0 Answers  

---

Explain intellisense for query editing

0 Answers  

---

How do you set a trace flag in sql server?

0 Answers  

---

wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform

1 Answers   Idea,

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

Explain features of analysis services?

0 Answers  

---

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

2 Answers   Genpact,

---

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

Can an automatic recovery be initiated by a user?

0 Answers  

---

what is the different types of backups available in sql server? : Sql server database administration

0 Answers  

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---