adspace


What are the new features introduced in SQL Server 2000?
What changed between the previous version of SQL Server and
the current version?

Answer Posted / Ajit Kumar Pandey

SQL Server 2000 introduced several new features like Service Broker, XML support, Analysis Services, Integration Services (SSIS), Full-Text Search, and ActiveX Data Objects (ADO) for .NET. Compared to SQL Server 7.0, it also featured improved performance, increased storage capacity, better scalability, and enhanced security.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we solve concurrency problems?

1122


Can one drop a column from a table?

1089


Does view occupy space?

1019


When should you use an instead of trigger?

1052


What is the primary use of the model database?

1149


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1047


Can we shrink data file in sql server?

1128


what is spatial nonclustered index

1058


Is it possible to have clustered index on separate drive from original table location?

1040


Why and when do stored procedure recompile?

1061


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8230


Can you index views?

954


What is sql or structured query language?

1227


What is clustered index

1086


What are the different subsets of sql?

1652