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 do indexes help, types?

0 Answers  

---

How do you delete duplicate records in sql server?

0 Answers  

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What are the different types of replication you can set up in sql server?

0 Answers  

---

How to insert data into an existing table?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

What is difference between views and stored procedures?

0 Answers  

---

Tell me what is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

what is bit datatype? : Sql server database administration

0 Answers  

---

What is INTVAL( )and where we use Plz any body help me

1 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---