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

What happens if strings are casted into wrong code pages in ms sql server?

1 Answers  

---

What are functions in the sql server?

1 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

What happens if null values are involved in comparison operations?

1 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What is compression - row-level and page-level compression?

1 Answers  

---

How to run sql server 2005 books online on your local system?

1 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1 Answers  

---

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

1 Answers  

---

What stored by the msdb? : sql server database administration

1 Answers  

---