Answer Posted / 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

Can a table be created inside a trigger?

963

---

What is an entity-relationship diagram (erd)?

1201

---

What are the differences between having and where clause.

962

---

What is the difference between functions and stored procedures?

1150

---

what is package and it uses and how can u call a package

2010

---

what stored procedure can you use to display the current processes? : Sql server administration

1003

---

What are parameterized reports? What are cascading parameters in ssrs reports?

156

---

What is the difference between sdf and mdf?

1293

---

How to use group functions in the select clause in ms sql server?

1045

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2354

---

can a table be moved to different filegroup? : Sql server administration

955

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1122

---

How do I edit a stored procedure in sql server?

914

---

Does sql server use t sql?

1008

---

What are sql azure firewall rules?

106

---