Upgrading to SQL 2005
Hi,
Can you please suggest a good link which describes the sql server2000 features that are not supported by sql server2005 and vice versa.
thanks in advance,
Nitu
[192 byte] By [NRP] at [2008-2-25] 
«« Reusing VB.NET Form dialogs in VC apps?
»» How to Remove the row from Report which does not have data in it?
»» How to Remove the row from Report which does not have data in it?
For SQL Server 2000 features that are not supported in SQL Server 2005, look at the topic "Deprecated Database Engine Features in SQL Server 2005 " in SQL Server 2005 Books Online. I also recommend the other topics in that section such as "Breaking Changes to Database Engine Features in SQL Server 2005 ". In addition, you should look at the topic "sp_dbcmptlevel" for more compatibility information between SQL Server 2000 and 2005.
Any new feature in 2005 will not be supported in SQL Server 2000. Topics that list new features can be found under the topic "Database Engine Enhancements " in Books Online.
Regards,
Gail
gaile at 2007-9-9 >
SQL Server Hot Topic
- Error deploying SSIS package to SQL Server
- SQL Server Date/Time & other data types
- Cannot insert explicit value for identity column
- HOWTO: Perform a Trace in SQL Server using SQL Profiler
- Using Unicode in SQL Server
- Stored proc & transaction log size problems!!!!!
- How to create a new SINGLE file .mdf in SSMS?
- Web Replication from SQL 2005 Express
SQL Server New Topic
- programmatically extend project tree
- How to generate snapshots from VB.NET
- In a list prompt
- Invalid snapshot-triggered data-driven subscription causes RS dump
- Management Studio Toolbox Usage
- Getting two different sets of data from one query to display products on Promo!
- Displaying the output horzontally (Related to KB Article 875518)
- Keep Identity on Merger Replication?
SQL Server
- SQL Server Integration Services
- Data Mining
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Tools General
- Transact-SQL
- .NET Framework inside SQL Server
- SQL Server Data Access
- SQL Server SMO/DMO
- SQL Server XML
- SQL Server Replication
- SQL Service Broker
- SQL Server Security
- SQL Server Database Engine
- SQL Server Documentation
- SQL Server Setup & Upgrade
- SQL Server Disaster Recovery and Availability
- SQL Server Notification Services
- SQL Server Compact Edition
- Getting started with SQL Server
- Database Mirroring
- SQL Server Express
Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech
Site Classified
- SQL Server
- Windows Forms
- .NET Development
- Visual Basic
- Visual Studio
- Visual Studio Team System
- Visual Studio Orcas
- Visual Studio Express Editions
- Software Development for Windows Vista
- Visual C#
- Visual C++
- Smart Device Development
- SharePoint Products and Technologies
- Feedback for forums and MSDN websites
- Game Technologies: DirectX, XNA, XACT, etc.
- Visual Studio Tools for Office
- Windows Live Developer Forums
- Microsoft ISV Community Center Forums
- Internet Explorer Development
- Visual FoxPro
- Windows Search Technologies
- Audio and Video Development
- Architecture
- Commerce Server
- Gadgets
- Microsoft Robotics Studio
- Community Chat
- BizTalk Server
- Visual J#
- Windows Networking Development
- Silverlight (formerly WPF/E)
- Popfly
- SQL Server Katmai
- Connected Services Framework
- Office Live Development
- Customer Care Framework
- Incubation Technologies
- Software Engineering Discussion
- System Center
- Software Licensing and Protection Services
- Visual Studio Rosario
- Small Business Application Development
- Office
- Windows Server 2008
- JScript
- Storage Platform – Core
- Misc