Differnce between sel server 2000 and 2005

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 ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is isolation levels?

572


What is a data source or ds? : sql server analysis services, ssas

572


Explain what is the use of custom fields in report?

501


How to use the inserted and deleted pseudo tables?

545


What have included columns when we talk about sql server indexing?

581






What is data file in computer?

547


What is exporting utility?

544


What is partition, how will you implement it? : sql server analysis services, ssas

606


How to find table changes in sql server?

663


Explain the steps needed to create a scheduled job?

525


How to connect a database with sql express.?

572


How to get all stored procedures in sql server?

510


What is ms sql server index?

565


What are different types of data sources?

496


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3761