what is advantages in sql 2005 over sql 2000?

Answer Posted / ashis

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You want to implement the one-to-many relationship while designing tables. How would you do it?

499


What is query cost in sql server?

548


How do I connect to sql server database?

470


What are the differences between decimal and float in ms sql server?

558


What are the types of user defined functions in sql server?

492






What is built-in function?

541


What are the differences between stored procedure and view in sql server?

614


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

488


What is rolap and its advantage? : sql server analysis services, ssas

638


What is the syntax for encrypting a column in SQL Server?

550


What is the difference between stored procedure and functions?

591


What is a dbms wizard?

611


How to count rows with the count(*) function in ms sql server?

533


How to implement service broker?

519


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

577