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 to rename an existing column with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

What are relationships and mention different types of relationships in the dbms

0 Answers  

---

How to create a simple stored procedure in ms sql server?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

What is the dbcc command and why is it used?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

What happens on checkpoint?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---