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

1116

---

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

1105

---

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

1023

---

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

1087

---

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?

1013

---

What is DCL?

999

---

What are the commands used in DCL?

983

---

What is the default fill factor value?

1035

---

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

1032

---

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

1043

---

What are the recovery models for a database?

1074

---

What is the importance of a recovery model?

1017

---

What is Replication?

1009

---

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

1005

---

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

1032

---