RSS

Difference b/w sql server 2000 and sql 2005

Please support our MS SQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 2430 | Replies: 2

•

Join Date: Dec 2007

Posts: 10

Reputation: rajesh79 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

rajesh79

Offline

Newbie Poster

Difference b/w sql server 2000 and sql 2005

Jan 22nd, 2008

can anybody tell me abt the difference b/w sql server 2000 and 2005

•

Join Date: Dec 2007

Posts: 287

Reputation: ericstenson is an unknown quantity at this point

Rep Power: 1

Solved Threads: 28

ericstenson ericstenson is offline

Offline

Posting Whiz in Training

Re: Difference b/w sql server 2000 and sql 2005

Jan 22nd, 2008

a few years of development from the hard working folks @ Microsoft. Check out: http://sqljunkies.com/Tutorial/077C7...09F59D0F8.scuk

I think 05 also has some advanced BI features, but I have never looked for them nor tried to use them, so don't quote me on that (even though DW is quoting me here..)

--
"Dummy."

•

Join Date: Jun 2005

Location: Nothamptonshire

Posts: 27

Reputation: pclfw is an unknown quantity at this point

Rep Power: 4

Solved Threads: 1

pclfw

Offline

Light Poster

Re: Difference b/w sql server 2000 and sql 2005

Jan 25th, 2008

From a SQL client point of view there is very little difference.
The management side is completely changed. The Data Transformation Service (DTS) system has been replaces by the SQL System Integration Service (SSIS).

The GUI management system is much more integrated now with the functionality of both Enterprise Manager and Query Analyser in the same application (SQL Server Management Studio).

There are major differences in the indexing system and its maintenance. Though only an MS SQL expert would realy be interested in these.