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).

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What is Left Outer Join?

2 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

---

what is checksum in sql server.........???

0 Answers   TCS,

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---

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

2 Answers   Accenture,

---

how can i view structure of table in sql server? tell me that query.

10 Answers  

---

What is mapping schema?

0 Answers  

---

What does it mean to invest in the index?

0 Answers  

---