•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 427,219 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,241 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 2049 | Replies: 2
 |
•
•
Join Date: Dec 2007
Posts: 10
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
can anybody tell me abt the difference b/w sql server 2000 and 2005
•
•
Join Date: Dec 2007
Posts: 287
Reputation:
Rep Power: 1
Solved Threads: 28
Posting Whiz in Training
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..)
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."
"Dummy."
•
•
Join Date: Jun 2005
Location: Nothamptonshire
Posts: 27
Reputation:
Rep Power: 4
Solved Threads: 1
Light 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.
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.
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ad advertising ajax architecture asp backup beta business centro crash daniweb database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values dell developer development doubleclick enterprise google hacker hyper-v internet linux longhorn mail management studio 2005 microsoft mmorpg msdn news novell office open qmail red hat rhel security server server 2008 smtp software sql sql cache dependency with polling-based invalidation survey suse vista vmware windows windows server
- SOAP processing with java (OLAP) (RSS, Web Services and SOAP)
Other Threads in the MS SQL Forum
- Previous Thread: Difference b/w stored proc and functions
- Next Thread: Help please...User passwords lost
