Answer Posted / ramesh

DTS--> Data Transformation Services
SSIS-->Sql Server Integration Services
in DTS:Message Boxes in activeX scripts
SSIS :Message Boxes In Script Tasks

In DTS:dynamic Properties+ActiveX scripts
SSIS :Configurations+PropertyExpressions

IN
DTS:no deploymentWizard
SSIS:deployment wizards are there

DTs:Limited Set of Transformations
SSIS:huge number of Transformations are available
DTS:ni BI Functionality
SSIS:complete BI Functionality

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

486

---

What are constraints?

588

---

What is a result set object returned by odbc_exec()?

552

---

Why are sql functions used?

622

---

How would you use user_constraints table in DB?

592

---

---

What is temporal table?

484

---

What is snapshot parameter in ssrs?

109

---

Explain what is the main purpose of having conversation group?

525

---

What do you mean by table and field in sql?

558

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

607

---

Does a server store data?

503

---

Explain different types of collation sensitivity?

533

---

What is difference between index seek vs. Index scan?

626

---

What does Master database contains?

630

---

How to change parameter value inside the report?

104

---