Visual Studio 2005 (.NET 2.0) supports SQL Server 2000?
We would like starting our new developments with Visual Studio 2005 (.NET 2.0) BUT can not migrate our database to SQL Server 2000 (because, to my knowledge SQL Server 2005 doesn't support Microsoft Project Server 2003?!).
Therefore is SQL Server 2000 (officially) supported by Visual Studio 2005?
Guy
[306 byte] By [
gdillen] at [2007-12-16]
You can do SQL development using the database projects. Be careful that you select the database project form the "other project types" part of the new project dialog. The one you find in the C# or VB sections all refer to SQL2005 projects to create .NET stored procedures and stuff for SQL 2005 and those won't work on 2000 of course :-)
With the large investmenst customers have in SQL 2000 it seems very unlikely that this is not officialy supported.