can anybody tell me abt the difference b/w sql server 2000 and 2005
rajesh79 0 Newbie Poster
ericstenson 5 Posting Whiz in Training Team Colleague
a few years of development from the hard working folks @ Microsoft. Check out: http://sqljunkies.com/Tutorial/077C7BEB-EB31-4A07-923D-BE309F59D0F8.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..)
pclfw 23 Junior Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.