Difference between sql server 2000 and sql server 2005?

Answer Posted / nishant

XML services is provided in 2005 not in 2000

Is This Answer Correct ?    183 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what type of index will get created after executing the above statement? : Sql server database administration

537


Write a sql query to sort on different column name according to the parameters passed in the function?

532


What is database dimension? : sql server analysis services, ssas

620


What is ms sql server index?

562


What happens if null values are involved in bitwise operations?

603






What is the default value of an integer data type in sql server 2005?

584


What do you understand by SQL*Net?

613


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

538


in the physical file layout, where should the transaction log be stored in relation to the data file?

534


Name 3 ways to get an accurate count of the number of records in a table?

571


What are the advantages of partitioning?

641


What the different components of Replication and what is their use?

559


what types of replication are supported in sql server? : Sql server database administration

466


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

533


What is partition index in sql server?

606