Answer Posted / rajesh bhawsar

1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master

Does sql server 2000 clustering support load balancing?

768

---

What are the different types of sql server replication? : sql server replication

862

---

how can you attach more than 20 ldf files in sql server

1790

---

Can we use pragma autonomous_transaction in trigger?

741

---

What command must you use to include the not null constraint after a table has already been created?

799

---

How do I find query history in sql server?

718

---

What is bcp? When does it used?

763

---

What is tempdb database? : SQL Server Architecture

843

---

Do you know sql server 2008 backup compression?

785

---

How can i Relate Tables in SSIS

859

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

788

---

Explain trigger and trigger types?

769

---

Indexes are updated automatically is the full-text index also updated automatically?

835

---

What is function of master database?

110

---

Explain powershell included in sql server 2008?

825

---