Answer / naresh

DTS (Data Transformation Services) allows you to get stuff
in and out of SQL Server and between any ODBC and OLE DB
data source. That includes DB2, Access, Excel and Text, as
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in
fact, anything with an ODBC driver. Not only does it do the
transfer but it allows you to fill in missing data, do
column mappings and so on. In other words, you can fiddle
with the data as it passes through.

What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  

---

Why is replication required on the sql server?

0 Answers  

---

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

About Indexed Views? with example? plz reply...

2 Answers  

---

What is table value parameters (tvp)?

0 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

How to create a view with data from multiple tables?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

Describe in brief databases and sql server databases architecture.

0 Answers  

---

Explain concepts of analysis services?

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---