Answer / jerry joseph

.NET Runtime integration
SQL Server 2005 is integrated with .NET Runtime

Email sending capability
You can send emails from SQL Server 2005 which you couldnt
do with SQL Servr 2000

TRY CATCH error handling
In SQL Server 2005 we have TRY CATCH for better error
handling. We had only @@ERROR in SQL Server 2000 which was
very primitive

Answer / monal

SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building

Answer / velmurugan,uk

There are many differences interms of
1.Architecture,
2.Services,
3.Performance,
4.Scalability,
5.Design and Deployment application,
6.Tools
and so on...

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

Can you explain the role of each service?

1 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

---

What is difference between equi join and inner join?

0 Answers  

---

Difference between drill down and drill through report.

0 Answers  

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

What is the recovery model?

0 Answers  

---

What are the different types of locks in the database?

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---