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

what is spatial nonclustered index

0 Answers  

---

What is the difference between windows authentication and sql server authentication

7 Answers   HCL,

---

What is bit data type?

0 Answers  

---

Explain the advantages of merge replication?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

---

Which is the latest version of sql server and when it is released?

0 Answers  

---

Do you know what is a linked server in sql server?

0 Answers  

---

Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation

2 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What is entity data services?

0 Answers  

---

What happens when converting big values to integers?

0 Answers  

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---