difference between sql server2000 and sql server2005

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

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the impact on other user sessions when creating indexes?

542


What are the different Authentication modes in SQL Server and how can you change authentication mode?

641


Tell me what is log shipping?

571


How do I completely remove sql server instance?

566


Do you know what is user defined datatypes and when you should go for them?

502






How to Check if table exists in sql server?

619


When a primary key constraint is included in a table, what other constraints does this imply?

603


How to filter records of table in SQL SERVER?

601


What are the differences between clustered and non-clustered index?

539


What is a transact-sql statement?

537


What is difference between equi join and inner join?

482


What is a subquery in a select query statement in ms sql server?

589


What does dml stand for?

509


Why do we backup Active Directory ?

611


How many triggers you can have on a table?

533