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

How reterive duplicate value in SQL?

6 Answers  

---

Write a sql query to delete duplicate records from a table called table1

0 Answers  

---

How to download microsoft sql server 2005 express edition?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

What do you mean by cardinality?

0 Answers  

---

---

What are the main differences between #temp tables and @table variables and which one is preferred?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

How many types of cursors are there in SQL Server?

5 Answers   247Customer, CarrizalSoft Technologies,

---

Explain isolation levels that sql server supports?

0 Answers  

---

Please explain go command in sql server?

0 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---