Differnce between sel server 2000 and 2005

Answer Posted / narasimha

1)sqlserver 2000 contain query analyzer and enterprise
manger as a seperate tools but sqlserver 2005 contains a
single management studio(query analyzer + enterprise
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management
studio for dedugging sp's.

4)CLR stored procedures

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to include date and time values in sql statements?

803


Distinguish between nested subquery and correlated subquery?

749


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1067


Do you know how to store and query spatial data?

778


What is the minimum recommended amount of ram for sql server 2012 enterprise?

684






what is checksum in sql server.........???

1373


What does nvl stand for?

708


Explain the microsoft sql server delete command?

699


What is create statement?

678


What is a DBMS, query, SQL?

761


Explain timestamp datatype?

714


What is raid and what are different types of raid levels?

775


How to turn off warning messages during php execution?

714


How to view the error log for any specific instance? : sql server database administration

767


What is explicit cursors?

733