Answer Posted / 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 are candidate key, alternate key and composite key? : Sql server database administration

851

---

How to recreate an existing index in ms sql server?

982

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

928

---

Explain differences between web edition and business edition?

119

---

Distinguish between nested subquery and correlated subquery?

971

---

Different types of keys in SQL?

1024

---

What is the template in sql?

914

---

What is difference between temp table and cte?

959

---

Explain the purpose of indexes?

891

---

What is an index in sql?

955

---

What are temporal tables in sql server 2016?

838

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

926

---

What the difference between UNION and UNIONALL?

984

---

What do mean by xml datatype?

1003

---

Can foreign key be deleted?

870

---