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

Mention the differences between local and global temporary tables.

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

What is built-in/administrator?

0 Answers  

---

How to integrate the ssrs reports in application?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---

---

how can we use a composite key for two tables and how can we represent it

1 Answers   BoA,

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

How to loop through returning rows?

0 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What is Schema? and why we use schemas?

4 Answers  

---

What is the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

What is wide table?

0 Answers  

---