I am using Visual Studio.Net 2008 Std edition with SQL Server 2008 Express. If I try to add a local database (db.mdf) to the project it returns an error (see attached image).
Running the query in the code snippet in MSSMS, I get a result telling me that I have MS SQl Express Edition with Advanced Services running. (10.0.1600.22, RTM, Express Edition with Advanced Services). The test query comes straight from Microsoft's KB article http://support.microsoft.com/kb/321185/
where it is under the section "How to determine which version of SQL Server 2008 is running".
It therefore appears that I should be able to add the local database. I'd appreciate it if someone could tell me why I am getting the error shown.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')