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

Can coalesce return null?

0 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

what is Archive old data?

1 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

What is a Join in SQL Server?

3 Answers  

---

what is lazy writer?

1 Answers   Wipro,

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  

---