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

List all the types of user-defined functions?

526


What do mean by xml datatype?

623


Which is the main third-party tool used in sql server?

478


How do you know if sql server is running on your local system?

548


How do you debug a procedure in sql server?

500






what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1581


Tell me what are the essential components of sql server service broker?

513


How do you create a clustered index?

532


what is denormalization and when would you go for it? : Sql server database administration

709


What is self contained scalar sub query?

542


Can a rule be bound to any column of any data type?

574


What are the types of subquery?

552


Explain various On-Delete options in a DB table. Which is the default option?

900


How to sort the query output with order by clauses in ms sql server?

636


Do you know what is normalization of database? What are its benefits?

564