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

How do I open a .db file?

478


What does the on update no action do?

587


What is an inner join?

526


Differentiate between ms sql server reporting services vs crystal reports?

485


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5495






What are the benefits of normalization?

577


What is the difference between getdate and sysdatetime?

533


What is openxml in sql server?

614


What is transaction server isolation?

575


How you can find out if an index is useful to the optimizer?

490


how you can deploy an ssrs report?

127


Explain the disadvantages/limitation of the cursor?

562


What are the restrictions that views have to follow?

555


What are sql dirty pages?

552


What is normalization and denormalization in sql server?

535