Answer / ashis

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.

Answer / gowthami radhakrishnan

sql server 2005 replaces query analyser and enterprise
manager with management studio

Answer / adhi

Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH

Answer / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

What is sql server profiler?

0 Answers  

---

Explain “@@rowcount” and “@@error” in sql server?

0 Answers  

---

plz send every query in sql server2000

1 Answers   Infosys,

---

What is the maximum size per database for sql server express?

0 Answers  

---

What are data files?

0 Answers  

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

What is difference between clustered and non clustered index?

0 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

What are functions

3 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

State a few properties of relational databases?

0 Answers  

---