difference between sql server2000 and sql server2005



difference between sql server2000 and sql server2005 ..

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

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the methods used to protect against sql injection attack?

0 Answers  


What should we do to copy the tables, schema and views from one SQL Server to another?

3 Answers  


What is triggers in ms sql server?

0 Answers  


explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  


What is the maximun sixes of .mdf in sql server 2005

1 Answers  


can you any body tell me which service pack is installed in the sql server?

3 Answers  


Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  


To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  


Is truncate a dml command?

0 Answers  


How to skip remaining statements in a loop block using continue statements?

0 Answers  


How except clause is differs from not in clause?

0 Answers  


Define self join in sql server joins?

0 Answers  


Categories