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 are the difference between primary keys and foreign keys?

0 Answers  

---

How to insert multiple rows with a subquery?

0 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

Difference between connected and disconnected database in .net with sql server?

0 Answers   Infosys,

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---

Explain rdbms?

0 Answers  

---

What value could be assigned to Varchar Type?

3 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

What is outer join in sql server joins?

0 Answers  

---

What are different types of join?

0 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Explain transaction server implicit?

0 Answers  

---