Answer Posted / kinthada cnu

hi all

DTS : Data Transformation service.using DTS object transfor
the data from one database into anothert database.

ex:sqlserver to orcale or ms-acces.....

How many null values we can have in a unique key field in sql server?

958

---

What is self contained sub query?

1057

---

What are the requirements for sql server 2016?

882

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1066

---

How do you create an execution plan?

948

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

---

what are the new features introduced in sql server 2000? : Sql server database administration

917

---

How to make a remote connection in a database?

977

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

935

---

between cast and convert which function would you prefer and why?

955

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1096

---

How does Report Builder support Analysis Services cubes?

153

---

How do I create a partition table in sql server?

1123

---