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

1217

---

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

1190

---

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

1113

---

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

1183

---

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?

1109

---

What is DCL?

1105

---

What are the commands used in DCL?

1086

---

What is the default fill factor value?

1132

---

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

1120

---

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

1143

---

What are the recovery models for a database?

1153

---

What is the importance of a recovery model?

1095

---

What is Replication?

1108

---

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

1133

---

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

1130

---