Answer Posted / debasish

in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup

there is no sqlserver2002 hope so

explain declarative management framework (dmf) in sql server 2008?

979

---

What are the different types of indexes?

1101

---

How can I create a new template for import ? : sql server management studio

1063

---

How to generate create procedure script on an existing stored procedure?

999

---

Explain logical operators in sql server?

1097

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

998

---

What is a covering index?

977

---

What are the new security features added in sql server 2012? : sql server security

1009

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

---

Explain candidate key, alternate key, and composite key?

987

---

How to generate create table script on an existing table in ms sql server?

1136

---

What is difference between materialized view and view?

902

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1006

---

what protocol both networks use? : Sql server database administration

963

---

How adventureworkslt tables are related?

919

---