Answer Posted / srikanth

DTS are a kind of routines for transforming data from one
type to other type. suppose we have data in excel sheets or
flat files, comma separated values. DTS helps us in
transforming this type of data to other types like
transofroming to SQL Server tables.
Integration services is the latest technology in this field.
It has got many controls which make the tasks of DTS easier.
so complex transformations can be doen using it. It comes
with SQL Server 2005 Business Intelligence suite

Can the query output be sorted by multiple columns in ms sql server?

987

---

What is the use of builtinadministrators group in sql server? : sql server security

1052

---

Can we call future method from trigger?

947

---

What are the different types of collation sensitivity?

1129

---

What is a ddl statement?

921

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1023

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1012

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1023

---

How to select an exiting database using mssql_select_db()?

994

---

What are xml indexes?

954

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1049

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1007

---

What is acid db?

891

---

Do you know sql server 2008 introduces automatic auditing?

986

---

last function used in MS Access to convert sql what function will use in sql

2078

---