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

1163

---

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

1146

---

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

1059

---

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

1124

---

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?

1055

---

What is DCL?

1052

---

What are the commands used in DCL?

1028

---

What is the default fill factor value?

1080

---

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

1063

---

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

1086

---

What are the recovery models for a database?

1106

---

What is the importance of a recovery model?

1048

---

What is Replication?

1047

---

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

1071

---

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

1069

---