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 do you mean by data integrity?

597


What is a group function explain with an example?

521


What are key constraints?

512


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

509


How to find which stored procedure is currently running in sql server?

488






What is the need for indexing?

496


Does sql server use t sql?

525


What is update locks?

509


What is apply operator in sql?

560


If the job running very slow what is the action you do

1425


What is the full meaning of dml?

523


Explain the dirty pages?

573


What is the Disadvantage of indexed sequential file.

616


What is the purpose of optimization?

540


What are extended events in sql server?

506