What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1172

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1152

---

How do you troubleshoot errors in a SQL Server Agent Job?

1068

---

What is the default Port No on which SQL Server listens?

1131

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1065

---

What is DCL?

1058

---

What are the commands used in DCL?

1031

---

What is the default fill factor value?

1091

---

Where do you find the default Index fill factor and how to change it?

1068

---

What is a system database and what is a user database?

1093

---

What are the recovery models for a database?

1114

---

What is the importance of a recovery model?

1052

---

What is Replication?

1056

---

What the different types of Replication and why are they used?

1078

---

What the different components of Replication and what is their use?

1075

---