Answer / rajkumar

1.SQL Server 2005 has better tool enhancements like SQL
Server Management Studio.
2.Developers can write Native .NET Stored Procedures and
deploy them to SQL Server 2005.
3.It has more Enhancements in the areas of DBA, Developer
Productivity with .NET

For More details..Verify these links..
http://wiki.answers.com/Q/Diff_between_sql_server_2000_and_s
ql_server_2005
http://techinterviewquestion.blogspot.com/2008/06/some-
difference-between-sql-server-2000.html

How to round a numeric value to a specific precision?

0 Answers  

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

What are the requirements on sql server network connections?

0 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

SQL Server Performance Tuning for Stored Procedures & reducing debugging time?

1 Answers   CarrizalSoft Technologies,

---

---

What is auditing in sql server?

0 Answers  

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

What does the update command do?

0 Answers  

---

How to execute stored procedure in select statement sql server?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

---

How many databases instances are there in sql server 2000?

0 Answers  

---

What are the different types of normalization?

0 Answers  

---