wat is the main diff between sql server 2000and sql server 2005

Answer Posted / hari

In 2005 More features is available
Database Mirroiring
CLR Integration(Common language Runtime ) Integration
Management Studio
SIS Package
mirror backup
DAC(Dedicate Administration Connection)

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

87


How will you know when statistics on a table are obsolete?

608


How can i Relate Tables in SSIS

577


How to get a list of columns using the "sp_help" stored procedure in ms sql server?

584


What does the not null constraint do?

581






Can I work with several databases simultaneously? : sql server management studio

563


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

500


How can a user-defined datatype be created?

542


Explain system functions or built-in functions? What are different types of system functions?

567


Difference between Sql server reporting services and Crystal reports?

124


Can we write a distributed query and get some data which is located on other server and oracle database?

765


What is the use of group by clause?

529


Explain about unique identifier data type in sql server?

514


What are the disadvantages of using querystrings to send data from one page to another?

586


What are filegroups in sql server?

581