According to this article, Visual Studio 2010 no longer supports SQL Server 2000. However, it's a bit less clear on whether the runtime (and things like ASP.net 4.0, Linq2SQL and EF) will work with it. It seems that only the design-time features require SQL Server 2005 or greater according to that article.
I have a project that requires SQL Server 2000 because it has some legacy SQL Server Extended Procs that don't seem to work in later versions of SQL Server (causes crashes, and I don't have the source to the extended procs). I can do my design work in SQL Server 2005 or 2008 as I don't need the xp's at design time. But I need to know if the final compiled app will function on SQL Server 2000 or not if I use ASP.NET 4.0 and Linq2SQL or EF.
Anyone have any experience getting this to work?
Alternatively, if it did not work, could I get around the problem by using a second install of SQL Server that is SQL Server 2008 and uses linked tables to the SQL 2000?